Can we create one subject area from Multiple DataSources in OBIEE 12C

Vamsi Rampalli

Hi All ,

Is it possible to create one subject area from multiple data sources in OBIEE RPD and create report from that SA ?

Is it possible to create one Business model (BMM Layer ) from multiple data sources (example : oracle ,sql server) in OBIEE RPD ?

Thanks ,

Bharath

Joel Acha

yes

Vamsi Rampalli

Thanks for prompt reply.

Do you mean we can give join between the tables of multiple data sources (if common column is there in both data sources ) in physical layer ?

Robert Angel

Yes, you can also have multiple physical data sources for the source of a single logical table.

Joel Acha

those joins (across physical data sources) are done in the logical layer. The physical layer only defines joins within each data source

Gianni Ceresa

The rule is simple:

- 1 or many subject areas use 1 business model (a subject area can't be using 2 or more business models)

- a business model using 1 or many sources, same physical source, various physical sources, mixed source (so vertical federation, horizontal federation etc.)

Vamsi Rampalli

Thanks again for quick reply.

One last question , If I am not wrong in logical we can't define join based on column ..we only give  logical join with outer or inner join.

What if I want to join two tables ( one from oracle DB and another from SQL server DB)  based on one column .In this case ,we need to physical join right  in physical layer right ?

[Deleted User]

@sureshreddy

No. Absolutely not. You are missing the core concept of OBI - which it was written for:

Data federation across different data source types using the business models and dimensional conformity! It is impossible to join a DB table and Essbase for example.

The OBI server does this through data set stitch joins along dimensional conformities. Look at this: https://www.slideshare.net/ChristianBerg8/back2-basics-a-day-in-the-life-of-an-oracle-analytics-query

Oracle has an own labs just to demo this: https://apexapps.oracle.com/pls/apex/f?p=44785:24:818267103287::NO:RP,24:P24_CONTENT_ID,P24_PREV_PAGE:5977,2

Also: Get the SampleApp VM - there are dozens of examples.