Using dimension substitutions in OLAP cubes

摘要

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.

主权项

1. A computer-implemented method implemented at least in part on a programmed processor and memory, the method comprising:
declaring, with the processor, a complex definition of a multidimensional analysis services cube, the multidimensional analysis services cube comprising a model stored in processor memory, the model comprising metadata determinative of a relationship between an original dimension of the multidimensional analysis services cube and a substitute dimension for the multidimensional analysis services cube; finding a substitution for a measure group for the multidimensional analysis services cube, the substitution involving the original dimension and the substitute dimension; creating a table in a data source view for the measure group; adding a property to the data source view comprising a primary key to the substitute dimension; and generating a query for the table comprising an inner join between the substitute dimension and the original dimension via the metadata of the model, the inner join logically linking the original dimension and the substitute dimension.