MicroStrategy ONE

Creating aliases for metrics

Creating an alias for a metric allows you to use a different name for the metric in a data mart report or during SQL generation. For more information on data marting, seeCreating and editing column aliases in data mart reports.

A metric's default name is the name assigned by its creator. This default name can be changed by using an alias if the project-level VLDB property "Use the metric name as the default metric column alias" is selected.

  • Metric names are changed automatically if they begin with a number. In this case, the letter M is attached to the beginning of the name during SQL generation. This occurs because Teradata does not allow a leading number in a metric name. For example, a metric named 2023Revenue is renamed M2023Revenue.

  • You can also set an alias to display for a metric on a report. This does not affect the SQL; it is for display purposes only. For more information, see Setting aliases for report objects.

Prerequisite

This procedure assumes you have created a metric. For instructions, see Creating metrics.

To create an alias for a metric

  1. Open the metric to be aliased. (How?)

  2. From the Tools menu, point to Advanced Settings and then select Metric Column Options. The Metric Column Alias Options dialog box opens.

  3. Enter the metric alias in the Column Name used in table SQL creation field.

  4. By default, the SQL Engine chooses the metric's data type. You can use the Data type drop-down list to set it manually.

  5. Click OK. You are returned to the Metric Editor.