Wrong name when multiple relationships excist in SSAS

• mikkelden

  Grasshopper

  Points: 10

  More actions

  March 12, 2009 at 7:06 am

  #131613

  Hello

  I am having an issue with the display names of my attributes when multiple relationships are connected to my fact table.

  To be more precise i am having a fact table with, lets say:

  Yellow_ID

  Blue_ID

  Green_ID

  These ID's are related to a table called colors.

  My problem occurs when browsing the cube. The name of the different colors turns out as:

  Yellow.color, blue.color and green.color

  Is there a way to get rid of the .color, which follows all relationships, when the cube is browsed in excel or the SSAS browser?

  Thanks.

• mikkelden

  Grasshopper

  Points: 10

  More actions

  March 12, 2009 at 7:56 am

  #958319

  In other words: How to hide the dimension name.

  I have tried setting the HierarchyUniqueNameStyle to ExcludeDimensionName for the dimensions in the cube structure, but it doesn't solve my problem.