Areas

These rules apply to areas:

• 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