Rank function in bods

[former_member214617]

Hi guys

I have gone through lot of forum question related to rank but only 1 looks what I am looking for

https://archive.sap.com/discussions/thread/3608785

I want to ask do I need to create sql function in sql server and then call sql server function in query transform in dataflow..

There is no in-build rank function in BODS.

I tried using gen_row_num_by_group(column name) but it is creating unique row number for each row for group id whereas I want it is should generate same number for group id same result expected in the forum question above mentioned.

regards