Version 2021

Report Data Options dialog box: Metric Join Type

The join type determines what type of join (inner or outer) is used by the SQL Generation Engine for each one of the metrics in a given report. This property only takes effect if the metric formula contains facts from different fact tables. If this is the case, then the engine must join the two tables, and this join can be an inner or an outer join. This setting overrides the metric-level join type.

You can view and modify the join type settings and restore metric defaults for the displayed report using this subcategory. To access it, from the Data menu of the Report Editor or the Template Editor, select Report Data Options, then Calculations, and then Metric Join Type.

The Metric Join Type subcategory contains the following:

  • Metric lists all the metrics on the report.

  • JoinType lists the join type associated with the metric. To change a join type, select the metric and choose on of the following from the drop-down list:

    • Default uses the metric join type set on the individual metric. The metric's join type is listed.

    • Inner includes only the elements common to both tables, regardless of the individual metric join type setting.

    • Outer includes all of the elements in both tables, regardless of the individual metric join type setting.

    • RestoreMetricDefaults returns the join type of all the metrics on the report to the default setting, which is the individual metrics' join types.

Related Topics