Chameleon measure and metric calculation
AssigneeHyperion Solutions Corporation
InventorsArun Shah, Robert F. Novy, Robert A. Ertl
Life of this patent
Estimating the term…
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.
Claims18
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.
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.
The method of clam 5, further comprising:
- selecting a star associated with an aggregate fact table.
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.
Dependencies are inferred from the claim text.