Associating multidimensional data models
A source multidimensional data model is associated with a target multidimensional data model, for purposes of, for example, copying or linking data between the source and the target. Individual dimensions are mapped from the source to the target. Within each mapped dimension, individual dimension members are mapped from the source to the target. The resulting association may be stored and utilized to generate executable statements for copying or linking data between the source and the target.
1 . A method for associating two multidimensional data models, the method comprising:
receiving a source selection of a source multidimensional data model;
receiving a target selection of a target multidimensional data model;
receiving a dimension mapping, wherein the dimension mapping includes a first source dimension from the source multidimensional data model and a first target dimension from the target multidimensional data model;
receiving a member mapping, wherein the member mapping includes at least one source member from the first source dimension and a target member from the first target dimension; and
storing the source selection, the target selection, the dimension mapping, and the member mapping as parts of an association between the source multidimensional data model and the target multidimensional data model.
2 . The method of claim 1 , further comprising copying data from the source multidimensional data model to the target multidimensional data model utilizing the association.
3 . The method of claim 2 , wherein copying data from the source multidimensional data model to the target multidimensional data model comprises:
constructing a database query according to the association; and
executing the database query to copy data from the source multidimensional data model to the target multidimensional data model.
4 . The method of claim 2 , wherein copying data from the source multidimensional data model to the target multidimensional data model comprises:
creating a stored procedure according to the association; and
executing the stored procedure to copy data from the source multidimensional data model to the target multidimensional data model.
5 . The method of claim 1 , wherein receiving the member mapping includes:
receiving a selection of a plurality of source members for mapping to the target member; and
receiving an indication of an aggregation function for use in conjunction with the member mapping.
6 . The method of claim 1 , further comprising receiving a scoped dimension of a second source dimension, wherein the scoped dimension is limited to a single dimension member.
7 . The method of claim 1 , wherein receiving the dimension mapping includes:
displaying a source dimension list of available dimensions from the source multidimensional data model;
displaying a target dimension list of available dimensions from the target multidimensional data model;
receiving an indication of the first source dimension from the source dimension list; and
receiving an indication of the first target dimension from the target dimension list.
8 . The method of claim 7 , wherein receiving the member mapping includes:
displaying a source dimension member list of available dimension members from the first source dimension;
displaying a target dimension member list of available dimension member from the first target dimension;
receiving an indication of the at least one source member from the source dimension member list; and
receiving an indication of the target member from the target dimension member list.
9 . A system for associating multidimensional data models, the system comprising:
a data model association application, including instructions which, when executed by a processor, cause the processor to
receive a source selection of a source multidimensional data model,
receive a target selection of a target multidimensional data model,
receive a selection of a source dimension from a plurality of source dimensions associated with the source multidimensional data model,
receive a selection of a target dimension from a plurality of target dimensions associated with the target multidimensional data model, thereby indicating a dimension mapping between the source dimension and the target dimension,
receive a selection of at least one source dimension member from a plurality of source dimension members associated with the source dimension,
receive a selection of a target dimension member from a plurality of target dimension members associated with the target dimension, thereby indicating a member mapping between the at least one source dimension member and the target dimension member, and
store the source selection, the target selection, the dimension mapping, and the member mapping.
10 . The system of claim 9 , wherein the instructions further cause the processor to
display the plurality of source dimensions and the plurality of target dimensions, and
display the plurality of source dimension members and the plurality of target dimension members.
11 . The system of claim 9 , further comprising:
a database, wherein the source selection, the target selection, the dimension mapping, and the member mapping are stored therein.
12 . The system of claim 9 , wherein the instructions further cause the processor to
receive a selection of a second source dimension,
receive a selection of a dimension member of the second source dimension, thereby indicating a dimension scope, and
storing the dimension scope for the second source dimension.
13 . The system of claim 9 , wherein the instructions further cause the processor to utilize the source selection, the target selection, the dimension mapping, and the member mapping to copy data from the source multidimensional data model to the target multidimensional data model.
14 . The system of claim 13 , wherein copying data includes
utilizing the source selection, the target selection, the dimension mapping, and the member mapping to build a query, and
executing the query to copy data from the source multidimensional data model to the target multidimensional data model.
15 . The system of claim 9 , wherein receiving a selection of at least one source dimension member includes
receiving a selection of a plurality of source dimension members, and
receiving a selection of an aggregation function for mapping the plurality of source dimension members to the target dimension member.
16 . A computer storage medium storing computer-executable instructions which, when executed by a computer, cause the computer to:
retrieve the multidimensional data model association, wherein the multidimensional data model association includes
a source data model,
a target data model,
a plurality of dimension mappings, and
a plurality of member mappings;
generate one or more executable statements in order to copy data from the source data model to the target data model;
utilize the plurality of dimension mappings and the plurality of member mappings when generating the one or more executable statements; and
executing the executable statements.
17 . The computer storage medium of claim 16 , wherein the one or more executable statements comprise a structured query language (SQL) statement.
18 . The computer storage medium of claim 16 , wherein the one or more executable statements comprise a stored procedure.
19 . The computer storage medium of claim 16 , wherein the computer-executable instructions further cause the computer to, prior to generating one or more executable statements, determine that the one or more executable statements are in need of an update.
20 . The computer storage medium of claim 16 , wherein the computer-executable instructions further cause the computer to store the one or more executable statements with the multidimensional data model association.