on 08-17-2015 10:35 AM
Hi All,
We have a HANA view, with input parameter INPUT_PAR. We are using HANA studio version 1.80.3 , so to achieve multiple input value through input parameter we have written below code in the filter expression:
match("column",'$$INput_Parameter$$') or in("column",'$$INput_Parameter$$')
Now when we data preview the view with input value value1'',''value2 , our data is perfect and filtered with value1 and value2 in the same column.
Example
Column1 | Column2 | Column3(Filter applied on this column) |
---|---|---|
A | X | Value1 |
B | Y | Value1 |
C | Z | Value2 |
Now we need to consume the same query in IDT, And we have two option to do this.
1st Option: Create a project , then connection and then data foundation layer and consume the view and when we preview the data , it ask input value with popup
So we are passing the same input Value1'',''Value2. But it shows empty table in preview. If we just pass Value1 then we can see the filtered data(Correct data).
2nd Option: Create derived table in the data foundation layer and write a query:
We can write three form of query to get the data:
1st: this query works in the same way as our 1st option, so Not useful
FROM
"_SYS_BIC"."HANA_VIEW"
('PLACEHOLDER' = ('$$INPUT_PAR$$', @Prompt(Hana Variable HANA_VIEW/Column3))
2nd: this query works fine and provide perfect filtered data for value1 and value2, But hardcoded , So not useful
FROM
"_SYS_BIC"."HANA_VIEW"
('PLACEHOLDER' = ('$$INPUT_PAR$$', 'Value1'',''Value2')
3rd: Here we have created parameter(IDT_PARAMETER) in IDT only and using it to bind it with HANA INPUT_PAR parameter, But it says syntax error:
FROM
"_SYS_BIC"."HANA_VIEW"
('PLACEHOLDER' = ('$$INPUT_PAR$$', @Prompt(IDT_PARAMETER)))
Please provide us way to consume the HANA parameter in universe with multiple parameter support.
Hi Rohan
IDT didn't correctly format the SQL sent to Hana, when multiple selections. This should be resolved in SP6.
Jacqueline
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
Might be issue with Equal operator.You can not pass the multiple values with equal to operator.
Check if you can use IN operator but I am not very sure.
FROM "_SYS_BIC"."HANA_VIEW" ('PLACEHOLDER' IN ('$$INPUT_PAR$$', 'Value1'',''Value2')
3rd: Here we have created parameter(IDT_PARAMETER) in IDT only and using it to bind it with HANA INPUT_PAR parameter, But it says syntax error:
FROM
"_SYS_BIC"."HANA_VIEW"
('PLACEHOLDER' IN ('$$INPUT_PAR$$', @Prompt(IDT_PARAMETER)))
Amit
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
80 | |
24 | |
11 | |
9 | |
7 | |
6 | |
5 | |
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.