Home > Data Modeler Dialog Boxes > 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