SSAS - Which way to order an attribute?

Posted: edited May 18 at 18:36 - Source : stackoverflow

Our SSAS cube has a date dimension, which for the DayName string member displays alphabetically instead chronologically. I added a DayOfWeek integer 1-7 to use for ordering. I have two options to accomplish this, not sure of the advantages/disadvantages of either.

  1. Make DayName attribute visible, and use DayOfWeek as OrderBYAttribute
  2. Make DayOfWeek attribute visible, and use DayName as NameColumn

The attributes are both functionally the same when setup like this. I'm leaning towards #2, since it's an int.