Dimensions and Tables
Dimension or table names and expressions are passed to functions in PQL to return members, sets, or tuples from a hierarchy.
Syntax & Usage
[dimension or table name]
- The dimension or table name should be enclosed in square brackets.
- The dimension or table name is used in Granular and Semantic Calculations.
- It usually precedes the Hierarchy or Column name, as a way to differentiate different columns in a data model.
- By definition, every dimension or table name is unique.
Different Function types
- This function is like MDX dimension 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 or TABLE, and the sales measure:
([Customer].[Country].[Australia], [measures].[sales])