Skip to Content
0

Ranking in SAP HANA

Mar 24, 2017 at 09:20 PM

149

avatar image

Hello Experts,

I am trying to generate Top 10 Vendor using Calculation View, I was able to generate ranking by using ranking node. Example it is giving 30 vendors names but I want to display only Top10 vendor by invoice paid.

Thanks,

Guna

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

2 Answers

Benedict Venmani Felix Mar 24, 2017 at 09:53 PM
2

Hi,

The RANK node should have a 'Threshold' field where you can give a fixed value or a variable(input parameter controlled). Just mention 10 and 'invoice paid' as order by field.

Share
10 |10000 characters needed characters left characters exceeded
Gunasekhar RAYA Mar 27, 2017 at 03:02 PM
0

Hi Felix,

Thank you. I was doing the same but not able to get what I am looking.

Ex: Below is my data.

I am looking at Top2 vendors for whom I paid invoice.

I have Threshold as 2, Order by Vendor and Partition column by Invoice paid but I am not getting Top2 vendors in the list.

Kindly advice.

Thanks,

Guna



capture.png (3.8 kB)
Show 2 Share
10 |10000 characters needed characters left characters exceeded

Hi Guna,

Since you are want to identified who paind the most, your 'Order By' column should be Invoice Paid and you should partition by 'Vendor'. This way you rank the amounts and then pick the top 2 and see who the vendor is.

0

Hi Felix,

I did the same but still I am not able to get top2 vendors, below is the screenshot of the same, Kindly advise.

capture1.png (24.4 kB)
capture1.png (24.4 kB)
0