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
Catalytic pyrolysis using UZM-44 aluminosilicate zeolite
System and method of detecting and locating intermittent and other faults
Systems and methods for switching supply load current estimation
Adaptive input interface
Automated tuning in a virtual machine computing environment
Power conversion device and method for controlling thereof
Drive and startup for a switched capacitor divider
  Randomly Featured Patents
Filter for use in an acoustic imaging device
Double-triggered electrostatic discharge protection circuit
System having controlled polarity adding odd and/or even numbers of equalization transitions depending upon pulse polarity
Nitrogenous heterocyclic compound and pharmaceutical use thereof
Analog echo suppressor
Strip casting device
Gumball dispenser and display
Adjustable left atrial appendage implant deployment system
Support for tape pancakes
Flow scheduling for network application apparatus