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
Transparent zebrafish and preparation method thereof
Device and method incorporating an improved text input mechanism
Optical imaging device and imaging method for microscopy
Direct file transfer between subscribers of a communications systems
Performance metrics processing for anticipating unavailability
Safety device and method for electric heating appliances
Method and system for security authentication of radio frequency identification
  Randomly Featured Patents
System and method to modify text entry
Petroleum refinery processes using catalyst of aluminosilicate sols and powders
Representing file data using virtual hierarchy
Apparatus for introducing stacks of paper sheets or the like into cartons
Polyolefin waxes modified to make them polar in photocopier toners
7-(2-Aminoethyl)-1,3-benzthia- or oxa-zol-2(3H)-ones
Clandsetine location reporting for missing vehicles
Method of making trench DRAM
Fin-stabilized mortar grenade
Light fixture