CODEWITHSUNDEEP
obiee
aprkturk
aprkturk

Reputation: 85

OBIEE Multiple Fact Table In Single Business Model?

I'm sorry for images but I think this is the best way for expaining the problem.

Relationships in Physical Layer as below;

enter image description here

Relationships in Logical Layer as below; enter image description here

When I try to get data between 2 fact table I get the result as below; enter image description here

Lastly, here is sql code of my report; enter image description here

So, I'm sure that there is no problem between relationships..How can I fix this issue?

Thanks in advance..

Upvotes: 0

Views: 1159

Answers (1)

Chris
Chris

Reputation: 2752

You need to set the content levels in the fact LTS to "Grand Total" for the non-conformed dimensions and tie the measures to the grand total level of the non-conformed dimensions as well.

https://greatobi.wordpress.com/2011/06/24/making-dims-facts-work-together/

Upvotes: 1

Related Questions