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