SCOPE and LinkMember on Role Playing Dimension

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.

April 27th, 2015 9:53am

Hi mortenbpost,

Thank you for your question.  

I am trying to involve someone more familiar with this topic for a further look at this issue. Sometime delay might be expected from the job transferring. Your patience is greatly appreciated.  

Thank you for your understanding and support. 

Thanks,                           

Free Windows Admin Tool Kit Click here and download it now
April 29th, 2015 1:55am

Thanks,

Still no insights on this one?

Thanks.

May 4th, 2015 10:39am

Any suggestions for Morten?

Thanks!

Free Windows Admin Tool Kit Click here and download it now
May 11th, 2015 12:44am

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics