How to add counter to Hana View

[Former Member]

I am new to HANA Modeling and I am not sure how to add a Rank column. 

Here is my data

Employee     Date            Seq Value     

E001            6/21/2016        01            

E001            6/21/2016        02             

E001            6/22/2016        02            

The data will be sorted by Employee, Date, Seq Value

I want to add a Rank column for each unique Employee + Date combination

Employee     Date            Seq Value      Rank

E001            6/21/2016        01                1

E001            6/21/2016        02                2

E001            6/22/2016        02                1

Can I do in a Calculation View or do I need to write an SQL Script?

Thanks.

Sandy

[muthuram_shanmugavel2]

Hi Sandy,

These can be done by Graphical Calculation View.

Please find the Calculation View design and Output below.

Calculation View Design:

Data Preview Output:

Regards,

Muthuram

[pfefferf]

Hello Sandy,

you can do this in a graphical Calculation View.

Check the online help: Create Rank Nodes - SAP HANA Modeling Guide for SAP HANA Web Workbench - SAP Library.

Regards,

Florian