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])