Shortcut metrics are a quick way to add new metrics to a report, based on the metrics already 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.
Shortcut metrics include the following:
Percent-to-total metrics, which display the percent in relation to a selected total of each item affected by the metric.
Transformation metrics, which apply offset values, such as "four months ago," to the selected attribute.
Rank metrics, which apply a ranking number to the metric values for a given attribute.
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.
To create a shortcut metric:
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 metric column(s) or row(s) for which to create a new metric, select Insert Metric, and then select one of the following. For steps to create each type of metric, click the links below.
Creating a percent-to-total shortcut metric
Creating a transformation shortcut metric
Creating rank shortcut metrics
_____________________________
Copyright © 2019, Oracle and/or its affiliates. All rights reserved.
Legal Notices