The following Column Options are available:
Column name used in SQL table creation: Type the column alias, which changes the name of the metric in temporary tables. Temporary tables are used in data marts and SQL generation. This renaming does not affect the actual name of the metric in the metadata but allows you to identify the metric easily, such as in a long SQL report.
Data Type: Determine the data type for the metric.
To access the Advanced Metric Options: Column Options dialog box:
Prerequisites
This procedure assumes that you have created a metric. For steps, see Creating a metric.
If the metric is not already open, click the metric to edit it. Either the Function Editor or Formula Editor opens, depending on the type of metric.
Click the Options button. This displays the Advanced Metric Options dialog box.
In the list of categories on the left, click Column Options.
Related topics
About metrics for background information about metrics in general
Creating a metric for steps to create a metric
_____________________________
Copyright © 2019, Oracle and/or its affiliates. All rights reserved.
Legal Notices