Shortcut metrics are a quick way to add new metrics based on the existing metrics of a report.
Transformation shortcut metrics apply offset values, such as "four months ago," to the selected attribute. The offset value is called a transformation. Use transformation shortcut metrics to compare current values for a given metric against corresponding values for that metric across a time period.
For example, if you add a Last Year transformation to a revenue metric, the new shortcut metric calculates last year's revenue.
Note: Transformations are schema objects and therefore only a project designer with schema object privileges can create them. For more information on transformations, see the MicroStrategy Project Design Guide.
You must have MicroStrategy OLAP Services to create shortcut metrics. To evaluate OLAP Services, contact your MicroStrategy Account Executive or e-mail MicroStrategy directly at info@microstrategy.com.
Transformation shortcut metrics must be calculated in SQL and are therefore only available to users that have the privilege to manipulate objects within the Report Objects tab.
Shortcut metrics are available only if DHTML is enabled. See Enabling DHTML in Web.
Click the name of a report to execute it. The report must be in either Grid view or Grid and Graph view.
Right-click the column(s) or row(s) to use to create a transformation metric.
Select Insert Metric and point to Transformation. A menu opens with the following options. Select the transformation interval in which the selected column or row is to be displayed:
Normal: Displays unit figures for both the current values and corresponding values for the interval selected.
Variance: Calculates the difference between current values and corresponding values for the interval selected, for example, Revenue - (Last Year's (Revenue)).
Variance Percentage: Calculates the difference between current values and corresponding values for the interval selected, expressed as a percentage. For example, Revenue - (Last Year's (Revenue))/(Last Year's (Revenue)).
A new column of metric values is displayed on the report.
Related topics