Method and system for performing data manipulations associated with business processes and operations
AssigneeProphix Software Inc.
InventorsPAUL GRANT BARBER, Robert John Walker
Life of this patent
Estimating the term…
Abstract
A method and apparatus for accessing, processing and manipulating data in an OLAP database. According to one aspect, the present invention comprises a user interface configured for accessing, processing and manipulating data in an OLAP cube. According to another aspect, the present invention comprises a calculation engine for manipulating and managing data in the OLAP cube.
Claims26
A system for processing data in an OLAP database, said system comprising:
- a user interface module;
- a calculation engine;
- said user interface comprising a screen configured for specifying a data process to be performed on data in the OLAP database in response to one or more user inputs;
- and
- said calculation engine being configured to interface to the OLAP database and execute said data process and generate a data process output.
A computer-implemented method for processing data stored in an OLAP cube, said method comprising the steps of:
- characterizing data in the OLAP cube according to a common dimension, and said common dimension comprising one or more common dimension members;
- characterizing data in the OLAP cube according to a non-common dimension, and said non-common dimension comprising one or more non-common dimension members;
- specifying a combination comprising selected common dimension members and selected non-common dimension members;
- selecting cells in the OLAP cube based on said specified combination, and reading data from said selected cells;
- applying a processing operation to the data read from said selected cells;
- and
- writing data from said processing operation back to the OLAP cube.
A computer program product for processing data in an OLAP database, said computer program product comprising:
- a storage medium configured to store computer readable instructions;
- said computer readable instructions including instructions for,
- characterizing data in the OLAP cube according to a common dimension, and said common dimension comprising one or more common dimension members;
- characterizing data in the OLAP cube according to a non-common dimension, and said non-common dimension comprising one or more non-common dimension members;
- specifying a combination comprising selected common dimension members and selected non-common dimension members;
- selecting cells in the OLAP cube based on said specified combination, and reading data from said selected cells;
- applying a processing operation to the data read from said selected cells;
- and
- writing data from said processing operation back to the OLAP cube.
Dependencies are inferred from the claim text.