MicroStrategy ONE

Steps to map a new metric to a column expression

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

When creating Query Builder reports, you cannot map columns to any project metrics. The only existing metrics you can use are managed object metrics that were defined for previous Freeform SQL reports or Query Builder reports in the current project. These metrics are saved in the Freeform Objects folder. Unlike attributes, which can be mapped to project attributes, all metrics are created or mapped to managed object metrics.

To map a new metric to a column expression

  1. Access the Query Builder Editor.

  2. Add tables to your Query Builder report. The tables are added to the Tables and Joins pane (the top pane on the right).

  3. Select a column that represents fact data such as sales or cost data. The column is displayed in the Selections pane.

  4. Right-click the column, and select Map to New Metric.

  5. In the Object drop-down list, select the object name or type in an object name.

  6. In the Form drop-down list, select the form type.

Related Topics