Level (Dimensionality)

Metric level, or dimensionality, controls how the metric is aggregated. If there is no level statement in the metric expression, the metric is calculated at the report level. For more information on level metrics, see the Metrics section of the MicroStrategy Developer Help (formerly the MicroStrategy Desktop Help).

The level statement in a metric expression consists of the attribute or attributes at which level the metric is aggregated, separated by commas and enclosed in braces { }. To aggregate the metric at the report level (the default setting), use a ~ in place of the attribute.

You can specify a given attribute with just its name if it is the only item in the project by that name. If there are two items in the project with the same name, but in different locations, Command Manager will return an ambiguity error message. To correct this error, specify the full path to the attribute and enclose it in brackets [ ], such as [\Schema Objects\Attributes\Time\Year].

You can set filtering and grouping options for each attribute. The syntax for these options is as follows:

Filtering

For standard filtering, follow the attribute name with a +.

{~+, Region+}

For absolute filtering, follow the attribute name with a *.

{~+, Region*}

To ignore filtering, follow the attribute name with a %.

{~+, Region%}

To leave the filtering undefined, do not put anything after the attribute name.

{~+, Region}

Grouping

For standard grouping, do not put anything before the attribute name.

{~+, Region+}

To ignore grouping, precede the attribute name with !.

{~+, !Region+}

For beginning fact table grouping, precede the attribute name with <|.

{~+, <|Region+}

For beginning lookup table grouping, precede the attribute name with <.

{~+, <Region+}

For ending fact table grouping, precede the attribute name with >|.

{~+, >|Region+}

For ending lookup table grouping, precede the attribute name with >.

{~+, >Region+}

You can also set certain advanced options for the metric as a whole:

• To allow other users to add data to the metric (to emulate MicroStrategy 6.x behavior), put ;- at the end of the level statement (inside the braces).

  Copy

  {~+, Region+;-}

• To exclude filter attributes not on the report or in the metric level from calculation in the metric, put ;/ at the end of the level statement (inside the braces).

  Copy

  {~+, Region+;/}

• To use both advanced options, put ;-;/ at the end of the level statement (inside the braces).

  Copy

  {~+, Region+;-;/}