Advanced Metrics

Metrics are MicroStrategy objects that represent business measures and key performance indicators. They are calculations performed on data stored in the database and are similar to formulas in spreadsheet software. A metric definition must contain a formula A mathematical function and business facts stored in your data source. , which determines the data used and the calculations performed on the data. Depending on the functions in the formula, a metric is categorized as either a simple metric Metric formula based on at least one group function applied to facts, attributes, or metrics. or a compound metric Metric formula based on arithmetic operators and non-group functions..

This section focuses on compound metrics and simple metrics that use level, condition, and transformation components. For a comprehensive review of metric basics, see the Building Query Objects and Queries, for Designers chapter of the Basic Reporting Help.