Search code examples
oracleweblogic12cobiee

Can't query multiple subject areas in OBIEE


everyone. I am using OBIEE 12c and I faced a problem when trying to use two different subject areas in generating an analysis.

I started with creating the analysis based on one subject area. Then in Criteria tab, there is '>>' icon which contains 'Add/remove subject ares' link. Howerver, in my case it is not selectable. What can I do?

If there should be done any joins in repository level, how to do that? Thanks for help


Solution

  • Add/remove SA only works for SAs built on the same Business Model.

    Heterogeneous source queries from totally unrelated SAs can only be accessed via UNIONs within the same analysis.