Editing derived metrics

To change the definition of the derived metric after the metric is applied to a report, right-click the derived metric and select Edit. The Input Metric Formula dialog box is displayed. From this dialog box, you can modify the metric's definition as needed. Click OK after you finish, and the modified metric definition is calculated and displayed on the report instantly without having to re-execute the report against the data warehouse.

You need the Create Derived Metrics (MicroStrategy Developer) and/or the Web Create Derived Metrics and Derived Attributes (MicroStrategy Web) privileges to edit derived metrics. These privileges are part of OLAP Services.

For instructions to create a derived metric using the Input Metric Formula dialog box, see Creating derived metrics.

Related Topics

• Best practices for creating derived metrics

• Creating derived metrics

• Example: Average profit per customer with transactions

• Using rank and percent-to-total metric analysis

• Formatting derived metrics

• Deleting derived metrics

• View filter effects on derived metrics

• Derived element effects on derived metrics