Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
lochew
Starting Member
3 Posts |
 Posted - 2006-05-17 : 16:25:33
|
| Hey Everyone,I’m just looking to find out if there is a switch or option that can be enabled within MSAS 2000 in order to change the date order from ascending to descending. I have a flat date that pulls 2004 -2006 dates (24 month rolling) and want MSAS to display the dates in a descending order… 2006 – 2004. I was looking at the "Order" function as an mdx solution. Any other thoughts? I also created a SQL view to sort descending but that didn't help.Cheers |
|
|
anuj164
Starting Member
49 Posts |
Posted - 2006-06-08 : 16:37:33
|
| you can change the order by property in the dimension |
 |
|
|
|
|
|
Date Dimension Question