About derived metrics

You can create a new metric while you are viewing a report. For example, you can subtract the values of one metric from the values of another metric, such as Revenue Forecast - Revenue. You can calculate a monthly average, for example, Yearly Profit / 12. If the report shows the dollar sales for a particular region, you can create a derived metric to view the same data in millions, defined as Dollar Sales/1,000,000.

Derived metrics are metrics that a report analyst can create based on existing metrics on the report. A derived metric performs a calculation on the fly with the data available on a report, without re-executing the report against the data source. Derived metrics are not metric objects that can be re-used in other MicroStrategy reports and documents. They are metrics that are saved and displayed only on the specific report on which they are created.

You can only use metrics already existing in a report to create a derived metric. If the derived metric requires data not available on the report or in the Report Objects panel, the report must be re-executed against your data source before the new data is displayed.

Derived metrics can also be created in Report Services documents. See Creating derived metrics in documents.

Prerequisites

•  

• You must have MicroStrategy OLAP Services to create derived metrics. To evaluate OLAP Services, contact your MicroStrategy Account Executive or email MicroStrategy directly at info@microstrategy.com.  

• You must have the necessary privileges to add or remove metrics and calculations.

• You must have DHTML enabled. See Enabling DHTML in Web.

To create a derived metric on a report

•  

1. Click the name of a report to execute it. The report must be in either Grid view or Grid and Graph view.

2. From the Data menu, select Insert New Metric. The Insert New Metric dialog box opens.

• If DHTML is disabled, click the Go check mark.

3. Select New metric in the Object drop-down list.

4. In the Name field, type the name of the new metric.

5. In the Definition field, type the formula to designate how the metric should be calculated. For example, type [Revenue]/[Profit].

• When using another metric with spaces or special characters in its name, place the name within brackets [ ]. For example, [$ Sales].

• You may use arithmetic operators and parentheses in the formula. For example, the formula for a derived metric called Profit may be [$ Sales] - Cost

• If DHTML is enabled, you can select a metric from the Available list and add it to the Definition area.

6. To create a more advanced derived metric, for example, Running Sum of Revenue or Average of Daily Website Hit Counts, you can define the metric based on a function. To access a list of functions you can use, click the Function Wizard icon before adding anything to the Definition pane. For steps to use functions to insert new metrics, refer to Creating a derived metric using a function.

7. Click OK to create the new metric.

Related topic

•  

• Creating a derived metric using a function