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
Apparatus and method for weighing an item of mail during transport through a sorting installation and having an anti-vibration device
System for setting programmable parameters for an implantable hypertension treatment device
Use of physical deformation during scanning of an object to generate views of the object
Permanent magnet axial field zeeman slower
Fuel cell system with mechanical check valve
Deadline-driven parallel execution of queries
Accessing device via communication protocol selection
  Randomly Featured Patents
Molded rubber irradiated with ionizing radiation and process for producing the same
Method for monitoring blood flow and metabolic uptake in tissue with radiolabeled alkanoic acid
Method and apparatus for wrapping multiple tapes upon an elongated structure
Bacillus-containing pesticide granules
Saw and water combination system
Roadway barrier system
Electrophotographic photosensitive member, process cartridge including same and electrophotographic apparatus
Aminopropanol compounds and compositions for the treatment of cardiac and circulatory diseases
Actuating mechanism for electrical switches
CRC data protection scheme for non-block-oriented data