Patent Document ID: 9223847
Application ID: 13414242
Patent Flag: 1

Claim One:
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.