Dear all,
I have a cube with a role playing dimension. Now I would like to move values from one role playing dimension to another using linkmember() like so:
SCOPE ([Measures].[MyMeasure], [Dimension A].[Attribute].[Attribute].Members); THIS = ( LinkMember ( [Dimension A].[Attribute].CurrentMember, [Dimension B].[Attribute] ) ,[Measures].[MyMeasure] ); END SCOPE;
This just work, and I can understand why. But I would I go around scoping members on an existing measure group to move values from Role Playing Dim A to Role Playing Dim B? Must I add the same dimension again to my data source view?
The Scope statement above just causes the cube to never answer my queries. Like it's a circular dependency.
Thank you in advance.