Systems and methods of mapping multidimensional data and executing queries

• US 9,075,837 B1
• Filed: 01/23/2015
• Issued: 07/07/2015
• Est. Priority Date: 03/27/2014
• Status: Active Grant

• Current Assignee: Visier Solutions Inc. (Visier, Inc.)
• Original Assignee: Visier Solutions Inc. (Visier, Inc.)
• Inventors: Zenger, Geoffrey Benjamin
• Primary Examiner(s): Corrielus, Jean M
• Application Number:
  US14/603,645
• Time in Patent Office: 165 Days
• Field of Search: 707/603, 707/737
• US Class Current: 1/1
• CPC Class Codes: G06F 16/2282 Tablespace storage structures; Management thereof
• CPC Class Codes: G06F 16/245 Query processing
• CPC Class Codes: G06F 16/283 Multi-dimensional databases or data warehouses, e.g. MOLAP or ROLAP

Abstract

A method includes receiving, at a server from a computing device, a query identifying a source multidimensional cube, a mapped measure associated with the source multidimensional cube, and one or more classification values. The mapped measure corresponds to a measure associated with a mapped multidimensional cube that is distinct from the source multidimensional cube. The method also includes generating a cell set, wherein each cell of the cell set corresponds to a respective combination of the one or more classification values. The method further includes executing the mapped measure with respect to each cell of the cell set to generate one or more query execution results and sending the one or more query execution results to the computing device.

Claims

1. A method comprising:

receiving, at a server from a computing device, a query identifying a source multidimensional cube, a mapped measure associated with the source multidimensional cube, and one or more classification values, wherein the mapped measure corresponds to a measure associated with a mapped multidimensional cube that is distinct from the source multidimensional cube;

generating a cell set, wherein each cell of the cell set corresponds to a respective combination of the one or more classification values;

executing the mapped measure with respect to each cell of the cell set to generate one or more query execution results; and

sending the one or more query execution results to the computing device.

2. The method of claim 1, wherein the one or more classification values include at least one filtering value.

3. The method of claim 2, wherein the at least one filtering value is determined based on an application context.

4. The method of claim 1, wherein the one or more classification values include at least one grouping value that is associated with an axis of a chart displayed by the computing device.

5. The method of claim 1, further comprising, when at least one classification value is associated with a dimension of the source multidimensional cube, filtering data of the source multidimensional cube based on the at least one classification value during generation of the cell set.

6. The method of claim 1, further comprising, when at least one classification value is associated with a dimension of the mapped multidimensional cube, filtering data of the mapped multidimensional cube based on the at least one classification value during execution of the mapped measure.

7. The method of claim 1, wherein the one or more classification values include at least one value associated with a second mapped multidimensional cube.

8. The method of claim 1, wherein the source multidimensional cube corresponds to a source fact table.

9. The method of claim 8, wherein the source fact table includes a first set of dimensions and a first set of measures.

10. The method of claim 9, wherein the mapped multidimensional cube is associated with a second set of dimensions and a second set of measures.

11. The method of claim 10, further comprising adding one or more mapped dimensions to the source fact table, the mapped dimensions corresponding to the second set of dimensions.

12. The method of claim 11, further comprising associating the mapped measure with the source multidimensional cube, the mapped measure corresponding to the second set of measures.

13. The method of claim 12, further comprising adding a calculated value to the source fact table, wherein the calculated value is associated with a formula that is evaluated during query execution based on execution of a particular measure of the second set of measures.

14. The method of claim 1, wherein the source multidimensional cube comprises an employees cube.

15. The method of claim 1, wherein the mapped multidimensional cube comprises a leave liabilities cube.

16. The method of claim 1, wherein the mapped multidimensional cube comprises a sales opportunities cube.

17. A computer-readable storage device storing instructions that, when executed by a processor, cause the processor to perform operations comprising:

receiving, from a computing device, a query identifying a source multidimensional cube, a mapped measure associated with the source multidimensional cube, and one or more classification values, wherein the mapped measure corresponds to a measure associated with a mapped multidimensional cube that is distinct from the source multidimensional cube;

generating a cell set, wherein each cell of the cell set corresponds to a respective combination of the one or more classification values;

executing the mapped measure with respect to each cell of the cell set to generate one or more query execution results; and

sending the one or more query execution results to the computing device.

18. The computer-readable storage device of claim 17, wherein the one or more classification values include at least one filtering value, at least one grouping value, a classification value associated with a dimension of the source multidimensional cube, a classification value associated with a dimension of the mapped multidimensional cube, a classification value associated with a dimension of a second mapped multidimensional cube, or any combination thereof.

19. An apparatus comprising:

a processor; and

a memory storing instructions that, when executed by the processor, cause the processor to perform operations comprising;

receiving, from a computing device, a query identifying a source multidimensional cube, a mapped measure associated with the source multidimensional cube, and one or more classification values, wherein the mapped measure corresponds to a measure associated with a mapped multidimensional cube that is distinct from the source multidimensional cube;

generating a cell set, wherein each cell of the cell set corresponds to a respective combination of the one or more classification values;

executing the mapped measure with respect to each cell of the cell set to generate one or more query execution results; and

sending the one or more query execution results to the computing device.

20. The apparatus of claim 19, wherein the one or more classification values include at least one filtering value, at least one grouping value, a classification value associated with a dimension of the source multidimensional cube, a classification value associated with a dimension of the mapped multidimensional cube, a classification value associated with a dimension of a second mapped multidimensional cube, or any combination thereof.