Arun C
I had followed exactly the same approach specified in the paper without using parent child dimensions. I had created "blank" members instead of the same name as the parent member. Now, the issue is, I have to make the measure's aggregation as "FirstChild" so that it takes the "blank" member's value for the parent.
Another issue is, I have multiple dimensions in the cube and I have aggregated data across dimensions in my source. For Example,
Col1 Col2
Dimension A Level1 Member1 Dimension B Level 1 Member 1 1000
Dimension A Level1 Member1 Dimension B Level 2 Member 1 500
Dimension A Level1 Member1 Dimension B Level 2 Member 2 500
Dimension A Level2 Member1 Dimension B Level 1 Member 1 2000
Dimension A Level2 Member1 Dimension B Level 2 Member 1 1000
Dimension A Level2 Member1 Dimension B Level 2 Member 2 1000
Thanks
Arun