Measure Properties

This dialog box displays the properties of a measure in a multidimensional model.

Measures store the facts collected about your business, such as Costs or Units Sold. Each measure belongs to a particular cube, and thus shares particular characteristics with other measures in the cube, such as the same dimensions. The default characteristics of a measure are inherited from the cube.

For more information about working with multidimensional data, see Oracle OLAP User's Guide and the online help for Analytic Workspace Manager.

General

Name: Name of the measure. Example: Sales

Is Formula: Controls whether the measure is defined by the formula specified in the Formula field. If you do not specify a formula, the function specified in the Aggregation Function field in used.

Custom Formula: Identifies whether the formula is a custom formula.

Formula: Formula if this is a formula-based measure.

Formula Type: Type of formula: none, Base, OLAP, or Microsoft-computed.

Based On Fact: Name of the fact associated with the measure.

Addivity: Fully-Additive (additive across all dimensions), Semi-Additive (additive across some dimensions), or Non-Additive.

Aggregation Function: Function to be used for aggregation.

Where Clause: WHERE claus limiting the aggregation.

Aggregation Functions

Functions: Lists the aggregation functions and measure aliases. To add an aggregation function, click the Add (+) icon; to remove an aggregation function from the measure property definition, select it and click the Remove (X) icon. To set summary levels for a measure alias, select its item and click the Set Oracle AW Presummarized Levels icon.

Oracle OLAP Measure

For a measure based on an Oracle OLAP formula, specifies the OLAP operator and other information.

Oracle Names

Short Name: Short descriptive name that can be used by applications instead of the long name. Example: Sales

Long Name: Long descriptive name, typically used for display. Example: Unit Sales

Plural Name: Plural name (for reporting purposes). For example: Mymeasures if the Short Name is Mymeasure

Description

Description of the measure. Example: Unit sales measure

Comments, Notes, Responsible Parties, Documents, Summary

See Common Information in Dialog Boxes.