Date dimension Sort order

Hot Topic

SQL Server 2005 incorrectly claims I don't meet minimum service pack level requirements?
How do I display/upgrade SQL license Info
Cluster install fails
Can not get SQL Server Management Studio to Start
Putting Multiple Field data in a report table cell
Deploying Custom Task to Production Server
AS2005 - Displaying time calculations in a Perspective
Urgent:The Query works in 2000 but fails in 2005
Subreports don't work in 2005 that did work in 2000
DCOM error

SQL Server

How to publish reports to production environment?
Willing to distribute an application including SQL Servre Express
How can I turn off the encrypted login feature?
Merge Replication - Weird Conflicts for no reason
Report Services Question
script in removing primary key..
Parameters failing when supplied by a query and set up to execute
Securables for Application Role in Management Studio do not stick
Create .SDF from .MDF File
Using the RDL Export function from Proclarity Desktop Professional

Date dimension Sort order

Hi-

I have a date dimension with year (number), month(Month name), and day(number) as part of a cube which I'm generating an offline cube from.

While browsing the cube in either VS or in the offline cube, through Excel, the months end up sorted alphabetically (April, August...) and the days of the month are sorted in the fashion of 1,10,11...2,20,21...

Anyone have any suggestions or ideas of what I'm doing wrong

Thanks,

Tristan

Answer this question

Date dimension Sort order

  • Benjamin Coats

    You should mark your days as 01, 02, 3... to avoid the order issue you are seeing.

    For the month, you should create a Month of year attribute (Jan - 01, Feb - 02, etc...) and then use the sort property ont he month attribute to sort it by the Month of Year attribute....



  • alb52

    That worked perfect! Thanks much!
  • Date dimension Sort order
Answer this question