Hi all,

I have a base Dimension named "DimBool" [values = True/False] this is implemented into 4 different Role Play Dimensions ["isShipped, "DemoMode" etc. ]

I need to set the Default member for the "IsShipped" Role Play = True. I have read many articles on how to do this (even the forum post titled "Different Default Members for Role Playing Dimension").

However when I go apply the MDX command as follows it does not change the setting. (I have tried several permutations of this)

ALTER CUBE CurrentCube UPDATE DIMENSION [IsShipped].[Name],
DEFAULT_MEMBER = [IsShipped].[Name].&[True];

Any Ideas on how to make this work?

Note: We are using SQL Server 2012R2 (11.0.3000.0)

• Edited by John Lehmann1 Wednesday, February 18, 2015 8:35 PM

Hi John,

According to your description, you want to assign a Boolean value for a default member of a role playing dimension. Right?

In this scenario, your MDX syntax is correct. However, it should be the member_key after the "&" when you assign a value to a member. For a Boolean value, mostly the member_key should be 0 or 1. The "True" and "False" are just member name. So please change it into [1] after "&"

If you have any question, please feel free to ask.

Regards,

Still defaults to the AttributeAllMemberName (Either) on 0. True = 2 & False =1

ALTER CUBE CurrentCube UPDATE DIMENSION [IsShipped].[Name],
 DEFAULT_MEMBER = [IsShipped].[Name].&[2];