One of the best improvements in obiee 11g Answers is the ability to create a query across multiple subject areas.
In addition to the primary subject area that you select when you create a new analysis, filter, or dashboard prompt, you can include
additional subject areas that are related to the primary subject area with which to work.
additional subject areas that are related to the primary subject area with which to work.
Lets take Sample Applite rpd to work on this.
Step1 : Create new analysis –>click on 
to select another subject area and click OK.
to select another subject area and click OK.
Pull columns from both the subject areas
Step2 : Click on results.
