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
Semiconductor overlapped PN structure and manufacturing method thereof
Method and apparatus for providing contention-based resource zones in a wireless network
Solid-state imaging device and imaging apparatus
Systems and/or methods for using air/wind power to charge/re-charge vehicle batteries
Multi-contoured yoga support
Host route convergence based on sequence values
Image heating apparatus
  Randomly Featured Patents
Gimbal-level piezoelectric microactuator
Recreational boat
Process for preparation of a 1-(tetrazolylbiphenylmethyl)-imidazole derivative
Recovery of organic acid salts from impure process streams by addition of bases
Cyclosporin compositions
Castor wheel with non continuous ribs for lubricant
Radio antenna for motorcycle
Electric can opener having removable opener tools
Dynamometric device for indicating the remaining barrel torque in a timepiece
Microprocessor with circuits, systems, and methods for interrupt handling during virtual task operation