Hi,

I have a pretty simple question. Is it possible to scope a role playing dimension only hitting the one with a certain role. An example would be to scope "Delivery Date.Members, Sales" without it having impact on "Sales Date.Members, Sales"

Or do I really need to import the same table twice in my DSV?

Thanks.

Hi M,

Your Scope statement will use the name of your cube dimension, which will be different for each role playing dimension.

Hope that helps,

Yes it is possible as with in cube dimension will be refereed by its Role Paying name.

Hi again,

Yeah that's what I tried. However when I do like this:

SCOPE ([Role Playing Dim].[AttributeA].[AttributeA].Members, [Sales]);

THIS = 1;

END SCOPE;

All members in the same [Non Roleplaying Dim].[AttributeA] is also set to 1.

Hi mortenpost,

According to your description, when you scope a role playing diemsnion. It works on the source dimension as well. Right?

In this scenario, please make sure your fact table has the both source dimension key column and role playing dimension key column. It seems your fact data only relate to role dimension, so when you scope the tuple (fact data slicing by the role playing dimension), it makes effect on the all the fact data slicing by same dimension key. Please try to use nested scope statement like:

SCOPE([Measures].[Sales]);
   SCOPE([Role Playing Dimension].members);
       This=1;
   END SCOPE;
END SCOPE;

Regards,

Hi Simon,

Thanks. My fact has a relation to my dimension on both the source key and the role-playing key and it is also the case in the dimension designer. Making it a nested statement makes no difference.

I guess it is not possible to do and it's supposed to work like this by design.