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
Robot control device
Method for switching between virtualized and non-virtualized system operation
Method for driving electrophoretic display device, electrophoretic display device, and electronic device
Method of forming an isolation structure
Antimony and germanium complexes useful for CVD/ALD of metal thin films
Microfluidic system incorporating a metal impregnated nanoporous material in a microfluidic pathway thereof
Magnetoresistive shield with coupled lateral magnet bias
  Randomly Featured Patents
Diode-pumped solid-state laser in a polyhedronal geometry
Method and apparatus for treating exhaust gas
Radio-wave clock
Corner patch support
High pressure, high temperature back-up with a circumferential relief
Expansion clamping chuck
System for determining performance on an exercise rowing machine
Balancer for multistage centrifugal pumps
Automated seal oil by-pass system for hydrogen cooled generators