Non-additive measures and metric calculation

• US 20020038229A1
• Filed: 04/27/2001
• Published: 03/28/2002
• Est. Priority Date: 04/27/2000
• Status: Active Grant

• Current Assignee: Oracle International Corporation (Oracle Corporation)
• Original Assignee: Hyperion Solutions Corporation (Oracle Corporation)
• Inventors: Novy, Robert F., Shah, Arun, Ertl, Robert A.
• Granted Patent: US 7,072,897 B2
• Time in Patent Office: Days
• US Class Current: 705/7
• CPC Class Codes: G06F 16/283 Multi-dimensional databases or data warehouses, e.g. MOLAP or ROLAP
• CPC Class Codes: G06F 21/6218 to a system of files or objects, e.g. local or distributed file system or database
• CPC Class Codes: G06F 21/6227 where protection concerns the structure of data, e.g. records, types, queries
• CPC Class Codes: Y10S 707/99942 Manipulating data structure, e.g. compression, compaction, compilation

Abstract

Disclosed is a system, method, and apparatus for calculating metrics by using hierarchical level metadata to describe the various structures within the database. The hierarchical level metadata permit calculation of complex metrics by an analytical server which would otherwise be difficult or impossible. As a result of the way that the analytical server calculates the metrics, slicing and drilling are supported. Additionally, dimension and fact level security are also supported.

Claims

1. A method for calculating a metric, said method comprising:

calculating the metric for a first set of one or more levels, wherein the metric is associated with a plurality of measures;

calculating a portion of the plurality of measures for a second set of one or more levels, wherein a particular one of the second set of levels is a different level of a dimension than a particular one of the first set of levels, thereby resulting in recalculated measures; and

adding a second portion of the plurality of measures along the dimension, thereby resulting in added measures.

2. The method of claim 1, further comprising:

receiving a request to calculate the metric for the second set of one or more levels.

3. The method of claim 1, further comprising:

determining whether each of the plurality of measures are additive measures or non-additive measures.

4. The method of claim 3, wherein the first portion comprises the non-additive measures and wherein the second portion comprises the additive measures.

5. The method of claim 1, further comprising:

calculating the metric with the recalculated measures and the added measures.

6. A computer readable medium for calculating a metric, said computer readable medium comprising a plurality of executable instructions, said executable instructions for:

calculating the metric for a first set of one or more levels, wherein the metric is associated with a plurality of measures;

calculating a portion of the plurality of measures for a second set of one or more levels, wherein a particular one of the second set of levels is a different level of a dimension than a particular one of the first set of levels, thereby resulting in recalculated measures; and

adding a second portion of the plurality of measures along the dimension, thereby resulting in added measures.

7. The computer readable medium of claim 6, further comprising instructions for:

receiving a request to calculate the metric for the second set of one or more levels.

8. The computer readable medium of claim 6, further comprising instructions for:

determining whether each of the plurality of measures are additive measures or non-additive measures.

9. The computer readable medium of claim 8, wherein the first portion comprises the non-additive measures and wherein the second portion comprises the additive measures.

10. The computer readable medium of claim 6, further comprising instructions for:

calculating the metric with the recalculated measures and the added measures.