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
Nuclear fuel assembly for boiling water reactor
Monolithic, optoelectronic semiconductor body and method for the production thereof
Mobile station apparatus, communication system and communication method
Mobility in a multi-access communication network
Transmitter control in communication systems
Task management for a plurality of team members
Runtime enforcement of security checks
  Randomly Featured Patents
Adjustable pump control linkage for pump driven vehicle
Method and apparatus for investigating a borehole using an array of elements
Automatic fiber blender
Oral treatment method for reducing plaque with reduced staining
System and method for the creation and rebalancing of beneficial interests in index tracking and other investment vehicles over multiple market periods using fixed or regularly resetting price
Transport system with tunable channel spacing DWDM
Device and method for producing a fiber composite
Conditional motion compensated interpolation of digital motion video
Semiconductor device
Amino acid derived prodrugs of propofol, compositions and uses thereof