This content has been marked as final. Show 2 replies
What is the Granularity of oth the fact table....If both the fact table have same granuarity..then why are u designing in such a bad way...and if fact1 and fact 2 are of different grain the populate some wid of dim 1 in fact2
To fix your issue.. without looking at your data.. follow as below1 person found this helpful
In BMM layer to the existing fact1->source properties-> General Tab
Click on Add button and add the fact2 and pull required columns to existing logical fact table.
Appreciate if you mark as correct/helpful