Hi Guys,
I am relatively new to BO so bare with me while I explain this. I am stuck and need help.
I have two fact tables having different granularities. So I have used context with a conformed dimension of C.
A----->C (Context 1)
B----->C (Context 2)
A has
Account_Key, Parent_Key
001-11 001-11
99-22 001-11
99-23 001-11
Account_Key has both Parent (001-11) and Childs (99-22, 99-23)
B has
Parent_Key, Amount
001-11 $100
I am currently joining C’s Account_Key on Parent_keys from A and B.
What I need to show in the report is,
Account_Key Parent_Key Amount
001-11 001-11 $100
99-22 001-11
99-23 001-11
The second and third row Amount should be blank. I told my users that this can easily be done in the report by doing if Account_key = Parent_key then give me Amount or else leave it blank. But users asked me to see if there is a way in the Universe so they can just drag and drop and get this to work without any sort of calculation on the report.
Let me know if I am not clear as this is my first posting on the board.
Please suggest.
OranjeBoy (BOB member since 2009-08-11)