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
Isolated nucleic acid molecule encoding an antibody that reduces GDF-8 activity
Portion of a display panel with an ambiguous facial expression icon
Fluorine-free fused ring heteroaromatic photoacid generators and resist compositions containing the same
Method for accessing wireless network
Communication apparatus, communication method, and communication system
Gateway channel utilization
Camera system, video processing apparatus, and camera apparatus
  Randomly Featured Patents
Shock sensor
Adjustment apparatus for a lens barrel with built-in motor
Plasticized polypropylene thermoplastics
Multichip packages with exposed dice
Process for the production of alkyl sulfonic acids
Multi-wavelength optical CDMA with differential encoding and bipolar differential detection
Air mattress
CMOS process with an integrated, high performance, silicide agglomeration fuse
Apparatus for transporting stacks of paper sheets and the like