Automatic conversion of multidimentional schema entities
View Patent ↗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 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. In various embodiments, multidimensional schema entities are used to generate a report. Queries extract data from the multidimensional schema entities and load it in the report. The report is presented on a graphical user interface.
1. A computerized system including a processor, the processor communicating with one or more memory devices storing instructions, the instructions comprising:
a server module receiving data from one or more data sources;
a business intelligence module running on the server module to:
load the received data from the one or more data sources into one or more source objects;
receive metadata describing a first transformation between at least one data source from the one or more data sources and at least one source object from the one or more data sources, wherein the first transformation comprises a first set of transformation rules;
create at least one target object, by processing source object metadata, for at least one of converting and merging of the one or more source objects;
create a second transformation, corresponding to the first transformation, between the at least one data source and the at least one target object, wherein the second transformation defines delta initialization for one or more target object elements without data load between the at least one data source and the at least one target object, wherein the one or more target object elements correspond to data changed within the first transformation between the at least one data source and the at least one source object;
create a third transformation between the at least one source object and the at least one target object; and
generate one or more reports based on at least one query executed against at least one of the at least one target object and the one or more source objects to extract data loaded according to one or more of the first transformation, the second transformation and the third transformation; and
a graphical user interface receiving the one or more reports from the business intelligence module.
2. The computerized system of claim 1 , wherein the business intelligence module comprises:
a queries module operable to extract data from the at least one of the at least one target object and the one or more source objects via one or more queries; and
a query designer module to create the one or more queries.
3. The computerized system of claim 1 , wherein the business intelligence module further comprises:
a reports module to generate the one or more reports; and
a graphical user interface export module to receive data from the reports module.
4. The computerized system of claim 1 , wherein a first object of a set of the one or more source objects and the at least one target object has structure and semantics different from the structure and semantics of a second object of the set.
5. The computerized system of claim 1 , wherein the graphical user interface is further operable to present the one or more reports.
6. The computerized system of claim 1 , wherein the graphical user interface is further operable to present the at least one target object.
7. A computer implemented method comprising:
receiving metadata describing a first transformation between at least one data source and at least one source object, wherein the first transformation comprises a first set of transformation rules;
creating at least one target object, by processing source object metadata, for at least one of converting and merging the at least one source object;
creating a second transformation, corresponding to the first transformation, between the at least one data source and the at least one target object, wherein the second transformation defines delta initialization for one or more target object elements without data load between the at least one data source and the at least one target object, wherein the one or more target object elements correspond to data changed within the first transformation between the at least one data source and the at least one source object;
creating a third transformation between the at least one source object and the at least one target object; and
generating a report based on at least one query executed against one or more of the at least one target object and the at least one source object to extract data loaded according to one or more of the first transformation, the second transformation and the third transformation.
8. The method of claim 7 , further comprising:
executing the third transformation to load data to the at least one target object.
9. The method of claim 7 , further comprising deploying the at least one target object.
10. The method of claim 7 , further comprising:
executing the second transformation to load data to the at least one target object.
11. The method of claim 7 , wherein the report is presented in a graphical user interface.
12. The method of claim 7 , wherein creating the at least one target object comprises grouping elements from the source object metadata of the at least one source object based on a type of the at least one target object.
13. The method of claim 7 , wherein the at least one source object and the at least one target object have different structure and semantics.
14. 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 and merging of multidimensional schema entities comprising:
receiving metadata describing a first transformation between at least one data source and at least one source object, wherein the first transformation comprises a first set of transformation rules;
creating at least one target object, by processing source object metadata, for at least one of converting and merging the at least one source object;
creating a second transformation, corresponding to the first transformation, between the at least one data source and the at least one target object, wherein the second transformation defines delta initialization for one or more target object elements without data load between the at least one data source and the at least one target object, wherein the one or more target object elements correspond to data changed within the first transformation between the at least one data source and the at least one source object;
creating a third transformation between the at least one source object and the at least one target object; and
generating a report based on at least one query executed against one or more of the at least one target object and the at least one source object to extract data loaded according to one or more of the first transformation, the second transformation and the third transformation.
15. The computer readable storage medium of claim 14 , further comprising instructions for executing the third transformation to load data to the at least one target object.
16. The computer readable storage medium of claim 14 , further comprising instructions for deploying the at least one target object.
17. The computer readable storage medium of claim 14 , further comprising instructions for:
executing the second transformation to load data to the at least one target object.
18. The computer readable storage medium of claim 14 , wherein the report is presented in a graphical user interface.
19. The computer readable storage medium of claim 14 , wherein the instructions for creating the at least one target object comprises grouping elements from the source object metadata of the at least one source object based on a type of the at least one target object.
20. The computer readable storage medium of claim 14 , wherein the at least one source object and the at least one target object have different structure and semantics.