Skip to Content
avatar image
Former Member

How to generate sequence in HANA Views ?

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

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

2 Answers

  • Jan 05, 2015 at 07:30 AM

    Hi There,

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

    My Favourite HANA SPS09 Features

    Regards,

    Krishna Tangudu

    Add comment
    10|10000 characters needed characters exceeded

  • Sep 01, 2015 at 06:21 AM

    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

    Add comment
    10|10000 characters needed characters exceeded