MicroStrategy ONE

Mapping a new metric to a column

You can map a column in the SQL statement to a new metric that can be recognized in the MicroStrategy environment.

Prerequisites

  •  

  • The procedure below assumes you have already created a Freeform SQL report and it is open in the Freeform SQL Editor.

  • You must have the Define Freeform SQL report and Create schema objects privileges to access and use the Freeform SQL Editor.

To map a new metric to a column

  1. From the Mapping menu, select Add New Metric. A new metric is inserted into the Mapping pane.

  2. Type in the metric name of your choice and make the selection for Form, Type, and Data Type.

  3. Ensure that the column number for the object matches the order of the column in the SQL statement. For example, an object is to be mapped to the second column listed in the SELECT clause. In the Mapping pane (the bottom pane on the right), the object must be included as column 2. You can use the Move Up and Move Down options in the toolbar to change the column position of an object.

Unlike attributes, which can be mapped to project attributes (see Adding an existing object to the Mapping pane), all metrics are created or mapped to managed object metrics. The only existing metrics you can use are managed object metrics that are defined for Freeform SQL reports in the current project (saved in the Freeform Objects folder). For a more detailed definition of managed objects and how they are used in MicroStrategy, see the Advanced Reporting Help.

Related Topics