cancel
Showing results for 
Search instead for 
Did you mean: 

How to generate sequence in HANA Views ?

Former Member
0 Kudos

Hi Team,

I have a requirement of generating sequence in HANA Views .

1. sequence  in whole set of data.

2. sequence  in according/group by to any Region , Top 5 store according to region .

Please help me how to achieve that ?

Thanks

Anupam

Message was edited by: Tom Flanagan

Accepted Solutions (0)

Answers (2)

Answers (2)

Wineman
Product and Topic Expert
Product and Topic Expert
0 Kudos

Hi Anupam,

have you solved this in the meantime? I tried also a little bit with sequence numbers in calc views, but have not achieved it up to now.

thanks

wolfgang

former_member182302
Active Contributor
0 Kudos

Hi There,

In SP09 , I think it gives an option of "RANK" . Which you can use

Regards,

Krishna Tangudu