"Top N" Function in HANA

[brian_keenan]

How can I do a "top N" filter on a measure in a HANA model?

[rindia · Accepted solution]

Hi Brian,

Do you mean how to filter the data in SQL or something else?

My assumption is the first one.

Below is the data and result. Column is a measure.

   

   

Regards

Raj

[brian_keenan · Accepted solution]

Thanks Raj,

I was wondering if it is possible to do this in a calculation view or analytic view?  I dont see a TopN or rank function, maybe there is none.

[rindia · Accepted solution]

Hi Brian,

Me too could not find the relevant CE function in SQLScript.

I thought CE_CALC would be of some help but all goes in vain.

Regards

Raj

[Former Member]

Could You please tel me how to write TOP function in Query and is Subquery.????.. because Im Getting Error "Subuery Does not Support TOP" ...

[Former Member]

Please create your own thread and paste the SQL