-
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% @] }
)
)
)
)
-
Is "RAV% @" the Parameter?
Is "RAV% @" the parameter placeholder? Is it based upon a calculated member by that exact name?
Thanks.
Bill
-
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
-
Forum Rules
|
|