Advanced Metric Options dialog box: Column Options

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.

  1. 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.

  2. Click the Options button. This displays the Advanced Metric Options dialog box.

  3. 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

Metric Function Editor

Metric Formula Editor

 

 

_____________________________