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
Skate guard
Thermal detector, thermal detection device, electronic instrument, and thermal detector manufacturing method
Multi-page sorting for menu items on a handheld
Method for curing addition curable organopolysiloxane composition
Encapsulation of electrodes in solid media for use in conjunction with fluid high voltage isolation
Plasma processing method and plasma processing apparatus
Radiological image detection apparatus and method of manufacturing the same
  Randomly Featured Patents
Fluid supply assembly
Beer mug
Welded aluminum alloy structure
Multiple degree of freedom damped hand controls
System and method for configuring a configurable product
Method of manufacturing array substrate of a liquid crystal display device
Method for forming double containment pipeline sections
Automated access telephone system
Accelerator pedal module
Leading-zero anticipator having an independent sign bit determination module