Enterprise performance management planning operations at an enterprise database

Patent metadata

Field	Value
Publication number	US-9922300-B2
Application number	US-201414151488-A
Country	US
Kind code	B2
Filing date	Jan 9, 2014
Priority date	Nov 26, 2013
Publication date	Mar 20, 2018
Grant date	Mar 20, 2018

Abstract

According to some embodiments, input data may be received from a data source in an enterprise database in accordance with an enterprise performance management planning model, stored by a processor at the enterprise database. An operation may then be performed on the input data to produce a result. The result may then be stored in a data target, wherein the data target points to a data holding entity in an instantiation of a plan data container at the enterprise database.

First claim

What is claimed is:

1. A method associated with an enterprise database, comprising:
receiving input data from a data source in the enterprise database in accordance with an enterprise performance management planning model, stored by a processor at the enterprise database;
performing an operation on the input data at the enterprise database to produce a predicted result, wherein the predicted result is transmittable outside the enterprise database and the input data remains inside the enterprise database;
providing an instantiation of a prediction-specific plan data container at the enterprise database to receive the predicted result, wherein the plan data container is an in-database store that defines a structure for the predicted result; and
storing the predicted result in a data target, wherein the data target points to a data holding entity in the instantiation of the plan data container at the enterprise database.

2. The method of claim 1 , wherein the operation comprises a copy operation to automatically copy, at the enterprise database, information into the instantiation of the plan data container, wherein the copy operation includes a flag indicating if input data is to be aggregated.

3. The method of claim 1 , wherein the operation comprises a disaggregation operation to automatically create, at the enterprise database, a plurality of disaggregation values, wherein the disaggregation operation includes a proportion field defining disaggregation proportions.

4. The method of claim 1 , wherein the operation comprises a currency conversion operation to automatically convert, at the enterprise database, a plurality of different currency values into values of a single consolidation currency.

5. The method of claim 1 , wherein the operation comprises an elimination operation to automatically identify, at the enterprise database, entries to be associated with an elimination entry.

6. The method of claim 5 , further comprising:
automatically performing, at the enterprise database based on group hierarchy information, a hierarchy transformation to create at least one elimination node.

7. The method of claim 6 , further comprising:
automatically posting, at the enterprise database, the elimination entry to the elimination node.

8. The method of claim 1 , wherein the structure reflects at least one dimension and at least one measure of the result.

9. A non-transitory computer-readable medium storing program code, the program code executable by a computing system storing an enterprise database structure, the program code when executed by the computing system cause the computing system to:
receive input data from a data source in the enterprise database in accordance with an enterprise performance management planning model;
perform an operation on the input data at the enterprise database to produce a predicted result, wherein the predicted result is transmittable outside the enterprise database and the input data remains inside the enterprise database;
provide an instantiation of a prediction-specific plan data container at the enterprise database to receive the predicted result, wherein the plan data container is an in-database store that defines a structure for the predicted result; and
store the predicted result in a data target, wherein the data target points to a data holding entity in the instantiation of the plan data container at the enterprise database.

10. The medium of claim 9 , wherein the operation comprises a copy operation to automatically copy, at the enterprise database, information into the instantiation of the plan data container, wherein the copy operation includes a flag indicating if input data is to be aggregated.

11. The medium of claim 9 , wherein the operation comprises a disaggregation operation to automatically create, at the enterprise database, a plurality of disaggregation values, wherein the disaggregation operation includes a proportion field defining disaggregation proportions.

12. The medium of claim 9 , wherein the operation comprises a currency conversion operation to automatically convert, at the enterprise database, a plurality of different currency values into values of a single consolidation currency.

13. The medium of claim 9 , wherein the operation comprises an elimination operation to automatically identify, at the enterprise database, entries to be associated with an elimination entry.

14. The medium of claim 13 , wherein execution of the instruction further cause the computer system to:
automatically performing, at the enterprise database based on group hierarchy information, a hierarchy transformation to create at least one elimination node.

15. The medium of claim 14 , wherein execution of the instruction further cause the computer system to:
automatically posting, at the enterprise database, the elimination entry to the elimination node.

16. A system, comprising:
an enterprise database, containing: actual business data, and
an instantiation of a prediction-specific plan data container to receive a predicted result;
a platform coupled to the enterprise database storage element, the platform being adapted to: (i) receive input data from a data source in the enterprise database in accordance with an enterprise performance management planning model, the input data including at least some of the actual business data, (ii) perform an operation on the input data at the enterprise database to produce the predicted result, wherein the predicted result is transmittable outside the enterprise database and the input data remains inside the enterprise database, and wherein the plan data container is an in-database store that defines a structure for the predicted result and (iii) store the predicted result in a data target, wherein the data target points to a data holding entity in the instantiation of the plan data container.

17. The system of claim 5 , wherein the operation comprises a copy operation to automatically copy, at the enterprise database, information into the instantiation of the plan data container, wherein the copy operation includes a flag indicating if input data is to be aggregated.

18. The system of claim 5 , wherein the operation comprises a disaggregation operation to automatically create, at the enterprise database, a plurality of disaggregation values, wherein the disaggregation operation includes a proportion field defining disaggregation proportions.

19. The system of claim 5 , wherein the operation comprises a currency conversion operation to automatically convert, at the enterprise database, a plurality of different currency values into values of a single consolidation currency.

20. The system of claim 5 , wherein the operation comprises an elimination operation to automatically identify, at the enterprise database, entries to be associated with an elimination entry.

21. The system of claim 20 , the platform being further to: (iv) automatically perform, based on group hierarchy information, a hierarchy transformation to create at least one elimination node; and (v) automatically post the elimination entry to the elimination node.

Assignees

• Rittinger Jan
• Jaecksch Bernhard
• Merkel Daniel
• Kazmaier Gerrit Simon
• Volker Lars
• Uhrig Stefan
• Choi Yeonghee
• Sap Se

Inventors

• Rittinger Jan
• Jaecksch Bernhard
• Merkel Daniel
• Kazmaier Gerrit Simon
• Volker Lars
• Uhrig Stefan
• Choi Yeonghee

Classifications

• G06Q10/0637 Primary

  Strategic management or analysis, e.g. setting a goal or target of an organisation; Planning actions based on goals; Analysis or evaluation of effectiveness of goals · CPC title