Overview of Cross-Subject Area Joins

You can create analyses that combine data from more than one subject area, or cross-subject area analyses. Review guidelines for creating these joins in MyOracle Support (Doc ID 1567672.1). Cross-subject area analyses can be classified into three broad categories:

Using common dimensions.
Using common and local dimensions.
Combining more than one result set from different subject areas using set operators such as union, union all, intersection and difference.

Common Dimensions

A common dimension is a dimensional attribute that exists in all subject areas in the analysis. These dimensions are considered common dimensions between subject areas and can be used to build a cross-subject area report.

Common and Local Dimensions

A local dimension is available only in one of the combined subject areas in a cross-subject area query.