IP Library Granted Patent US 9,922,300
Granted Patent B2
US 9,922,300 · App. 14/151,488 · Granted Mar 20, 2018

Enterprise performance management planning operations at an enterprise database

Inventors: Jan Rittinger (Walldorf, DE); Bernhard Jaecksch (Walldorf, DE); Daniel Merkel (Walldorf, DE); Gerrit Simon Kazmaier (Metzingen, DE); Lars Volker (Walldorf, DE); Stefan Uhrig (Walldorf, DE); Yeonghee Choi (Seoul, KR)
Assignee: SAP SE
G06Q10/0637
View Patent ↗
Loading inventors, assignments & file history…
Monitor This Case
Get email alerts when status or documents change.
Order Certified Copies
Most orders are placed with the USPTO same day — all within 24 business hours.
Order via The Patent Place →
Pre-filled with this patent's details
Quick Facts
Patent No.
US 9,922,300
App. No.
14/151,488
Granted
Mar 20, 2018
Kind
B2
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.

Claims (36)

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.

Assignments (2)
CHANGE OF NAME Recorded Aug 26, 2014
From: SAP AG
To: SAP SE
Reel/Frame 033625/0223 →
ASSIGNMENT OF ASSIGNOR'S INTEREST Recorded Jan 9, 2014
From: RITTINGER, JAN; JAECKSCH, BERNHARD; MERKEL, DANIEL; KAZMAIER, GERRIT SIMON; VOLKER, LARS; UHRIG, STEFAN; CHOI, YEONGHEE
To: SAP AG
Reel/Frame 031957/0465 →
Continuity (2)
Provisional Application 61909003 · Nov 26, 2013
Related Publication 20150149258A1 · May 28, 2015