MULTIDIMENSIONAL CUBE FUNCTIONS
1 Assignment
0 Petitions
Accused Products
Abstract
Cube functions may be used to obtain data from a multidimensional database. The cube functions may be contained within one or more cells of a spreadsheet. These cube functions behave similarly to the standard functions that may be included within a spreadsheet. Exemplary cube functions include obtaining: a cube member, a cube value, a cube set, a ranked member, a KPI, a member property and a count relating to a set. The cube functions within the spreadsheet may access the cube data from one or more multidimensional databases. Using the cube formulas in individual cells allows the user to add/delete rows and/or columns from within the spreadsheet.
-
Citations
46 Claims
-
1-26. -26. (canceled)
-
27. A computer-readable storage medium having computer-executable instructions for interacting with an OLAP cube, comprising:
-
parsing a cube function having parameters;
wherein the cube function is included within a cell of a spreadsheet and wherein the cube function is directed at obtaining data from an OLAP cube;
wherein the cube function is from cube functions comprising;
a cube member function that identifies an item in the OLAP cube and returns a name for the member;
a cube value function that identifies an aggregated value from the OLAP cube;
a cube set function that defines a set that is to be built for the spreadsheet by an OLAP server storing the OLAP cube; and
a member property function that identifies a value of a member property in the OLAP cube and a count relating to a set within the OLAP cube;determining an OLAP cube from which to obtain data from one of the parameters of the cube function; and fetching the data from the determined OLAP cube in response to the parameters of the cube function. - View Dependent Claims (28, 29, 30, 31, 32, 33, 34, 35)
-
-
36. A system for interacting with a multidimensional database from a spreadsheet, comprising:
-
a processor and a computer-readable storage medium; and a spreadsheet application that is coupled to a network and is configured to perform steps, comprising; parsing a cube function having parameters that is located within a cell of the spreadsheet to generate an MDX query;
wherein the MDX query locates data within a multidimensional database;
wherein the cube function is from cube functions comprising a cube member function that identifies an item in the multidimensional database and returns a name for the member;
a cube value function that identifies an aggregated value from the multidimensional database;
a cube set function that defines a set that is to be built for the spreadsheet by an OLAP server storing the multidimensional database; and
a member property function that identifies a value of a member property in the multidimensional database and a count relating to a set within the multidimensional database;determining the multidimensional database to query based on at least one of the parameters of the cube function; querying a server identified by the determined multidimensional database using the MDX query; receiving data from the server that is returned in response to the MDX query; and updating the cell and any other dependent cells in response to the received data. - View Dependent Claims (37, 38, 39)
-
-
40. A method for interacting with an OLAP cube, comprising:
-
parsing a cube function having parameters;
wherein the cube function is included within a cell of a spreadsheet and wherein the cube function is directed at obtaining data from an OLAP cube;
wherein the spreadsheet includes cells that do not include data from a multidimensional database;determining an OLAP cube from which to obtain the data by accessing one of the parameters of the cube function; and fetching the data from the determined OLAP cube in response to the parameters of the cube function. - View Dependent Claims (41, 42, 43, 44, 45, 46)
-
Specification