Systems and methods for a multi-level advanced caching engine that is designed for processing a high-volume of transaction data and ensuring high performance query processing is provided. A folio is interactively updated on-demand for an organizational hierarchy with aggregated information from pre-summarized balances. Responsive to user-generated folio-level queries which depend upon balance values not currently stored within the financial transaction system, multiple instances of balances are dynamically created and populated with new balance values based on the user-generated folio-level query. Responsive to new transaction data, clean balance values are maintained within the dependent balances by regenerating the associated balance values. Responsive to a user-generated folio-level query, an instance of a cube is dynamically created and populated having dimensions defined by parameters of the user-generated folio-level query and which aggregates the balance values of the balances into appropriate slices of the cube.