Using Dimension Substitutions in OLAP Cubes
First Claim
1. A computer-implemented framework comprising a programmed processor and memory, the processor declaring a complex definition of a multidimensional analysis services cube, the framework comprising a model stored in processor memory, the multidimensional analysis services cube using substitute dimensions including generating a query containing an inner join between a substitute dimension and an original dimension.
2 Assignments
0 Petitions
Accused Products
Abstract
Systems, methods and computer program products that provide a framework for the creation, editing, manipulation and use of model-based, multidimensional analysis services (MAS) cubes and using substitute dimensions in such cubes are disclosed. To permit a user to obtain better and automatic access to business intelligence, a method of generating a model-based MAS cube comprises creating a data source comprising a data warehouse in the memory via the processor, creating a data source view providing a dimension, a fact and an outrigger from the created data source, and creating the MAS cube comprising at least one measure group. Using substitute dimensions comprises finding all relevant substitutions for a measure group, creating a table for the measure group in the data source view, adding a property as the primary key of the substitute dimension and generating a query containing an inner join logical link between the substitute and original dimension.
-
Citations
20 Claims
- 1. A computer-implemented framework comprising a programmed processor and memory, the processor declaring a complex definition of a multidimensional analysis services cube, the framework comprising a model stored in processor memory, the multidimensional analysis services cube using substitute dimensions including generating a query containing an inner join between a substitute dimension and an original dimension.
-
9. A computer-implemented method implemented at least in part on a programmed processor and memory, the processor declaring a complex definition of a multidimensional analysis services cube, the cube comprising a model stored in processor memory, the multidimensional analysis services cube using substitute dimensions including generating a query containing an inner join between a substitute dimension and an original dimension, the method comprising the steps of:
-
(a) finding relevant substitutions for an associated measure group of a management pack file during deployment of the management pack; (b) creating a table in a data source view for a measure group of the management pack using an analysis management object application programming interface; (c) adding a property to the data source view comprising a primary key to a substitute dimension; and (d) generating a query for the table in the data source view containing the inner join, the inner join logically linking an original dimension and the substitute dimension. - View Dependent Claims (10, 11, 12, 13, 14, 15, 16)
-
-
17. A computer program product comprising computer usable medium encoded in a computer having control logic stored therein including a framework for causing the computer to automatically generate a complex definition of a multidimensional analysis services cube, the cube comprising a model stored in processor memory, the multidimensional analysis services cube using substitute dimensions including generating a query containing an inner join between a substitute dimension and an original dimension, the computer program product comprising:
-
first computer readable program code means for finding relevant substitutions for an associated measure group of a management pack file during deployment of the management pack; second computer readable program code means for creating a table in a data source view for a measure group of the management pack using an analysis management object application programming interface; third computer readable program code means for adding a property to the data source view comprising a primary key to a substitute dimension; and fourth computer readable program code means for generating a query for the table in the data source view containing the inner join, the inner join logically linking an original dimension and the substitute dimension. - View Dependent Claims (18, 19, 20)
-
Specification