摘要 |
An aggregated query is used to fetch data from a multidimensional database, such as an OLAP cube. The aggregated query combines individual queries that are used to fetch data from the multidimensional database into a single query. A determination is made as to what dimensions and hierarchies of the multidimensional database are used by the queries that are contained as cube functions within formulas in cells of a spreadsheet. Based on the dimensions and hierarchies that are used within the multidimensional database, a tuple for each of the individual queries is created that has the same dimensionality. These tuples having the same dimensionality are then combined to create the aggregated query.
|