Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Rank() in WEBI for BOXIR3.1


I want to use Rank function in webi BOXIR3.1 SP3 FP5. DataBase used is SQL server2005.

I am using the function : Rank(Total;Machine)

"Total" is measure and "Machine" is dimension based on which ranking is done. So I get result in the below mentioned way.


Machine Total Rank

M1 1000 1

M2 1000 1

M3 800 2

M4 800 2

M5 600 3

M6 200 4

But I need that each row should be ranked with different number.

Machine Total Rank

M1 1000 1

M2 1000 3

M3 800 4

M4 800 6

M5 600 7

M6 200 8

Previously in BOXIR2, there use to be Rank() and Dense_Rank() as two seperate functions, but in XIR3.1 the Rank() is working as Dese_Rank()...!!!

How do I implement to have different rank values for each row?



Not what you were looking for? View more on this topic or Ask a question