Oracle Business Intelligence Applications

Home› Oracle Analytics› Oracle Analytics Forums› More Solutions› Oracle Business Intelligence Applications

Categories

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

Is it possible to join dimension tables which are joined to 2 fact tables in BMM layer?

Received Response
203
Views
1
Comments
Harsha J K
Harsha J K Rank 1 - Community Starter
in Oracle Business Intelligence Applications

Hi All,

Please find the below Physical and logical joins, the data in OBIEE was visible for fields of both dimension tables when it was joining only to Case fact in BMM. But after I joined the 2 Dimension tables to Service Request Fact aswell, after which data is not showing for Dim_WC_SPLN_SRV_OUT_D fields in OBIEE. How can we resolve this issue??


Physical Joins:

Logical Joins:


Answers

  • [Deleted User]
    [Deleted User] Rank 2 - Community Beginner

    We just have this topic ongoing in another thread here in the forum. You don't join dimensions together. That's not how dimensional modelling works. You navigate between non-conformed dimensions via the fact. Not by going dimension -> dimension.