Providing feedback in a operating plan data aggregation system
First Claim
Patent Images
1. A computer implemented method for propagating information in real-time through OLAP cube database structures to reduce delays in predicting future orders or sales over defined time periods, the method comprising:
- for each of multiple organizations, dedicating an instance of one of the OLAP cube database structures and a data repository to each of the organizations;
partitioning of each of the OLAP cube database structures of a computer database into at least a first partition and a second partition;
performing using a computer system programmed with code stored in a memory and executing by a processor of the computer system to configure the computer system into a machine, for each of the multiple organizations;
receiving sales forecast information including forecast numerical values for at least one time period from one or more first entities in a computer, wherein the sales forecast information received forms a baseline forecast;
for each organization, storing the sales forecast information in the first partition of the OLAP cube database structure of the computer database dedicated to the organization;
for each organization, updating the first partition of the OLAP cube database structure of the computer database every time T1, wherein T1 is an amount of time and wherein the updating includes at least data from the second partition;
receiving comments on specific entries of the received sales forecast information from one or more second entities in the computer after receiving the sales forecast information from the one or more first entities;
receiving changes of the sales forecast information from the one or more second entities in the computer after receiving the sales forecast information from the one or more first entities, the changes including time based adjustments to the forecast numerical values;
for each organization, storing the changes in the second partition of the OLAP cube database structure of the computer database dedicated to the organization;
for each organization, updating the second partition of the OLAP cube database structure of the computer database every time T2, wherein T2 is an amount of time and T2 is less than T1 for each organization;
integrating the associated sales forecast information from the first partition, comments, and changes from the second partition into the OLAP cube database structure within the data repository defined in the computer and dedicated to the organization;
propagating the received sales forecast information from the first partition, the received comments, and the received changes of the sales forecast information from the second partition in essentially real-time through the OLAP cube database structure dedicated to the organization by the computer to (i) associate the received comments and changes with the received sales forecast information and (ii) asynchronously update the baseline forecast with the received changes of the sales forecast information in essentially real-time;
generating a particular selected dataset and organization of the particular selected dataset from the OLAP cube database structure within the data repository including from the first partition and the second partition, which are dedicated to the organization, in response to a graphical interface based query from an external requestor wherein generating the particular selected dataset includes;
aggregating data related to changes from the first partition and the second partition to appear as a single response;
analyzing the changes to determine the magnitude of each change; and
providing a set of impacts to the one or more first entities, the impacts showing the changes based on the magnitude of the changes; and
transmitting data to display the generated particular dataset on a graphical interface device that incorporates the integrated comments and the integrated changes to the sales forecast information so that the comments and changes are shown and available for review in association with the sales forecast information including the essentially real-time, asynchronously updated baseline forecast.
2 Assignments
0 Petitions
Accused Products
Abstract
In one embodiment, a method is provided. The method includes receiving forecast information from sales people in a computer. The method further includes receiving comments on specific entries of the forecast information from non-sales people in the computer. The method also includes receiving changes of the forecast information from the non-sales people in the computer. The method additionally includes providing a display of the comments and the changes to the sales people in an interface to the computer.
-
Citations
48 Claims
-
1. A computer implemented method for propagating information in real-time through OLAP cube database structures to reduce delays in predicting future orders or sales over defined time periods, the method comprising:
-
for each of multiple organizations, dedicating an instance of one of the OLAP cube database structures and a data repository to each of the organizations; partitioning of each of the OLAP cube database structures of a computer database into at least a first partition and a second partition; performing using a computer system programmed with code stored in a memory and executing by a processor of the computer system to configure the computer system into a machine, for each of the multiple organizations; receiving sales forecast information including forecast numerical values for at least one time period from one or more first entities in a computer, wherein the sales forecast information received forms a baseline forecast; for each organization, storing the sales forecast information in the first partition of the OLAP cube database structure of the computer database dedicated to the organization; for each organization, updating the first partition of the OLAP cube database structure of the computer database every time T1, wherein T1 is an amount of time and wherein the updating includes at least data from the second partition; receiving comments on specific entries of the received sales forecast information from one or more second entities in the computer after receiving the sales forecast information from the one or more first entities; receiving changes of the sales forecast information from the one or more second entities in the computer after receiving the sales forecast information from the one or more first entities, the changes including time based adjustments to the forecast numerical values; for each organization, storing the changes in the second partition of the OLAP cube database structure of the computer database dedicated to the organization; for each organization, updating the second partition of the OLAP cube database structure of the computer database every time T2, wherein T2 is an amount of time and T2 is less than T1 for each organization; integrating the associated sales forecast information from the first partition, comments, and changes from the second partition into the OLAP cube database structure within the data repository defined in the computer and dedicated to the organization; propagating the received sales forecast information from the first partition, the received comments, and the received changes of the sales forecast information from the second partition in essentially real-time through the OLAP cube database structure dedicated to the organization by the computer to (i) associate the received comments and changes with the received sales forecast information and (ii) asynchronously update the baseline forecast with the received changes of the sales forecast information in essentially real-time; generating a particular selected dataset and organization of the particular selected dataset from the OLAP cube database structure within the data repository including from the first partition and the second partition, which are dedicated to the organization, in response to a graphical interface based query from an external requestor wherein generating the particular selected dataset includes; aggregating data related to changes from the first partition and the second partition to appear as a single response; analyzing the changes to determine the magnitude of each change; and providing a set of impacts to the one or more first entities, the impacts showing the changes based on the magnitude of the changes; and transmitting data to display the generated particular dataset on a graphical interface device that incorporates the integrated comments and the integrated changes to the sales forecast information so that the comments and changes are shown and available for review in association with the sales forecast information including the essentially real-time, asynchronously updated baseline forecast. - View Dependent Claims (2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15, 16, 17, 18, 19, 20, 21, 22, 23, 24, 25, 26, 27, 28, 29, 30, 31, 32, 33, 34, 35, 36, 37, 38, 39, 40)
-
-
41. A system for propagating information in real-time through OLAP cube database structures to reduce delays in predicting future orders or sales over defined time periods, the system comprising:
-
for each of multiple organizations, a dedicated instance of one of the OLAP cubes database structures and a data repository to each of the organizations; partitions of each of the OLAP cube database structures of a computer database into at least a first partition and a second partition; an analysis server having a processing unit and a memory coupled to the processing unit and further including the OLAP cube; an interface device coupled for communication with the analysis server to receive for each of the multiple organizations; forecast data; sales forecast information including forecast numerical values for at least one time period from one or more first entities in a computer, wherein the sales forecast information received represents a baseline forecast; comments on specific entries of the received sales forecast information from the one or more first entities, wherein the changes are received after receiving the sales forecast information from the one or more first entities; changes of the sales forecast information from the one or more second entities in the computer after receiving the sales forecast information from the one or more first entities, the changes including time based adjustments to the forecast numerical values;
wherein the analysis server is configured to;for each organization, store the sales forecast information in the first partition of the OLAP cube database structure of the computer database dedicated to the organization; for each organization, update the first partition of the OLAP cube database structure of the computer database every time T1, wherein T1 is an amount of time and wherein the update includes at least data from the second partition; for each organization, store the changes in the second partition of the OLAP cube database structure of the computer database dedicated to the organization; for each organization, update the second partition of the OLAP cube database structure of the computer database every time T2, wherein T2 is an amount of time and T2 is less than T1 for each organization; integrate the associated sales forecast information from the first partition, comments, and changes from the second partition into the OLAP cube within the data repository defined in the computer and dedicated to the organization; propagate the received sales forecast information from the first partition, the received comments, and the received changes of the sales forecast information from the second partition in essentially real-time through the OLAP cube database structure dedicated to the organization by the computer to (i) associate the received comments and changes with the received sales forecast information and (ii) asynchronously update the baseline forecast with the received changes of the sales forecast information in essentially real-time; generate a particular selected dataset and organization of the particular selected dataset from the OLAP cube database structure within the data repository including the first partition and the second partition, which are dedicated to the organization, in response to a graphical interface based query from an external requestor wherein generating the particular selected dataset includes; aggregating data related to changes from the first partition and the second partition to appear as a single response; analyzing the changes to determine the magnitude of each change; and providing a set of impacts to the one or more first entities, the impacts showing the changes based on the magnitude of the changes; and communicate the generated particular dataset that incorporates the integrated comments and the integrated changes to the sales forecast information to a client device having a graphical display so that the comments and changes are shown and available for review in association with the sales forecast information including the essentially real-time, asynchronously updated baseline forecast. - View Dependent Claims (42, 43, 44, 45)
-
-
46. A server computer having a processing unit and a memory coupled to the processing unit and having or coupled with a data repository and a database structure for propagating information in real-time through multi dimensional OLAP cube database structures to reduce delays in predicting future orders or sales over defined time periods, the server computer comprising:
-
for each of multiple organizations, a dedicated instance of one of the OLAP cubes database structures and a data repository to each of the organizations; partitions of each of the OLAP cube database structures of a computer database into at least a first partition and a second partition; a first input for receiving sales forecast information including forecast numerical values for at least one time period from one or more first entities in a computer, wherein the sales forecast information received represents a baseline forecast; a second input for receiving comments on specific entries of the received sales forecast information from one or more second entities in the computer after receiving the sales forecast information from the one or more first entities; a third input for receiving changes of the sales forecast information from the one or more second entities in the computer after receiving the sales forecast information from the one or more first entities, the changes including time based adjustments to the forecast numerical values; code stored in the memory and executable by the processing unit for propagating information in real-time for predicting future orders or sales over defined time periods, the code is executable by the processing unit to; for each organization, store the sales forecast information in the first partition of the OLAP cube database structure of the computer database dedicated to the organization; for each organization, update the first partition of the OLAP cube database structure of the computer database every time T1, wherein T1 is an amount of time and wherein the update includes at least data from the second partition; for each organization, store the changes in the second partition of the e OLAP cube database structure of the computer database dedicated to the organization; for each organization, update the second partition of the OLAP cube database structure of the computer database every time T2, wherein T2 is an amount of time and T2 is less than T1 for each organization; integrate the associated sales forecast information from the first partition, comments, and changes from the second partition into the OLAP cube database structure within the data repository defined in the computer and dedicated to the organization; propagate the received sales forecast information from the first partition, the received comments, and the received changes of the sales forecast information from the second partition in essentially real-time through the OLAP cube database structure dedicated to the organization by the computer to (i) associate the received comments and changes with the received sales forecast information and (ii) asynchronously update the baseline forecast with the received changes of the sales forecast information in essentially real-time to reduce delays in predicting future orders or sales over defined time periods; generate a particular selected dataset and organization of the particular selected dataset from the OLAP cube database structure within the data repository including the first partition and the second partition, which are dedicated to the organization, in response to a graphical interface based query from an external requestor wherein generating the particular selected dataset includes; aggregating data related to changes from the first partition and the second partition to appear as a single response; analyzing the changes to determine the magnitude of each change; and providing a set of impacts to the one or more first entities, the impacts showing the changes based on the magnitude of the changes; and transmit data to display the generated particular dataset on a graphical interface device that incorporates the integrated comments and the integrated changes to the sales forecast information so that the comments changes are shown and available for review in association with the sales forecast information including the essentially real-time, asynchronously updated baseline forecast. - View Dependent Claims (47, 48)
-
Specification