The join type selected for a metric determines the way in which data from joined columns is to be displayed. Setting the join here, at the metric level, determines how the metric is joined to other metrics. This setting affects the results for all reports using the metric. However, you can override this metric join setting for a particular report.
A compound metric contains multiple expressions or metrics, and you can define how these elements are joined. This is called the formula join type.
The following metric join options are available:
Metric join: Determine how data is included in the metric.
Default inherited value: Uses the default setting to determine how to join data.
Inner Join: Includes only data that is common to all components of the join.
Outer Join: Includes data that applies to all components.
Metric formula join: Determine how the elements in a compound metric are joined. This option is available for compound metrics.
Default inherited value: A join that is defined in each element.
Inner Join: Includes only data that is common across all elements.
Outer Join: Includes data that applies to every metric in a report.
To access the Advanced Metric Options: Joins dialog box:
Prerequisites
This procedure assumes that you have created a metric. For steps, see Creating a metric.
If the metric is not already open, click the metric to edit it. Either the Function Editor or Formula Editor opens, depending on the type of metric.
Click the Options 
button. This displays the Advanced Metric Options dialog box.
In the list of categories on the left, click Joins.
Related topics
About metrics for background information about metrics in general
Creating a metric for steps to create a metric
_____________________________
Copyright © 2019, Oracle and/or its affiliates. All rights reserved.
Legal Notices