Non-additive measures and metric calculation
View Patent ↗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.
1. A computer-implemented 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.