Copying value from cross dimension to another cross dimension in same database cube
hello all,
i am writing one business rule to copy data from one cross dimension to another cross dimension.
we have Entity members like
0711
0611
0211.......etc
and Intercompany (custom dimension) members like
IC0711
IC0611
IC0211.................etc
suppose we have data for combination 0711->IC0211 = 500
now we want to copy this data to 0211->IC0711
do you have any idea on this one.
Can i use Xwrite to copy this data to another cross dimension.
Xwrite(@currmbr(Entity)->@currmbr(Intercompany),@loopback,A,B)
where in this Variable A will hold member 0211 and Variable B will have IC0711