Standard Form Measures - OLAP

Each measure is defined by two workspace objects: a variable and a formula.

Measure Variable

A measure variable initially contains only base-level data, which is typically acquired from a relational fact table. If you deploy an aggregation plan, then the variable also contains precalculated aggregate levels.

A measure variable has a DECIMAL data type unless you redefined it before loading data during the initial build. The standard name for a measure variable is measuredef_VARIABLE. Table describes its properties.

Measuredef_VARIABLE Properties

Measuredef_VARIABLE Properties

Measuredef Formula

A measuredef formula calculates the aggregate data using a set of aggregation rules stored in an aggmap. Its standard name is the name of the measure. Table describes its properties.

Measuredef Formula Properties

Measuredef Formula Properties

Standard Form Metadata for Measures

Standard form metadata for measures is stored in these objects:

  • ALL_MEASURES dimension
  • ALL_DESCRIPTIONS variable
  • AW_NAMES variable
  • CUBE_MEASURES valueset

ALL_MEASURES Dimension

The ALL_MEASURES dimension contains the names of all measures in this format:

workspace.cube.measure.MEASURE

For example: GLOBAL_AW.UNITS_CUBE.UNITS.MEASURE
ALL_MEASURES is a base dimension of the ALL_OBJECTS concat dimension.
ALL_OBJECTS dimensions ALL_DESCRIPTIONS and AW_NAMES, so these catalogs have an entry for each measure.

ALL_DESCRIPTIONS Variable for Measures

The ALL_DESCRIPTIONS variable contains short, long, and plural names for the measures. All objects have a short name acquired from the metadata, but may or may not have long and plural names.

AW_NAMES Variable for Measures

The AW_NAMES measure provides a name for each measure in this format:

schema.workspace!measure

For example: GLOBAL_AW.GLOBAL!UNITS

CUBE_MEASURES Valueset

The CUBE_MEASURES valueset identifies the measures for each cube.


All rights reserved © 2018 Wisdom IT Services India Pvt. Ltd DMCA.com Protection Status

OLAP Topics