cancel
Showing results for 
Search instead for 
Did you mean: 
Read only

Aggregation Function for Rank Node for calculation view

former_member856331
Discoverer
0 Likes
1,827

calcularion-view-b13.xml

Hello,

I am reading the documentation for the rank node in HANA Site

https://help.sap.com/docs/SAP_HANA_PLATFORM/e8e6c8142e60469bb401de5fdb6f7c00/bc4c7c14e8e546458a9c8c8...

where we can define several aggregation as :

In the Aggregation Function dropdown list, select a value.

Supported Aggregation Function for Rank Node Function Description Row This aggregation function sequentially numbers the rows within a partition of a result set, with the first row of each partition assigned as 1. The output of this function can be non-deterministic among tie values. Rank This aggregation function returns duplicate values in the ranking sequence when there are ties between values and the next rankings are skipped. Dense Rank This aggregation function performs the same ranking operation as the Rank function, except that rank numbering does not skip when ties are found. Sum This aggregation function performs the ranking operation for records based on the cumulative sum specified as a target value for the sort column. The records are ranked sequentially until the cumulative sum of the the sort column records is equal to or lesser that the target value specified.

But in my option in Eclipse, I don't have it.

My definition of the calculation view in xml is attached in this question. Where I don't see this aggregation definition for the rank node .

I would like to know, how can I change this property to apply the right aggregation function ?

My system version is :

Thank you,

Sincerely ,

Eugenio Miliani

Accepted Solutions (1)

Accepted Solutions (1)

fedaros
Product and Topic Expert
Product and Topic Expert

Hi Eugenio,

When modeling with SAP WEB IDE you have more options which was not downported to SAP HANA Studio, see the info for Studio here:

https://help.sap.com/docs/SAP_HANA_PLATFORM/fc5ace7a367c434190a8047881f92ed8/ae18b09861934d41bb0565e...

Despite, SAP HANA DB supports it the modeling tool are limiting you in this case.

Regards, Fernando Da Rós

former_member856331
Discoverer
0 Likes

Hi Fernando ,

thanks for your answer!!.

Which other option, can I use to change the aggregation function ?


Best regards,

Eugenio Miliani

fedaros
Product and Topic Expert
Product and Topic Expert
0 Likes

Hi Eugenio,

Unfortunatelly, your only option is start to use WEB IDE to model it.

Another option is to you be creative catching the Rank order, filtering and perform other operations with aggregation.

Regards, Fernando Da Rós

Answers (0)