Resources Contact Us Home
Calculation engine for use in OLAP environments

Image Number 4 for United States Patent #7062479.

This invention addresses the need for dealing with complex planning calculations based on data warehouse or Planning Data Repository (PDR) data where some aggregated data or forecast data might be changed without directly manipulating the underlying data, and where there may be several relationships linking the data. The system is able to deal with complex relationships along more than one axis or dimension. A number of iterations are typically used involving both back-solving and `forward-solving`. The subset of cells that needs to be recalculated is identified before steps of back-solving and/or forward-solving using parent/child tables. The scanning of these tables looking for potential dependencies is much simpler and faster than to looking at the actual formulae or functions relating the cells. The step of creating the parent/child tables is carried out in advance of the actual calculation by parsing all the relationships (formulae and functions) and summarising the dependencies between cells in the parent/child tables.

  Recently Added Patents
Method for manufacturing light emitting diodes
Input device with photodetector pairs
Proximity-based mobile message delivery
Hemostatic devices and methods of making same
Method for remotely measuring fluctuations in the optical index of refraction of a medium
Combination therapy to enhance NK cell mediated cytotoxicity
Method and system for billing based on color component histograms
  Randomly Featured Patents
Encapsulated photoelectric measuring system
Reinforced thermoplastic storage vessel manufacture
Snowboard boot strap anchor
Protective casing for electrical devices
Composite high-pressure tube and method of manufacturing the tube
Electronic device with serial ATA interface and power saving method for serial ATA buses
Diaminopyrimidines as P2X.sub.3 and P2X.sub.2/3 modulators
Pulley unit
Systems and methods for generating sets of model objects having data messaging pipes
Steam trap failure detector