1. Visualizing Data in Oracle Analytics Server
  2. Report Data
  3. Create Analyses
  4. Combine Subject Areas in Analyses
  5. About Cross-Subject Area Joins

About Cross-Subject Area Joins

You can create analyses that combine data from more than one subject area.

Review guidelines for creating these joins in My Oracle Support (Doc ID 1567672.1).

Note:

Use joins sparingly with cross subject areas as they can affect report performance.

Cross-subject area analyses can be classified into three broad categories:

  • Using 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.
  • Using common and local dimensions - A local dimension is available only in one of the combined subject areas in a cross-subject area query.
  • Combining more than one result set from different subject areas - You do this using set operators such as union, union all, intersection and difference.