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.
- Make DayName attribute visible, and use DayOfWeek as OrderBYAttribute
- 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.