This content has been marked as final. Show 6 replies
Since both fact tables are at same granular level I would suggest to map each other (Signon_A maping Signon_B) in BMM layer logical fact @source.
Considering them as Fact and with fact extension.
BTW: Did you try by setting implicit fact at subject area properties?
Edited by: Srini VEERAVALLI on Feb 1, 2013 9:04 AM
Do you mean to bring one of the common fields between the two fact tables into the other table as a second source?
in BMM local fact for Signon_A
expand source folder you might see 'Signon_A' ->properties >General tab ->Click on + icon
Pull required columns from Signon_B from physical layer to logical fact table
Edited by: Srini VEERAVALLI on Feb 1, 2013 2:21 PM
I managed to pare back my dimensions so that they're common to both tables and was able to solve the problem.
Not clear about your solution... hope all is well.
You would have managed it before responding to me... wasted tiem
Be prepare for hidden hills ;)
Edited by: Srini VEERAVALLI on Mar 29, 2013 2:24 PM
I have the exact same situation as you explained in the original problem.
Could you please elaborate the solution that resolved the problem so I can try in my scenario.
Really appreciate your assistance.
Thanks in Advance,