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
System and method for outputting virtual textures in electronic devices
Automatic search system and method
Light powered hearing aid
Method and apparatus for re-routing calls in a packet network during failures
Pharmaceutical compositions of paclitaxel, paclitaxel analogs or paclitaxel conjugates and related methods of preparation and use
Automatically capturing images that include lightning
Adhering composition and method of applying the same
  Randomly Featured Patents
Percussion tool utilizing negative pressure
Production of thin steel strip
Fuel cell stack with water removal projections at air outlets
Method of fabricating a composed pillar transistor DRAM Cell
Telephone index
Pair of book ends
Punch sheet separation apparatus
Multi-layer container and preform and process for obtaining same
Display method and device for reducing blurring effects
Environmental control of an aquarium