This content has been marked as final. Show 4 replies
do you have hierarchies in place - If so set content level for that.
As work around,
Try applying agg like (sum, or AVG) for f1.c1 and f2.c2 in RPD or in answers & check it. If your requirement is that simple it works well Else follow the above link.
By using complex join in both physical and business model layer
Better to create a single fact in your BMM layer with two facts (f1 and f2). after that join the fact to the dimension (complex join)
Thanks for your responses , I have tried creating hierarchy dimension and assgned levels to the fact sources but i still see the error
Combining 2 facts will resolve the issue but its not the case here as each fact table has about 25 dimensions connected to it , but there are only 2 confirmed dimensions between both facts and the problem here is user wants to see both the fact tables in the same subject area
I have been trying but unable to get the solution.
Can you guys please suggested any other way of achiving this task
Thanks a lot