SQL Server Performance

oderby and oderbyattribute

Discussion in 'SQL Server 2005 Analysis Services' started by tboonleong, Jul 20, 2007.

  1. tboonleong Member

    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
  2. tboonleong Member

    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
  3. ranjitjain New Member

    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

Share This Page