# US 6,732,115 B2 · Chameleon measure and metric calculation

> Agents: this data is available as JSON from the patentgrep API and MCP server — see https://patentgrep.com/llms.txt

- Number: US 6,732,115 B2
- Document ID: US6732115B2
- Status: Granted
- Kind: B2
- Application number: 09/844,488
- Filed: 2001-04-27
- Published: 2002-03-21
- Granted: 2004-05-04
- Earliest claimed: 2000-04-27
- Assignees: Hyperion Solutions Corporation
- Inventors: Arun Shah; Robert F. Novy; Robert A. Ertl
- Web page: https://patentgrep.com/patent/US6732115B2

## CPC

- G06F 21/6227: {where protection concerns the structure of data, e.g. records, types, queries}
- G06F 16/24557: {Efficient disk access during query execution}
- G06F 16/283: {Multi-dimensional databases or data warehouses, e.g. MOLAP or ROLAP}
- G06F 21/6218: {to a system of files or objects, e.g. local or distributed file system or database}
- Y10S 707/99943: Generating database or data structure, e.g. via user interface
- G06F: ELECTRIC DIGITAL DATA PROCESSING (computer systems based on specific computational models G06N)
- Y10S: TECHNICAL SUBJECTS COVERED BY FORMER USPC CROSS-REFERENCE ART COLLECTIONS [XRACs] AND DIGESTS

## 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

### Claim 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.

### Claim 2 (depends on 1)

The system of claim 1, wherein the plurality of querying language constructs comprises structured query language constructs.

### Claim 3 (depends on 1)

The system of claim 1, wherein each of the second plurality of memory means stores a corresponding plurality of querying language constructs.

### Claim 4 (depends on 3)

The system of claim 3, wherein each of the plurality of querying language constructs is associated with a particular one of a plurality of stars.

### Claim 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.

### Claim 6 (depends on 5)

The method of claim 5, wherein the querying language construct further comprises a Structured Query Language construct.

### Claim 7

The method of clam 5, further comprising:
selecting a star associated with an aggregate fact table.

### Claim 8 (depends on 7)

The method of claim 7, wherein retrieving the querying language construct further comprises:
retrieving the querying language construct from a plurality of querying language constructs, wherein the querying language construct is associated with a stargroup.

### Claim 9 (depends on 8)

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.

### Claim 10 (depends on 5)

The method of claim 5, further comprising:
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.

### Claim 11 (depends on 10)

The method of claim 10, wherein generating the query further comprises:
inserting the one or more constraints into the querying language construct.

### Claim 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.

### Claim 13 (depends on 12)

The computer readable medium of claim 12, wherein the querying language construct further comprises a Structured Query Language construct.

### Claim 14 (depends on 12)

The computer readable medium of claim 12, wherein the computer readable medium stores instructions for:
selecting a star associated with an aggregate fact table.

### Claim 15 (depends on 14)

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.

### Claim 16 (depends on 15)

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.

### Claim 17 (depends on 12)

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.

### Claim 18 (depends on 17)

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.
