oderby and oderbyattribute | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

oderby and oderbyattribute

Anyone know what is the differnt between oderby and oderbyattribute property for a dimesion?
How to apply oderbyattribute and what situation can use this oderbyattribute ?
At AS2000, it have custom order, but AS2005 I can see it.
Any help is appreciated.
Thanks
to correct above statement :At AS2000, it have custom order, but AS2005 I can not see it. Anyone know how to order the result base on the measure value.
eg : Dim Product
Prod A 200
Prod B 100
Prod C 150 then the result order as below:
Prod B 100
Prod C 150
Prod A 200
Thanks
If you want to order the prod dim in MDX then
1>create set of product dimension members.
2>Apply order function to order the members based on the measure. With set myset as
product.product.members Select order(myset,measures.Prodvalue) On 0
FROM cubename
quote:Originally posted by tboonleong to correct above statement :At AS2000, it have custom order, but AS2005 I can not see it. Anyone know how to order the result base on the measure value.
eg : Dim Product
Prod A 200
Prod B 100
Prod C 150 then the result order as below:
Prod B 100
Prod C 150
Prod A 200
Thanks

]]>