Function Elements and Syntax
Both MDX and PQL use a collection of other syntactical elements when using functions. Both languages use a very syntactical structure and many of these functional elements are identical or similar. The following provides an overview of these elements.
- Arguments: These are the necessary 'inputs' needed for each function. Apply to both PQL and MDX.
- Returns: These are the 'outputs' returned from each function. Apply to both PQL and MDX.
- Operators: Operators are used both within and across multiple functions in the process of building formulas - and they apply to all parts of the calculation engine - both PQL and MDX.
- Data Objects: applies to the Granular, Semantic, and Context engines only. These items are common to both PQL and MDX.