In Oracle Business Intelligence Answers, there are two ways of creating cross-subject area queries:
Creating a single-result set by combining data from multiple subject areas. See Creating a Single-Result-Set Analysis.
Combining multiple result sets using Set Operators (such as Union, Union All, Intersection, and Difference). See Creating a Multiple-Result-Set Analysis.
In a multiple set operation, each subset query is an independent query based on the same or different subject areas.
Note: | Unless the sub-query spans more than subject area, the limitation of using shared common dimensions will not apply to set-operation type of queries. See Restrictions in Using Cross-Subject Analysis. |