In a Strategy Developer metric definition, the dimensionality information always appears within braces ( { } ), and uses a distinct syntax. To show the full syntax, in the metric editor, go to View > Show Level (Dimensionality) Properties.
The dimensionality consists of a list of expressions, separated by commas. Each expression represents one entry in the dimensionality.
Each entry consists of three parts:
1. The level part is the name of an attribute or hierarchy to which the metric should be aggregated. If the name of the attribute or hierarchy contains more than one word, it will appear within brackets ( ). Also, the level can be 'report level', represented by the tilde (~) symbol.
2. The grouping part comes before the level part and uses the following symbols:
3. The filtering part comes after the level part and uses the following symbols:
For example, the following dimensionality grids would be represented as shown in the Metric Editor:
Example 1:
Sum(Revenue) {~+, Subcategory+}
Sum(Revenue) {Item+, Day%, Customer%}
Sum(Revenue) {~+, >|Day+, ![Distribution Center]%}