Values and Measures

Measure names and expressions are passed to functions in PQL to return measure members in a data model.

Syntax & Usage

[Measures].[measure name]
  • The "measures" hierarchy name is fixed and should always precede the name of the measure which should be enclosed in square brackets.
  • The dimension or table name is used in Semantic Calculations.
    • Granular calculations do use "measures". Instead they would address the table columns that are used to create measures.
  • By definition every measures name is unique.
Different Function types
  • This function is like MDX measure objects.

Examples

This examples is a data point expression that is comprised of 2 coordinates from a model: Australia, from the country column in the customer dimension, and the sales MEASURE:

([Customer].[Country].[Australia], [measures].[sales])