January 27, 2009 at 10:50 am
Hi all,
I havean issue with SSAS cube.
While browsing a cube in BIDS 2005, when i drag and drop a order date dimension member on the browser, i get the result set in ASCENDING ORDER.
01-Jan-2009
02-Jan-2009
03-Jan-2009
04-Jan-2009
05-Jan-2009
06-Jan-2009
I have heard that SSAS can only sort the data in ASCENDING ORDER, but not in DESCENDING ORDER.
How can i make the result set look in DESC order as below:
06-Jan-2009
05-Jan-2009
04-Jan-2009
03-Jan-2009
02-Jan-2009
01-Jan-2009
Please help on this issue.
Regards
Sri Gunti
January 27, 2009 at 8:13 pm
There are a few different ways you can do this. You could associate a column in the table, view, or create one in the data source view that you could then associate with this attribute (date). Once that is setup then you could use the OrderBy and OrderByAttribute properties and change the order to the one that you have defined.
Another option is to perform the sort in your MDX query using the Order function. You can use numeric or string expressions to Order your attribute and then you can specify DESC.
For more information look at the online help for the Order function or look at this article on ssas-info.com How in the report can I order date dimension members in descending order? .
----------------------------------------------------------------------------------------
Dan English - http://denglishbi.wordpress.com
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply