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