on 03-13-2018 6:13 PM
I have a view with a parameter that will be used in a projection node filter. This is how I would like it to process:
1) User selects a customer group from a pre-defined list in Parameter 1.
2) In Parameter 2, it calls a stored procedure that takes the value from Parameter 1 as input. It looks up the list of customers for the customer group. It then assigns the list of customers in one string value, separated by commas to the OUT parameter. For example, 'ABCD','DEFG'.
3) The HANA view will then take this value and put it in a filter. The filter will read in("SOLDTO",'$$PARAMETER2$$').
This causes an error.
since you are passing multiple values to 1 input parameter.. the calc view behaves differently... it adds 1 single quote to the beginning and end of your string value.... try passing your value as.... 'val1'',''val2'',''valN' (start/end w 1 single quote and 2 single quotes in between value and comma -
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
91 | |
10 | |
10 | |
9 | |
9 | |
7 | |
6 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.