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
Image capture apparatus and program
Triazine ring-containing polymer and film-forming composition comprising same
Power control arrangement for long term evolution time division duplex method and apparatus
Compound semiconductor device and manufacturing method therefor
Method of controlling an indentation depth of an electrode into a metal substrate during welding
Estimating stack distances
Elastic polypropylene-based film compositions
  Randomly Featured Patents
Diagnosis of Williams syndrome and Williams syndrome cognitive profile by analysis of the presence or absence of a LIM-kinase gene
Process for molding a frame onto a seat outfit for the purpose of producing a seal element
Fluid restrictor apparatus and method for making the same
Folding seat
Anthurium plant named `Pink Champion`
Optic device for the introduction of a superimposed image into the visual field of an observer
Devices and systems relating to a memory cell having a floating body
Crystalline modification of 5-fluoro-1-(tetrahydro-2-furyl) uracil and complex compounds based thereon, producing antineoplastic effect
Preparation of fuel grade dimethyl ether
Method for constructing a weighbridge and weighing cell assembly, in particular for use in performing the method