MicroStrategy ONE
Introduction to Shortcut Metrics
Shortcut metrics are a quick way to add new metrics to a report, based on the metrics in the report. They are available when you right-click on a metric column header or the data in a column of metric data. They only apply to the report in which they are created; you cannot reuse them on another report. You can also create shortcut metrics in a grid report displayed on a document.
Rank and Percent-to-total shortcut metrics are derived metrics. Derived metrics do not require the report to be re-executed against your data warehouse. Transformation shortcut metrics must be calculated in SQL, therefore the report is re-executed to display the new metric.
The report must be displayed as either a grid or as both a grid and graph.
To Create a Shortcut Metric
-
Do one of the following:
- To create a shortcut metric on a report, click the report's name to execute it.
-
To create a shortcut metric on a report on a document, open the document in Design Mode or Editable Mode.
- To open a document in Design Mode, from a folder, right-click the document and select Edit.
- To open a document in Editable Mode, from a folder, right-click the document, point to Run as, and select Editable.
-
Right-click the column(s) or row(s) for which to create a new metric, point to Insert Metric, and then select one of the following. For steps to create each type of metric, click the links below.
How to Create a Percent-to-Total Shortcut Metric