on 06-10-2019 7:30 AM
I have a requirement where I need to pass multi valued input parameter from a table function to a multi valued input parameter in HANA calculation view.
Is using loop the only option?
Please suggest
What is not working with the syntax provided in the official documentation? Of course the "dynamic part" aka the string containing the multi-value parameters needs to be prepared in a variable which is used in the query on the calc. view.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
It now worked. changed to datatype to nclob from nvarchar for handling multiple input parameter values
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
101 | |
13 | |
13 | |
11 | |
11 | |
7 | |
6 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.