February 5, 2010 at 12:05 pm
Greetings all.
So I have a custom calendar dimension that my cube uses for dates that is not ordering properly. It is based off of a view which is ordered correctly (I tested by selecting data from the view). The main column which is a yyyymmdd column is ordered correctly both in the view and in the cube and is also they dimensions key within the cube. all the other columns have the order by property as key, yet they seem to be ordered alphabetically. For instance the month column is ordered april, august, december, etc.
How do I fix this so that they are ordered properly?
Link to my blog http://notyelf.com/
February 5, 2010 at 2:04 pm
Out of interest, is the key on your Month attribute something like 201001 for January 2010 and 200912 for December 2009? If the key is actually the same as the Name (ie April, December etc) then you're getting it sorted exactly as requested 🙂
Steve.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply