Skip to Content
0

Rank function in bods

Jul 12, 2017 at 10:28 AM

13

avatar image

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

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

0 Answers