METHOD AND SYSTEM TO PROCESS MULTI-DIMENSIONAL DATA

• US 20080172405A1
• Filed: 12/05/2007
• Published: 07/17/2008
• Est. Priority Date: 12/05/2006
• Status: Active Grant

• Current Assignee: SAP SE
• Original Assignee: SAP AG (SAP SE)
• Inventors: White, Philip, Feng, Tim
• Granted Patent: US 8,204,914 B2
• Time in Patent Office: Days
• US Class Current: 707/102
• CPC Class Codes: G06F 16/283 Multi-dimensional databases or data warehouses, e.g. MOLAP or ROLAP

Abstract

An example method to process multi-dimensional data is provided. Example operations include detecting a request to generate a multi-dimensional data structure and determining that the multi-dimensional data structure is to include a multi-dimensional key figure. A first dimension of the key figure may be based primarily on a first characteristic and a second dimension of the key figure may be based primarily on a second characteristic. The method may further include augmenting a set of members associated with the second characteristic with a NULL member and generating a value for each dimension of the key figure. A value of the key figure may be determined by a pair made up from a member of the first characteristic and a member of the second characteristic. The key figure, the first characteristic, and the second characteristic may be then arranged into the requested multi-dimensional data structure.

Claims

1. A method comprising:

detecting a request to generate a multi-dimensional data structure;

determining that the multi-dimensional data structure is to include a multi-dimensional key figure, a first dimension of the key figure being based primarily on a first characteristic and a second dimension of the key figure being based primarily on a second characteristic;

augmenting a set of members associated with the second characteristic with a NULL member;

generating a value for each dimension of the key figure, a value of the key figure being determined by a pair made up from a member of the first characteristic and a member of the second characteristic; and

arranging the key figure, the first characteristic, and the second characteristic into the requested multi-dimensional data structure.

2. The method of claim 1, including storing the multi-dimensional data structure within a storage device.

3. The method of claim 1, wherein the generating of the multi-dimensional data structure includes generating a cube data structure.

4. The method of claim 3, wherein the generating of the cube data structure includes generating an On-line Analytical Processing (OLAP) cube.

5. The method of claim 1, wherein:

the members of the second characteristic are associated with a first member of the first characteristic; and

the generating of a value for a dimension of the key figure based on the first member of the first characteristic and the NULL member of the second characteristic includes generating a value based primarily on the first member of the first characteristic.

6. The method of claim 5, wherein the generating of the value based primarily on the first member of the first characteristic includes generating a value based on a sum of values generated for the members of the second characteristic.

7. The method of claim 5, wherein the first member of the first characteristic is the only member of the first characteristic.

8. The method of claim 1, including:

receiving a query against the multi-dimensional data structure that references a first member of the first characteristic and a first member of the second characteristic; and

returning, responsive to the query, a key figure value based primarily on the first member of the second characteristic.

9. The method of claim 1, including:

receiving a query against the multi-dimensional data structure that references a first member of the first characteristic and the NULL member of the second characteristic; and

returning, responsive to the query, a key figure value based primarily on the first member of the first characteristic.

10. The method of claim 1, including:

receiving a query against the multi-dimensional data structure that references a first member of the first characteristic and one of a first member of the second characteristic and the NULL member of the second characteristic; and

returning, responsive to the query, a key figure value based primarily on the first member of the first characteristic and key figure value based primarily on the first member of the first characteristic.

11. The method of claim 10, wherein the returning of the key figure responsive to the query includes generating a single table including one or more values of the key figure and presenting the single table to a user.

12. A method comprising:

receiving a request for data against a multi-dimensional data structure, the multi-dimensional data structure including a multi-dimensional key figure, a first dimension of the key figure being based primarily on a first characteristic and a second dimension of the key figure being based primarily on a second characteristic;

determining that the request references a first member of the first characteristic and a NULL member of the second characteristic; and

returning, responsive to the request, a key figure value based primarily on the first member of the first characteristic.

13. The method of claim 12, wherein the returning of the key figure responsive to the query includes generating a single table including one or more values of the key figure and presenting the single table to a user.

14. The method of claim 12, wherein the multi-dimensional data structure is a cube data structure.

15. The method of claim 12, wherein the cube data structure is an On-line Analytical Processing (OLAP) cube.

16. The method of claim 12, wherein:

members of the second characteristic are associated with a first member of the first characteristic; and

a value for a dimension of the key figure based on the first member of the first characteristic and the NULL member of the second characteristic is a sum of values generated for the members of the second characteristic.

17. The method of claim 12, wherein the first member of the first characteristic is the only member of the first characteristic.

18. A system comprising:

a data processing module to generate an On-line Analytical Processing (OLAP) cube, the OLAP cube to include a multi-dimensional key figure, a first dimension of the key figure being based primarily on a first characteristic and a second dimension of the key figure being based primarily on a second characteristic; and

a data storage device to store the multi-dimensional data structure.

19. The system of claim 18, wherein the second characteristic includes a NULL member.

20. A method comprising:

detecting a request to generate a multi-dimensional data structure;

determining that the multi-dimensional data structure is to include a multi-dimensional key figure, a first dimension of the key figure being based primarily on a first characteristic and a second dimension of the key figure being based primarily on a second characteristic;

generating a value for each dimension of the key figure, a value of the key figure being determined by a pair made up from a member of the first characteristic and a member of the second characteristic;

generating a value for an additional dimension of the key figure, the value for the additional dimension of the key figure being determined by a pair made up from a member of the first characteristic and a NULL member in place of the second characteristic, the value for the additional dimension of the key figure being determined based primarily on the member of the first characteristic; and

arranging the key figure, the first characteristic, and the second characteristic into the requested multi-dimensional data structure.