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
Topology arrangement for achieving reliable communication in wireless automotive networks
High power fiber amplifier with stable output
Systems and methods for processing supplemental information associated with media programming
Nucleic acid sequences encoding secE/sec61-gamma subunits of protein translocation complexes
Method of preparing enteric hard capsule and enteric hard capsule prepared thereby
Method and apparatus for radio antenna frequency tuning
Semiconductor device and method of manufacturing the same
  Randomly Featured Patents
Linear motion guide system with highly-tight sealing units
Method and system for providing standard resources in different natural languages
Ribbon type dating equipment
Modular instrumentation for bone preparation and implant trial reduction of orthopedic implants
Quantized queue length arbiter
Centrifugal fan
Recording apparatus
Carburetor control arrangement for internal combustion engine
Method for controlling power gain
Spark plug and manufacturing method therefor