Patent ID: 8230329

Claim:
A computer-implemented method comprising: hierarchically representing financial data within a financial transaction system by way of a fact data structure, a balance data structure and a cube data structure, the fact data structure storing fact values each of which aggregate multiple transactions, the balance data structure storing balance values each of which aggregate a plurality of transactions and the cube data structure storing cube slices each of which summarize balance values for a reporting unit of a plurality of reporting units of an organizational hierarchy; interactively updating a folio on-demand for the organizational hierarchy with aggregated information from pre-summarized balances by responsive to user-generated folio-level queries which depend upon balance values not currently stored within the financial transaction system, dynamically creating and populating, by a balance manager, a plurality of instances of balance data structures (balances) with the new balance values based on transactions encompassed by the user-generated folio-level query; responsive to availability of new transaction data upon which one or more of the balance values of the balances depend, maintaining, by the balance manager, clean balance values within the one or more balances by regenerating the one or more balance values; and responsive to a user-generated folio-level query, dynamically creating and populating, by a cube manager, an instance of a cube data structure (a cube) 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; and wherein the balance manager and the cube manager are implemented in one or more processors of one or more computer systems and one or more computer-readable storage media of the one or more computer systems, the one or more computer-readable storage media having instructions tangibly embodied therein representing the balance manager and the cube manager that are executable by the one or more processors.