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
Solid-state image sensing apparatus and electronic apparatus
Data communication apparatus, method of controlling the same, program, and storage medium
Configuration method and system of complex network and configuration and management module of server resources
Pressing mold for optical lenses and method for manufacturing glass optical lenses
Carbonyl-ene functionalized polyolefins
SMS transport resource control
Hydrostatic pad pressure modulation in a simultaneous double side wafer grinder
  Randomly Featured Patents
Ultrasonic liquid interface detector
Golf ball
Switched full-duplex ethernet type communication network and implementation process for this network
Cable protection and method for mounting a cable protection
Dough cutting apparatus
Frictionally damped suspension strut
Transition metal donor complexes and olefin polymerization process
Van mat
Adaptive coding level control for video compression systems
Chocolate candy in the shape of a bear