×

Providing feedback in a operating plan data aggregation system

  • US 9,940,374 B2
  • Filed: 04/26/2005
  • Issued: 04/10/2018
  • Est. Priority Date: 04/26/2004
  • Status: Active Grant
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.

View all claims
  • 1 Assignment
Timeline View
Assignment View
    ×
    ×