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
.beta.-2 microglobulin as a biomarker for peripheral artery disease
Method of making a CIG target by cold spraying
Method for cutting C--Mn steel with a fiber laser
Imaging lens with three lens elements, and electronic apparatus having the same
Systems and methods for universal enhanced log-in, identity document verification and dedicated survey participation
Selection of hash lookup keys for efficient retrieval
Method for forming a semiconductor device using selective epitaxy of group III-nitride
  Randomly Featured Patents
Electric connector
Method for making coated article
Method of programming non-volatile semiconductor memory device
Method of analyzing cell samples, by creating and analyzing a resultant image
Rip guide for a circular saw
Visual database system
Heating acupuncture needle
Thermography camera configured for leak detection
Chest multisensor array
Method for coating and assembling substrates of different charactertistics into an integral body having substantailly consistent gloss characteristics