MicroStrategy ONE
Metric Level Symbols: Defining Expression Syntax
Located in the Metric Editor, the metric definition indicates the target of the metric level. All information about the metric level is placed between curly braces ({ }).
You can define the grouping and filtering settings by displaying additional level settings. To show the additional settings, select Show level (dimensionality) properties on the View menu. This option is available when the metric definition is selected.
The following table describes the metric level symbols.
Symbol |
Definition |
~ |
Report level |
An attribute name |
Target |
Symbols placed before the target |
|
No symbol |
Grouping = Standard |
! |
Grouping = None |
<| |
Grouping = Beginning fact |
>| |
Grouping = Ending fact |
< |
Grouping = Beginning lookup |
> |
Grouping = Ending lookup |
Symbols placed after the target |
|
+ |
Filtering = Standard |
* |
Filtering = Absolute |
% |
Filtering = Ignore |
No symbol |
Filtering = None |