Time Hierarchy from OLAP cube displays in wrong sort order

Reply
Occasional Contributor
Posts: 8

Time Hierarchy from OLAP cube displays in wrong sort order

I have created a very basic time hierarchy in OLAP cube studio, based on year, quarter and month.  I set all the sort orders to be ascending unformatted.  But, the quarters start with 2 and the months (for quarter 2 and quarter 3) are in alphabetical order, not numeric month order.  Oddly, quarters 3 and 4 are in numeric month order, not alphabetical.

So I get:

Quarter 2    

     April     June     May

Quarter 3

     August     July     September

Quarter 4

     October      November     December

Quarter 1

     January     February     March

Am I crazy!?

New Contributor
Posts: 2

Re: Time Hierarchy from OLAP cube displays in wrong sort order

I am having a similar issue. Try following this guide, if it works for you let me know.

http://support.sas.com/kb/19/651.html

Ask a Question
Discussion stats
  • 1 reply
  • 217 views
  • 0 likes
  • 2 in conversation