SSAS TopCount Function

[pjohns]

Is there any way to return the actual ranking indicator (e.g. '1' for the highest ranking, '2' for the next highest ranking, etc.) along with the ranked values themselves using the TopCount fucntion or any other SSAS function? We're trying to report the ranked values along with their actual rankings using SSRS.

Thanks.

...Phillip

 

[MDXer]

Yes there is a way to return the Rank Value. You neede to use the Rank() function

Rank(Tuple_Expression, Set_Expression [ ,Numeric Expression ] )

Paul
---------------------------------------
Shoot Me! Shoot Me NOW!!!
- Daffy Duck

 

[pjohns]

Thanks, Paul.