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
Autobrake and decel control built-in test equipment
Digital camera dock having movable guide pins
Method for producing semiconductor substrate, semiconductor substrate, method for manufacturing electronic device, and reaction apparatus
Digital microwave radio link with adaptive data rate
Activated carbon cryogels and related methods
Use of tris(hydroxymethyl) aminomethane for the stabilization of peptides, polypeptides and proteins
Computer-implemented method of constructing a stock index using index rotation
  Randomly Featured Patents
Exhaust gas recirculation apparatus
Magnetic refrigerant for magnetic refrigeration
Organic electroluminescent display device and chemical compounds for liquid crystals
Interchangeable lens camera, camera body thereof and lens unit
Color diffusion transfer element comprising two neutralizing layers and two timing layers
Method for producing deep vertical structures in silicon substrates
Liquid crystal polyester resin composition
Foldable picture-taking device with scanning function
Data transfer apparatus and data transfer system
Temple member for an eyeglass frame