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
Synergistic fungicidal interactions of 5-fluorocytosine and other fungicides
Method and apparatus for optimizing paging in a communication network
Contamination barrier
Apparatus and method for transmitting and receiving data
Data transfer operation completion detection circuit and semiconductor memory device provided therewith
Wire guide
Electronic apparatus and manufacturing method of electronic apparatus
  Randomly Featured Patents
Certain (2-carboxy or 2-propenoic or 2-carbonyl)-3-halo-4,5-dioxy pyridine intermediates and the corresponding 1,4-dihydro-4-pyridones)
Process for the preparation of carboxylic acid succinimidyl esters
Model aircraft construction jig
Wireless speaker system for transmitting analog and digital information over a single high-frequency channel
Fuel injection system for internal combustion engines
Rhodococcus bacterium, nitrilase gene, nitrylhydratase gene and amidase gene from Rhondococcus bacterium, and process for producing carboxylic acids by using them
Method and apparatus for power control of multiple channels in a wireless communication system
Programmable RFID postage stamps
Method for preparing zinc-oligopeptide easily absorbable by the human body
Directly modulated semiconductor laser having reduced chirp