US 8,949,291 B2Granted

Automatic conversion of multidimentional schema entities

AssigneeSap SE

InventorsJames Michael Amulu, Praneeth Chennuru, Anirban Dey, Lalitendu Samantray

Life of this patent

Estimating the term…

Loading patent…

Abstract

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.

Claims20

Dependent claims

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.

8 more elements

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.

3 more elements

Dependencies are inferred from the claim text.

Facts

Application: 13/909,139Filed 4 Jun 2013 · division
Priority: 3 Dec 2010
Published: US 2013/0275449 A117 Oct 2013
Granted: 3 Feb 2015
Term ends: Not estimatedThe source records don’t support an estimate.

Classification5 codes

G06F 16/211
Design, administration or maintenance of databases: schema design and management
G06F 16/84
Of semi-structured data, e.g. markup language structured data such as SGML, XML or HTML: mapping; Conversion
G06Q 10/0637
Operations research, analysis or management: strategic management or analysis, e.g. setting a goal or target of an organisation; Planning actions…
G06F
Computing and data processing

Family

Application12/959,381Parent of this division · filed 3 Dec 2010
US 2013/0275449 A1Pre-grant publication · published 17 Oct 2013
US 8,484,255 B2Parent of this division
US 2012/0143831 A1Published application
US 8,949,291 B2This patent

From the US filing history. Foreign family members aren’t listed.