主权项 |
1. A method of rendering a cube view related to a cube stored in a multi-dimensional data storage, the method comprising:
receiving a cube definition comprising a plurality of dimension members associated with the cube stored in the multi-dimensional data storage; receiving a specification for a cube configuration that includes a set of dimension members from the cube definition; displaying the cube view as an interactive matrix having rows and columns that represent two different dimensions, each dimension including a set of dimension members, wherein the interactive matrix further includes a group of cells that represent measures of the cube, each cell at an intersection of a column and a row representing a measure at the corresponding intersection of dimension members, each measure being displayed according to the measure's matching data value stored in a cube cache; receiving an input on the interactive matrix to display a set of additional data values regarding a dimension member, the input causing the interactive matrix to be associated with a set of empty cells for the set of additional data values; for each empty cell, analyzing the cube cache (i) to find a matching data value in the cube cache, and (ii) to add the empty cell to a cell queue if a matching data value is not stored in the cube cache; dynamically generating a set of queries for any empty cells in the cell queue by (i) evaluating, for each empty cell in the cell queue, the cube configuration and (ii) constructing the set of queries based on one or more of the sets of dimension members specified in the cube configuration; storing each data value returned as a result of performing the set of queries on the multi-dimensional data storage in the cube cache; and updating the interactive matrix by populating the set of empty cells with a set of matching data values from the cube cache. |