How to return values from hana view and pass to other to filter data based on that

Feb 22, 2017 at 02:20 PM|48 Views

Hi , I have a Hana calculation view where I would like to get multiple single values like top 5 and lets say field name is Products. I want to take these 5 products and pass to another view to return result set and return data to client. SO in-short , I want to call a view that will calculate top 5 products and then take those multiple single values and pass to another view to get results based on those 5 products.. I was thinking may be first view can have call to procedure and then it makes call to another view/procedure to get results and return.. Could you please share some algorithm or best way to get this done.