Report Portal

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

 

2007-2015 VidasSoft Systems Inc.