SSAS - Using Dimension OrderBy AttributeKey
Often when building dimensions there is a need to order you dimension attributes by something other than the NameColumn or KeyColumn properties. An example of this may be an accounting structure that is preferred to be viewed in a certain order. The data doesn't represent that order well so you create a sort column that does it for you. The sort column can be in a table or just in a SQL Server view if you prefer.
Read more...Tags: design