Welcome to Oracle Communities
Register and Participate in Oracle's online communities. Learn from thousands of experts, get answers to your questions and share knowledge with peers.
i have 2 fact tables and five dimention tables.
fact tables - f1,f2
dimention table - d1,d2,d3,d4,d5
d1,d3 and d5 are joining to both f1 and f2.
d2 is joining to only f1 and d4 is joining to only f2
anyone suggest me best way to model this in bmm and display at least one column from all dimentiomn and fact tables in the report.
Just model it in the standard way you are supposed to model something with conformed dimension.
Just pay attention to your content levels as it's the only way to get data from conformed and not conformed dimensions in the same time ( https://greatobi.wordpress.com/2013/09/10/the-single-most-important-thing-to-know-about-the-obi-rpd/ )