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

Oracle Analytics Cloud and Server

Home› Oracle Analytics› Oracle Analytics Forums› Oracle Analytics Cloud and Server› Oracle Analytics Cloud and Server

Categories

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

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

Received Response
223
Views
7
Comments
Vamsi Rampalli
Vamsi Rampalli Rank 4 - Community Specialist
edited Aug 13, 2024 5:52PM in Oracle Analytics Cloud and Server

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

Answers

  • Joel
    Joel Rank 8 - Analytics Strategist

    yes

  • Vamsi Rampalli
    Vamsi Rampalli Rank 4 - Community Specialist

    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
    Robert Angel Rank 8 - Analytics Strategist

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

  • Joel
    Joel Rank 8 - Analytics Strategist

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

  • Gianni Ceresa
    Gianni Ceresa Mod

    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
    Vamsi Rampalli Rank 4 - Community Specialist

    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]
    [Deleted User] Rank 2 - Community Beginner

    @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.