Automatic conversion of multidimentional schema entities
In various embodiments, a system receives a multidimensional schema entity of a first type and converts the multidimensional schema entity to a second type. The system receives user input and converts the multidimensional schema entity to the second type based on the input received from the user. In various embodiments, the system creates multidimensional schema entities automatically. In various embodiments, a method for converting multidimensional schema entities from one or more types to one or more other types is described. In various embodiments, a first multidimensional schema entity is analyzed and converted to a different type based on the analysis. In various embodiments, a multidimensional schema entity is created automatically based on input from two other multidimensional schema entities. In various embodiments, two multidimensional schema entities are merged in one multidimensional schema entity.
1. A non-transitory computer readable storage medium having computer readable instructions tangibly stored thereon which when executed by the computer, cause the computer to perform automatic conversion of multidimensional schema entities comprising:
receiving a source object and source object metadata;
receiving transformation metadata of a first transformation between a data source of the source object and the source object, wherein the first transformation comprises a first set of transformation rules;
creating a target object for converting the source object by processing the received source object metadata;
creating a second transformation, corresponding to the first transformation, between the data source of the source object and the target object;
receiving metadata of a first data transfer process related to the first transformation;
creating a second data transfer process from the data source for a set of member elements of the target object;
creating a third data transfer process associated with the second transformation with delta initialization without data load between the data source of the source object and the target object for one or more target object member elements from the set of member elements from the target object, wherein the one or more target object member elements correspond to changed data within the first transformation created between the data source and the source object;
creating a third transformation and a fourth data transfer process between the source object and the target object for transferring data from the source object to the target object; and
executing the fourth data transfer process.
2. The computer readable storage medium of claim 1 , further comprising instructions for deploying one or more created target objects.
3. The computer readable storage medium of claim 1 , further comprising instructions for grouping elements of the source object metadata based on a type of target object.
4. The computer readable storage medium of claim 1 , further comprising instructions for deleting the fourth data transfer process.
5. A computer implemented method for merging multidimensional schema entities, comprising:
receiving a first source object and first source object metadata and a second source object and a second source object metadata;
receiving transformation metadata of a first transformation between a first data source and the first source object and a second transformation between a second data source and the second source object;
grouping one or more elements of the first source object metadata and the second source object metadata based on a type of a target object;
creating the target object using one or more elements of the first source object metadata and the second source object metadata;
creating one or more data transfer processes between the first data source of the first source object and the target object and between the second data source of the second source object and the target object, wherein the one or more data transfer processes comprise one or more transformations corresponding to the first transformation between the first data source and the first source object and the second transformation between the second data source and the second source object;
creating one or more data transfer processes between the first source object and the target object and between the second source object and the target object; and
executing the one or more data transfer processes between the first data source and the target object and between the second data source and the target object; and
executing the one or more data transfer processes between the first source object and the target object and between the second source object and the target object.
6. The computerized method of claim 5 , further comprising validating the target object.
7. The computerized method of claim 5 , further comprising deploying one or more target objects.
8. The computerized method of claim 5 , wherein creating one or more data transfer processes between the first data source and the target object and between the second data source and the target object comprises:
creating a fifth data transfer process between the first data source and the target object without data initialization; and
creating a sixth data transfer process between the second data source and the target object without data initialization.
9. The computerized method of claim 5 , further comprising:
creating a third transformation and a fourth transformation for the target object based on the first transformation metadata and the second transformation metadata for one or more elements of the target object.
10. The computerized method of claim 5 , further comprising:
creating a fifth transformation and a seventh data transfer process between the first source object and the target object; and
creating a sixth transformation and an eighth data transformation process between the second source object and the target object.
11. The computerized method of claim 10 , further comprising:
deleting the fifth transformation and the sixth transformation; and
deleting the seventh data transfer process and the eighth data transformation process.
12. A computer system for automatic conversion of multidimensional schema entities comprising a processor, the processor communicating with one or more memory devices storing instructions, the instructions comprising:
a graphical user interface to receive requests for conversion of data source objects of different types;
a server module to receive one or more data sources; and
a business intelligence module associated with the server module to:
transform a data source from the one or more data sources to a source object according to a first transformation comprising a set of transformation rules;
create a target object for converting the source object;
create a second transformation, corresponding to the first transformation, between the data source of the source object and the target object;
receive metadata of a first data transfer process related to the first transformation;
create a second data transfer process from the data source for a set of member elements of the target object;
create a third data transfer process associated with the second transformation with delta initialization without data load between the data source of the source object and the target object for one or more target object member elements from the set of member elements from the target object, wherein the one or more target object member elements correspond to changed data within the first transformation created between the data source and the source object;
create a third transformation and a fourth data transfer process between the source object and the target object for transferring data from the source object to the target object; and
execute the fourth data transfer process.