Resources Contact Us Home
Browse by: INVENTOR PATENT HOLDER PATENT NUMBER DATE
 
 
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
Heating pad
Victim port-based design for test area overhead reduction in multiport latch-based memories
Medical injector
Carbonate and carbamate modified forms of glucocorticoids in combination with .beta..sub.2 adrenergic agonists
Method and system for producing fluoride gas and fluorine-doped glass or ceramics
Agents for preventing and treating disorders involving modulation of the ryanodine receptors
Vanadium, cobalt and strontium additives for use in aluminum back solar cell contacts
  Randomly Featured Patents
Zoom lens
Display having horizontally rotatable display panel
Rivet fastener
Touch signal probe
Ion repulsion turbine
Illumination device having detachable lighting units
Electrothermal atomization furnace
Anti-shake apparatus with position detecting magnet
Electrical connector
Secondary beat signal cancel circuit