cancel
Showing results for 
Search instead for 
Did you mean: 

Simple way to create a "RANK" on a graphical Calculation-view ?

former_member290786
Participant
0 Kudos

Hi guys,

I've saw some articles around, about creating a "Rank" column, in order to select TOP N inside analysis level (Design Studio in this case).

The problem is, that all of them were incredibly complicated (comparing....), And I wonder if there's a simple way to any "Rank" function these days (or in future versions).

My source:

Thank you,

Or.

Accepted Solutions (0)

Answers (1)

Answers (1)

former_member290786
Participant
0 Kudos

ANyone?

sagarjoshi
Advisor
Advisor
0 Kudos

Just a thought.

Why not use a Scripted calc view on top of your graphical calc view and use HANA WINDOW function to derive rank()?

https://help.sap.com/saphelp_hanaone/helpdata/en/20/a353327519101495dfd0a87060a0d3/content.htm

former_member182302
Active Contributor
0 Kudos

Hello Or,

Using Script based view, you can use RANK() function.

From Graphical, I have not found any way to implement RANK. So will have to wait along with you to know, if there is an easier way to implement rank from graphical calculation view.

Regards,

Krishna Tangudu