Allocation measures and metric calculations in star schema multi-dimensional data warehouse
First Claim
Patent Images
1. A method for calculating a value for a measure, the method being implemented in a computer readable medium, said method comprising:
- receiving a request to calculate a value for a measure, said measure associated with one or more requested dimension levels;
determining at least one allocated dimension level for the measure, the allocated dimension level being one of the one or more requested dimension levels and the allocated dimension level being undefined at a lowest dimension level;
selecting a first star from a first stargroup associated with the measure, wherein the first star supports at least one allocation dimension level for the measure;
selecting a second star from a second stargroup associated with a control measure, wherein the second star supports the one or more requested dimension levels; and
calculating a value for the measure at the allocated dimension level using data associated with the at least one allocation dimension level supported by the first star and data associated wit the one or more requested dimension levels supported by the second star.
5 Assignments
0 Petitions
Accused Products
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.
-
Citations
10 Claims
-
1. A method for calculating a value for a measure, the method being implemented in a computer readable medium, said method comprising:
-
receiving a request to calculate a value for a measure, said measure associated with one or more requested dimension levels; determining at least one allocated dimension level for the measure, the allocated dimension level being one of the one or more requested dimension levels and the allocated dimension level being undefined at a lowest dimension level; selecting a first star from a first stargroup associated with the measure, wherein the first star supports at least one allocation dimension level for the measure; selecting a second star from a second stargroup associated with a control measure, wherein the second star supports the one or more requested dimension levels; and calculating a value for the measure at the allocated dimension level using data associated with the at least one allocation dimension level supported by the first star and data associated wit the one or more requested dimension levels supported by the second star. - View Dependent Claims (2, 3, 4, 5)
-
-
6. A computer readable medium for storing a plurality of executable instructions for calculating a value for a measure, said plurality of executable instructions comprising:
-
receiving a request to calculate a value for a measure, said measure associated with one or more requested dimension levels; determining at least one allocated dimension level for the measure, the allocated dimension level being one of the one or more requested dimension levels and the allocated dimension level being undefined at a lowest dimension level; selecting a first star from a first stargroup associated with the measure, wherein the first star supports at least one allocation dimension level for the measure; and selecting a second star from a second stargroup associated with a control measure, wherein the second star supports the one or more requested dimension levels; and calculating a value for the measure at the allocated dimension level using data associated with the at least one allocation dimension level supported by the first star and data associated with the one or more requested dimension levels supported by the second star. - View Dependent Claims (7, 8, 9, 10)
-
Specification