Results 1 to 3 of 3

Thread: Ranking Dynamically

  1. #1
    Join Date
    Nov 2008
    Posts
    1

    Ranking Dynamically

    Hi,



    I use the following MDX to rank the RAV value dynamically but i have a problem, In my Pivot table report when i put the Semi-additive measures next to this, the ranking become zero for every item..



    Could somebody help me solve this




    iif( IsEmpty( [Measures].[RAV% @])

    OR


    Axis(1).Item(0).Item( Axis(1).Item(0).Count - 1

    ).Hierarchy.CurrentMember.Level.Ordinal = 0

    ,

    null,

    Rank( Axis(1).Item(0).Item( Axis(1).Item(0).Count - 1

    ).Hierarchy.CurrentMember,

    Intersect(

    Order(

    Extract( Axis(1),

    Axis(1).Item(0).Item( Axis(1).Item(0).Count - 1

    ).Hierarchy

    ),

    [Measures].[RAV% @],



    ASC

    ),

    NonEmpty(

    Axis(1).Item(0).Item( Axis(1).Item(0).Count - 1

    ).Hierarchy.CurrentMember.Level.MEMBERS,

    { [Measures].[RAV% @] }

    )

    )

    )

    )

  2. #2
    Join Date
    Jun 2004
    Location
    Atlanta and Manhattan
    Posts
    607

    Is "RAV% @" the Parameter?

    Is "RAV% @" the parameter placeholder? Is it based upon a calculated member by that exact name?

    Thanks.

    Bill

  3. #3
    Join Date
    Nov 2008
    Posts
    1
    Yes, RAV % @ is a calculated member and the ranking is based on this.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •