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
Method and apparatus for executing load distributed printing
Device and method for unified codes
Method and device for detecting the dysfunction of a gas pressure sensor in a vehicle tire
Push mechanism for efficiently sending aggregated data items to client
Sabatier process and apparatus for controlling exothermic reaction
Process for producing .beta.-sialon fluorescent material
Coated article and method for making the same
  Randomly Featured Patents
Medium where status information printing program is recorded, printer, print controller, status information printing method, and status information printing system
Selecting modulation and amplification in a transmitter
Apparatus for monitoring SO.sub.2 concentrations
Aminofunctional silicone compositions and methods of use
Weighted leg exerciser
Alternator-rectifier unit with higher voltage excitation circuit
Bipolar transistor structure and method including emitter-base interface impurity
Apparatus for infeeding cartridges
Rapid synthesis of ternary, binary and multinary chalcogenide nanoparticles
Optical substance manipulator