Data Object Syntax

When composing PQL and MDX statements and expressions, different data objects need to be referenced.

The syntax for each object is provided in the following sections.

Calculation Engines

Some data objects are only applicable in some of the PQL calculation engines:

  • Only Dimensions/Tables and Hierarchies/Columns objects are relevant in the Granular engine
  • All data objects are relevant in the Semantic and Context engines
  • The objects are NOT relevant in the Common and Dynamic engines when used outside the context of the other 3 engines

Like PQL, these objects are only applicable to MDX Semantic functions. They will not operate directly in VBA methods.