on ‎2023 May 17 12:49 PM
Hello,
I am reading the documentation for the rank node in HANA Site
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
Request clarification before answering.
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:
Despite, SAP HANA DB supports it the modeling tool are limiting you in this case.
Regards, Fernando Da Rós
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
| User | Count |
|---|---|
| 13 | |
| 8 | |
| 7 | |
| 5 | |
| 4 | |
| 3 | |
| 2 | |
| 2 | |
| 2 | |
| 2 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.