Dimension Editor - Order By property

Hello
I have the "Order By" property set to "Name". By default this is in
ascending order. But I need to sort in descending order. How can I change
this?
Thanks
Imrahn
You can't set the order to descending directly, but you can create a Member
Property with a formula that orders in the reverse order.
For example :
100 - ASCII(<column>)
Jacco Schalkwijk
SQL Server MVP
"Imrahn Gamildien" <IGamildien@.PICSolutions.com> wrote in message
news:%23u$1pdbXEHA.2544@.TK2MSFTNGP10.phx.gbl...
> Hello
> I have the "Order By" property set to "Name". By default this is in
> ascending order. But I need to sort in descending order. How can I
change
> this?
> Thanks
> Imrahn
>
|||You can't set the order to descending directly, but you can create a Member
Property with a formula that orders in the reverse order.
For example :
100 - ASCII(<column>)
Jacco Schalkwijk
SQL Server MVP
"Imrahn Gamildien" <IGamildien@.PICSolutions.com> wrote in message
news:%23u$1pdbXEHA.2544@.TK2MSFTNGP10.phx.gbl...
> Hello
> I have the "Order By" property set to "Name". By default this is in
> ascending order. But I need to sort in descending order. How can I
change
> this?
> Thanks
> Imrahn
>