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
Interconnect, bus system with interconnect and bus system operating method
Method and apparatus for connecting to external device
Secondary battery pack including insulative mounting member into which PCM is inserted in lateral direction
Taste receptors of the T1R family from domestic cat
Electronic component mounting machine and operating instruction method for the same
Lead frame array package with flip chip die attach
Irreversible thermochromic ink compositions
  Randomly Featured Patents
Vehicle body
Extruded plastic window shutter outside mount frame molding
Micromachined membrane particle filter using parylene reinforcement
Surround view detector focal plane
Method of killing photobiotic plants
IR remote control code translator for enabling control of an electronic device with different format control codes
Adjustable furniture apparatus
Prefabricated dental onlays and method therefor
Setting audio parameters in a digital signal processor in an electronic device, and electronic device
Human-machine interface support of remote viewing sessions