MicroStrategy ONE

Steps to map an existing object to a column expression

You can avoid creating multiple copies of the same object by using existing objects to map columns in Query Builder reports. In addition, mapping with a project object joins data when the object is used in a Report Services document that contains multiple datasets. Using project objects also allows you to use existing security filters with your Query Builder reports.

An existing object could be one of the following:

  • An attribute defined in an existing MicroStrategy project

  • A managed object attribute that has been created for previous Freeform SQL reports or Query Builder reports in the current project

  • A managed object metric that has been created for previous Freeform SQL reports or Query Builder reports

For more information on how different objects are mapped to columns, refer to Mapping columns.

To map an existing object 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. The column is displayed in the Selections pane (the bottom pane on the right).

  4. From the Object Browser, browse to an existing object such as an attribute, attribute form, or metric.

    Managed objects are stored in the Freeform Objects folder, which is accessible from the Object Browser in the Query Builder Editor.

  5. Drag and drop it into the desired row in the Selections pane.

The only metrics that can be inserted in this way are managed object metrics that are found in the Freeform Objects folder.

Related Topics