Chameleon measure and metric calculation
First Claim
Patent Images
1. A system for calculating measures, said system comprising:
- a first plurality of memory means, wherein each of the first plurality of memory means stores a corresponding one of a plurality of measures; and
a second plurality of memory means wherein each of the second plurality of memory means stores a corresponding one of a plurality of querying language constructs, wherein a first one of the querying language constructs causes a particular one of the plurality of measures to be calculated in accordance with a first definition and wherein a second one of the querying language constructs causes the particular one of the plurality of measures to be calculated in accordance with a second definition.
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
18 Claims
-
1. A system for calculating measures, said system comprising:
-
a first plurality of memory means, wherein each of the first plurality of memory means stores a corresponding one of a plurality of measures; and
a second plurality of memory means wherein each of the second plurality of memory means stores a corresponding one of a plurality of querying language constructs, wherein a first one of the querying language constructs causes a particular one of the plurality of measures to be calculated in accordance with a first definition and wherein a second one of the querying language constructs causes the particular one of the plurality of measures to be calculated in accordance with a second definition. - View Dependent Claims (2, 3, 4)
-
-
5. A method for calculating a measure, said method comprising:
-
accessing a first measure indicator associated with the a first measure;
retrieving a querying language construct from the first measure indicator; and
generating a query, using the querying language construct. - View Dependent Claims (6, 10, 11)
receiving a request to calculate a metric, wherein the metric is associated with the first measure, wherein the request is associated with one or more constraints associated with a corresponding one or more dimensions.
-
-
11. The method of claim 10, wherein generating the query further comprises:
inserting the one or more constraints into the querying language construct.
-
7. The method of clam 5, further comprising:
-
selecting a star associated with an aggregate fact table. - View Dependent Claims (8, 9)
retrieving the querying language construct from a plurality of querying language constructs, wherein the querying language construct is associated with a stargroup.
-
-
9. The method of claim 8, wherein generating the query further comprises:
-
generating the query in accordance with a first measure definition, wherein a first querying language construct is selected; and
generating the query in accordance with a second measure definition, wherein a second querying language construct is selected.
-
-
12. A computer readable medium for calculating measure, said computer readable medium storing a plurality of executable instructions for:
-
accessing a first measure indicator associated with a first measure;
retrieving a querying language construct from the first measure indicator; and
generating a query, using the querying language construct. - View Dependent Claims (13, 14, 15, 16, 17, 18)
selecting a star associated with an aggregate fact table.
-
-
15. The computer readable medium of claim 14, herein the instructions for retrieving the querying language construct further comprise instructions for:
retrieving a snippet from a plurality of snippets, wherein the querying language construct is associated with a stargroup.
-
16. The computer readable medium of claim 15, wherein the instructions for generating the query further comprise instructions for:
-
generating the query in accordance with a first measure definition, wherein a first querying language construct is selected; and
generating the query in accordance with a second measure definition, wherein a second querying language construct is selected.
-
-
17. The computer readable medium of claim 12, wherein the computer readable medium stores instructions for:
receiving a request to calculate a metric, wherein the metric is associated with the first measure, wherein the request is associated with one or more constraints associated with a corresponding one or more dimensions.
-
18. The computer readable medium of claim 17, wherein the instructions for generating the query further comprise instruction for:
inserting the one or more constraints into the querying language construct.
Specification