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 of automatic piloting for in-flight refuelling of aircraft, and aircraft comprising said system
Soybean cultivar CL1013665
Method and system for implementing power detection
Display screen with graphical user interface
Method and system for triggering message waiting indicator delivery
Micro positioning test socket and methods for active precision alignment and co-planarity feedback
Vehicle and method for controlling vehicle
  Randomly Featured Patents
Managing precedence call preemption in a communication environment
Functional oil-cream bath
Screen beading applicator
Double-grooved gasket for galvanic cells
Dual gridded reflector antenna
Hydraulic controllable two-port valve for a liquid stream
Semiconductor encapsulating epoxy resin composition and semiconductor device
Facing panel for earth structures
Reusable vacuum bag and methods of its use
Diagnostic uses of IGFBP-2