Arguments

• Areas must be enclosed in square brackets. For example:

  [MEASURE:'Price']

  [MEASURE:'Sales', REGION:'Norway']

• Dimension and element names can be enclosed in single or double straight quotes.
• Dimension names do not have to be included, but they increase the readability and maintainability of the rules.
• If an element of a non-default hierarchy is to be addressed, the hierarchy must be included between dimension and element. For example:

  [PRODUCT:'Tire Size':'175']

• Multiple elements of one dimension must be enclosed in curly brackets. For example:

  [PERIOD:{'2017_Q1_01', '2017_Q1_02', '2017_Q1_03'}]

• Subsets must be enclosed in double curly brackets. For example:

  [UNIT:{{N-ELEMENTS}}]

  To be able to use subsets in rules, the subsets must be public and static.

• The order in which you specify the elements within an area is irrelevant.
• If you want to include all elements of a dimension, do not specify any elements of that dimension. If no elements are specified in an area, all cells in the cube are addressed. For example:

  [ ] = #NA

• Numeric. For example:

  [PROFIT:'Gross Margin in percent'] = [PROFIT:'Gross Margin'] / [PROFIT:'Revenue'] * 100

  The decimal separator is always a point, no matter what the regional settings may indicate. Commas must not be used as thousands separators.

• Strings: They must be enclosed in single or double straight quotes.
• #NA: Simulates an empty cell. For example:

  [ ] = #NA

Arithmetic operators are evaluated with standard algebraic priority. That is, multiplication and division are evaluated first, then addition and subtraction. A different order of calculation can be forced with parentheses.