MicroStrategy ONE
Metric qualification
A metric qualification consists of a metric, a qualification operator, and a value. For more information on using metric qualifications in custom groups, see the Custom Groups section of the MicroStrategy Developer Help (formerly the MicroStrategy Desktop Help).
You can specify the metric 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 metric and enclose it in brackets [ ], such as [Public Objects\Metrics\Sales Metrics\Revenue].
Qualification operators include:
-
Standard comparison operators such as < or =. These operators require a single value.
-
BETWEEN and [NOT BETWEEN]. These operators require two values separated by AND. The [NOT BETWEEN] qualification operator must be enclosed in square brackets [ ].
Values in a metric qualification can be either integers or real numbers. If you are using real numbers, you must use the decimal separator specified in your Regional Settings.
Metric qualifications can use either the actual values of the metric, the relative rank within those values, or the percentage rank within those values.
-
To qualify by value, no additional syntax is required.
-
To qualify by rank, put the name of the metric in brackets and precede it with the word Rank.
CopyRank[Public Objects\Metrics\Sales
Metrics\Revenue] > 20
-
To qualify by percentage, put the name of the metric in brackets and precede it with Rank<ByValue=False>. Note that the percentage values must be converted to a decimal number between zero and one. For instance, twenty percent would be 0.2.
CopyRank<ByValue=False>[Public
Objects\Metrics\Sales Metrics\Revenue] > 0.2
The results of a ranked metric qualification are sorted in ascending order. To sort by descending order, include <ASC=False> between Rank and the name of the metric.
Examples
Profit > 3000
Rank[Profit] >= 200
Rank<ByValue=False>[Public Objects\Metrics\Sales
Metrics\Revenue] [NOT BETWEEN] 0.2 AND 0.5
Rank<ASC=False>[Revenue] < 100
Rank<ByValue=False><ASC=False>[Public
Objects\Metrics\Sales Metrics\Revenue] > 0.9