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
Fuser member
Flexible pouch
Interactivity model for shared feedback on mobile devices
Vehicle grille
Nucleic acid sequences encoding strictosidine synthase proteins
Inhibition of HRP-3 using modified oligonucleotides
Phosphor adhesive sheet, light emitting diode element including phosphor layer, light emitting diode device, and producing methods thereof
  Randomly Featured Patents
Methods and apparatus for enhanced retention of prosthetic implants
Alicyclic diamines, alicyclic diisocyanates and polyisocyanato-isocyanurates and method for the preparation thereof
Medical electrical lead having sigmoidal conductors and non-circular lumens
High-voltage insulation system
Weather protected modular motor enclosure
System for initiating communication between a user interface and a vision processor
Data communication over a power line
Wireless sensor network key distribution
Cathodic protection system
Method to improve properties of aluminum alloys processed by solid state joining