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.
Hi,1 person found this helpful
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
Edited by: haranadh on Jan 17, 2013 3:58 AM