Real-time operating plan data aggregation
First Claim
Patent Images
1. A system comprising:
- a first client;
an analysis server incorporating an OLAP cube coupled to the first client;
a first customer database of information coupled to the analysis server, the first customer database is to embody forecast data and to receive essentially real-time updates to the forecast data, the forecast data including at least one estimated future value, the OLAP cube to analyze and update the information of the first customer database, and the OLAP cube including a main partition and a change partition, changes of the database being incorporated into the change partition;
new data of the database is entered with a change state flag when such new data is submited, the change state flag indicating a change state of the data wherein a first change state identifies that the data has changed and has been moved from the change partition to the main partition, and a second change state identifies that the data has changed and has not be moved from the change partition to the main partition; and
the change partition is aggregated by the OLAP cube on a first predetermined time interval, the aggregating of the change partition does not include aggregating entries of the change partition into the main partition.
3 Assignments
0 Petitions
Accused Products
Abstract
In one embodiment, a system is provided. The system includes a first client. The system also includes an analysis server coupled to the first client. The system further includes a first customer database of information coupled to the analysis server. The first customer database is to embody forecast data and to receive essentially real-time updates to the forecast data. The first customer database supports an OLAP cube associated with the analysis server.
37 Citations
22 Claims
-
1. A system comprising:
-
a first client; an analysis server incorporating an OLAP cube coupled to the first client; a first customer database of information coupled to the analysis server, the first customer database is to embody forecast data and to receive essentially real-time updates to the forecast data, the forecast data including at least one estimated future value, the OLAP cube to analyze and update the information of the first customer database, and the OLAP cube including a main partition and a change partition, changes of the database being incorporated into the change partition; new data of the database is entered with a change state flag when such new data is submited, the change state flag indicating a change state of the data wherein a first change state identifies that the data has changed and has been moved from the change partition to the main partition, and a second change state identifies that the data has changed and has not be moved from the change partition to the main partition; and the change partition is aggregated by the OLAP cube on a first predetermined time interval, the aggregating of the change partition does not include aggregating entries of the change partition into the main partition. - View Dependent Claims (2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13)
-
-
14. A method of maintaining information, comprising:
-
receiving a set of forecast data, wherein the forecast data includes at least one estimated future value; incorporating the forecast data into a database of the information through and OLAP cube; extracting a baseline forecast from the database, a baseline forecast including a forecast data reference point is generated by marking or logically grouping the relevant changes that make up the baseline; receiving updates to the database; propagating updated in a change partition of the OLAP cube, a username and a timestamp information being maintained for the data entered and when processing the entered data to the main partition of the OLAP; flagging data updated in the database with a change state flag, the change state flag indincating a change state of the data wherein a first change state identifies that the data has moved from the change partition to the main partition, and a second change state identifies that the data has not moved from the change partition to the main partition, the change state flag facilitating real-time operation of the system; aggregating changes from the change partition into a main partition of the OLAP cube on a first predetermined time interval, the aggregating of the change partition does not include aggregation entries of the change partition into the main partition; and unflagging the change state flag of data updated in the database. - View Dependent Claims (15, 16, 17, 18, 19, 20, 21)
-
-
22. A computer program stored in a computer readable media including executable instructions for performing a method of maintaining information, the method comprising:
-
receiving a set of forecast data, wherein the forecast data includes at least one estimated future value; incorporating the forecast data into a database of the information through an OLAP cube; extracting a baseline forecast from the database, a baseline forecast including a forecast data reference point is generated by marking or logically grouping the relevant changes that make up the baseline; receiving updates to the database; propagating updates in a change partition of the OLAP cube, a username and a timestamp information being maintained for the data entered and when processing the entered data to the main partition of the OLAP; flagging data updated in the database with a change state flag, the change state flag indicating a change state of the data wherein a first change state identifies that the data has moved from the change partition to the main partition, and a second change state identifies that the data has not moved from the change partition to the main partition, the change state flag facilitating real-time operation of the system; aggregating changes from the change partition into a main partition of the OLAP cube on a first predetermined time interval, the aggregating of the change partition does not include aggregating entries of the change partition into the main partition; and unflagging the change state flag of data updated in the database.
-
Specification