MicroStrategy ONE

Metric Formula Join Type dialog box

For compound metrics, you can set the join type at the formula level. This controls how the expressions or metrics within the compound metric are joined. Setting the join type at the formula level is done in the Metric Formula Join Type dialog box.

You can also set the metric join types at the metric level and the report level.

Select from the following join types:

  • A default join is a join that is defined in each element.

  • An inner join includes only data that are common across all elements, that is, the intersection of the information.

  • An outer join includes data that apply to every element, or a union of all the information.

For additional information and examples, refer to the Advanced Reporting Help.

Accessing the Metric Formula Join Type dialog box

In the Metric Editor, point to Advanced Settings on the Tools menu, and then select Formula Join Type.

How to access the Metric Editor

Related Topics