Shortcut metrics are a quick way to add new metrics based on the existing metrics of a report.
Rank shortcut metrics apply a ranking number to the metric values for a given attribute. When you create a rank shortcut metric, you can determine break-by options for each attribute on the report. Use the rank function to show the relative position of a given value in relation to other values on a report.
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.
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 rank.
Select Insert Metric and point to Rank.
Select the break-by value from the list by selecting one of the Break by attribute name options. This determines the business attributes you are ranking.
Select either Ascending or Descending to determine the order in which values are ranked on the report. A new column of metric values is displayed on the report.
Related topics