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
Vertical gate LDMOS device
System and method of error reporting in a video distribution network
System and method for data reconfiguration in an optical communication network
Candle holder
Pre-fetching map data using variable map tile radius
Tire for motorcycle
Precision geolocation of moving or fixed transmitters using multiple observers
  Randomly Featured Patents
Apparatus and method for refreshing subsets of memory devices in a memory system
Ignition component for a pyrotechnic composition or propellant charge
Compartmented laundry box
Program converter, encrypting device, and encrypting method
Soluble poly(aryl-oxadiazole) conjugated polymers
Battery system electrical connection apparatus and method
Relief lip for flocked tape belt seal
Method for improving the color of containerized green vegetables
Method and system for autodiscovery of a network path
Application execution control method and system for servicing subscribers via a switchboard connected to a computer using an application management table