This content has been marked as final. Show 5 replies
I'm not sure about your data.. I give couple of options try them out any of one should work.
Assuming both facts are at same granular: You need to create Logical Fact table in BMM add first fact as source then, open properties wizard and add other fact table.
Assuming both facts are at Different or Same granular: You need to create Logical Fact table in BMM add first fact and then add 2nd fact as 2nd logical table source and set the content tab for both facts
Using any of the option you'll be going for metrics and use them in report.
In general: You need to let BI server let know how data is spread across tables so that BI Server can respond as you expected.
Hope this helps, Appreciate if you mark as correct/helpful
Edited by: Srini VEERAVALLI on Dec 29, 2012 12:58 PM
why do we have to do all this?. Can you please explain. This used to work in 10g right.
Appreciate the reply and I had tried both your explanations. they work for me.
Yeah forgot due to I was busy with some other stuff..
Can you send me a test email?
Edited by: Srini VEERAVALLI on Jan 20, 2013 12:14 PM
you never bothered to reply !