May 17, 2010 at 12:00 pm
Hi,
Im basically setting up a olap cube for browsing for the user from Excel 2007. I have provided a date dimension with a hirararchal feature. I am struggling however to make the month order in the correct order. That is 1=jan,2=feb, 3=march. Instead it is ordering by the actual month name which is not user friendly on run time. Any help with screen shots will be most appreciated.
May 17, 2010 at 10:33 pm
You should update the definition of the dimension so that you have the dimension sorted as you want it. The 2 properties you need to change are "OrderBy" and "OrderByAttribute"
May 18, 2010 at 3:22 am
Set the OrderBy property to Key of your month attribute.
Reprocess the dimension and see if it works.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
May 24, 2010 at 12:20 am
Here is the link what you exactly needed:
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply