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
Monomethylvaline compounds capable of conjugation to ligands
Ambient presentation of surveillance data
Drilling fluid and methods
Channel-assignment for a multi-channel dual-radio mesh backhaul
Wireless AV transmission and receiver modules, portable wireless AV transmission and receiver devices, and AV source and playback devices
Electronic device and method of controlling the same
Reflective directional arrow
  Randomly Featured Patents
Method for realizing resource admission control at push mode in nomadism scene of NGN
Method and apparatus for making a corner bench in a tiled shower
Video gaming device and method of wagering on a virtual football game
Machining center
Organic produce wash system
Handy container-pan for instantly frizzlable dry foods
Apparatuses useful for printing and methods of treating marking material on media
Tag for a tool
Methods for treating dental diseases, disorders, and injuries
Decommutator patchboard verifier