Does anyone know how to turn off Sorting for Time dimension?

[Shab]

Hi All,

My time table is sorted through a time_id field and I have the year, the quarter, the month and the day. OLAP sorts this dimension Alphabetically and I cannot do anything about it. Any ideas?

Thanks

 

[Shab]

Hi All, I figured it all myself If the base column in the time table is of type DATE and then OLAP builds the year, the quarter, the month and the day from that base column, the sorting will work fine.

 

[padelg]

The order is different of the hierarchize.
Define the hirarchize for instance Year-Quarter-Month-Week-Day, and forget the number id of your primary key

regards

 

[issahar]

I think that I know what is your problem:
in every level of your time dimension
the key data type property must be numeric, e.g. integer, so your data will be sorted by numeric order.
I guess that currently your key data type is char or varchar.

Thanks
Issahar
senior software engineer

http://www.softwatch.com