none
Different Default Members for Role Playing Dimension RRS feed

  • Question

  • 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

    Wednesday, August 8, 2007 8:58 PM

Answers

  • 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];

     

     

    Thursday, August 9, 2007 3:33 AM
    Moderator