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
Presenting a link to a user
Co-crystals of agomelatine, a process for there preparation and pharmaceutical compositions containing them
System, device and method for transrating file based assets
Representing polarized light in computer models
Information processing apparatus, non-transitory computer-readable recording medium, and information processing method
Semiconductor memory system having ECC circuit and controlling method thereof
  Randomly Featured Patents
Package-on-package system with through vias and method of manufacture thereof
Ink ribbon cassette
Flexible basecoat/clearcoat coating compositions
Semiconductor device, routing method and manufacturing method of semiconductor device
Utilizing E-mail response time statistics for more efficient and effective user communication
Process for producing seasoning
Thin film of amorphous alloy
Non-settling , universal machine dispensable pearlescent pigment dispersions
Process for methoxymethylation of phenolic hydroxyl groups
Method and apparatus for treating cardiac tachyarrhythmia