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
Methods and apparatus to determine impressions using distributed demographic information
Method and system for fail-safe call survival
Measurement and uses of oxidative status
Semiconductor device, method of manufacturing semiconductor device, and electronic apparatus
Image pickup device with a plurality of pixels and an AD conversion circuit
Data latch circuit and electronic device
Compound containing a carbon or an oxygen isotope, preparation and use thereof, and composition comprising thereof
  Randomly Featured Patents
Method and system for dose control during an ion implantation process
Amperometric measuring device having an electrochemical sensor
Unsaturated polyester resin and the use of it
Encapsulation sheet, flat panel display device using the same, and method of manufacturing the flat panel display device
Variable speed drive--apparatus and method of fabricating the apparatus
Drilling fluids
Customized memorial
Garment having an adjustable waist
Tubular heat exchanger
Electrostatic capacity detection apparatus and fingerprint crosscheck apparatus using the same