Simple metrics

Simple metrics are made of facts and values, combined by operators. These operators can be the standard arithmetic operators + - * / or they can be MicroStrategy functions. For more information on the available functions, see the MicroStrategy Functions Reference Guide.

You can specify a given fact 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 fact and enclose it in brackets [ ], such as [\Schema Objects\Facts\Revenue].

Simple metrics must have a level (dimensionality) expression; they may also have conditionality and transformation expressions. For more information as to the purpose of these expressions, see the Metrics section of the MicroStrategy Developer Help (formerly the MicroStrategy Desktop Help).

Examples

Sum(Revenue) {~+}

Avg(Revenue {Day}) 
 {Quarter}

Sum(Revenue) {~} <[Non-Web Sales]>

Revenue {~} |Last Month's|