cancel
Showing results for 
Search instead for 
Did you mean: 

Issue in Multi input HANA query in IDT

Former Member
0 Kudos

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

Column1Column2Column3(Filter applied on this column)
AXValue1
BYValue1
CZValue2



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

  • SELECT *

          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

  • SELECT *

          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:

  • SELECT *

          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.

Accepted Solutions (0)

Answers (2)

Answers (2)

former_member193452
Active Participant
0 Kudos

Hi Rohan

IDT didn't correctly format the SQL sent to Hana, when multiple selections.  This should be resolved in SP6.

Jacqueline

amitrathi239
Active Contributor
0 Kudos

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.

  • SELECT *

          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:

  • SELECT *

          FROM

            "_SYS_BIC"."HANA_VIEW"

          ('PLACEHOLDER' IN ('$$INPUT_PAR$$', @Prompt(IDT_PARAMETER)))


Amit



Former Member
0 Kudos

Hi Sir,

"IN" doesn't work in case of HANA input place holder placeholder. We tried this. Or if you have code please post it here.

Regards

MrRohan Ghadi

Former Member
0 Kudos

Hello All,

Can any one please help me as it's complete road block for me.

Regards,

Rohan Ghadi