Skip to Content
avatar image
Former Member

Ranking in SAP HANA

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Mar 24, 2017 at 09:53 PM

    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.

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Mar 27, 2017 at 03:02 PM

    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


    Add comment
    10|10000 characters needed characters exceeded