Different Default Members for Role Playing Dimension

I have a dimension named "Unit of Measure" that has an attribute hier named "UOM Abbrev". This dimension is used twice in my cube, named "Base UOM" and "Reporting UOM". I am trying to set the default member for the "UOM Abbrev" but it complains if I tried to set it to a value from the dimension like [Unit of Measure].[UOM Abbrev].&[Something] because [Unit of Measure] isn't found in the cube.

Yet if I try to set it to one of the specific role playing names I get an error complaining about the other role playing name.

Is it possible to have the default member for an attrib hier be different based on which role-playing dimension is being used?

I would really like to have something like this:

iif(Dimension is [Base UOM], [Base UOM].[UOM Abbrev].&[Abbrev1], [Reporting UOM].[UOM Abbrev].&[Abbrev2])

Is this possible and if so can someone provide me with syntax to handle it properly?

Thanks,

Ashton Hobbs

Hi Ashton,

You could try updating the default member for each role with cube MDX script statements instead, like:

Code Snippet

ALTER CUBE CurrentCube UPDATE DIMENSION [Base UOM].[UOM Abbrev],

DEFAULT_MEMBER = [Base UOM].[UOM Abbrev].&[Abbrev1];

ALTER CUBE CurrentCube UPDATE DIMENSION [Reporting UOM].[UOM Abbrev],

DEFAULT_MEMBER = [Reporting UOM].[UOM Abbrev].&[Abbrev2];