Explain the function of a derived metric in Microstrategy?
A derived metric is obtained directly from metrics in a dataset used by the document, by combining two or more existing metrics for the purpose. Derived metrics permit the dynamic application of calculations to a document without requiring new metric definitions.
For example, if your dataset contains the dollar sales for a particular region, and you want to view the same data in millions, you could create a derived metric with a definition of Dollar Sales/1,000,000.
A derived metric:
• must be a compound metric. The reverse is not true—a compound metric does not have to be a derived metric.
• must use metrics from the same dataset. If the new definition demands metric data not readily available, the information cannot be obtained dynamically, as the dataset must first be re-executed.