SYMPTOM
When multiple answers are provided for SAP HANA input parameter, Strategy generates following SQL:
select a11.DAY_DATE DAY_DATE,
sum(a11.QTY_SOLD) WJXBFS1
from "_SYS_BIC"."tutorial/AN_ORDER_DETAIL_CURR"
('PLACEHOLDER' = ('$$INPUT_CURRCY$$', 'EUR'),
'PLACEHOLDER' = ('$$INPUT_DATE_CURR$$', '20030109'),
'PLACEHOLDER' = ('$$INPUT_DATE_CURR$$', '20030113'))
a11
group by a11.DAY_DATE
select a11.DAY_DATE DAY_DATE,
sum(a11.QTY_SOLD) WJXBFS1
from "_SYS_BIC"."tutorial/AN_ORDER_DETAIL_CURR"
('PLACEHOLDER' = ('$$INPUT_CURRCY$$', 'EUR'),
'PLACEHOLDER' = ('$$INPUT_DATE_CURR$$', '''20030109'', ''20030113'''))
a11
group by a11.DAY_DATE
select a11.DAY_DATE DAY_DATE,
sum(a11.QTY_SOLD) WJXBFS1
from "_SYS_BIC"."tutorial/AN_ORDER_DETAIL_CURR"
('PLACEHOLDER' = ('$$INPUT_CURRCY$$', 'EUR'),
'PLACEHOLDER' = ('$$INPUT_DATE_CURR$$', '20030109'),
'PLACEHOLDER' = ('$$INPUT_DATE_CURR$$', '20030113'))
a11
group by a11.DAY_DATE
select a11.DAY_DATE DAY_DATE,
sum(a11.QTY_SOLD) WJXBFS1
from "_SYS_BIC"."tutorial/AN_ORDER_DETAIL_CURR"
('PLACEHOLDER' = ('$$INPUT_CURRCY$$', 'EUR'),
'PLACEHOLDER' = ('$$INPUT_DATE_CURR$$', '''20030109'', ''20030113'''))
a11
group by a11.DAY_DATE
In Strategy 2019, before Update 3, with Data Engine Version 11, when the user supplies more than 2 values to answer the prompt, there is a syntax error due to incorrect quoting.
SYMPTOM
In the case above, if 3 answers are provided for SAP HANA input parameter, Strategy generates following SQL:
select a11.DAY_DATE DAY_DATE, sum(a11.QTY_SOLD) WJXBFS1 from "_SYS_BIC"."tutorial/AN_ORDER_DETAIL_CURR" ('PLACEHOLDER' = ('$$INPUT_CURRCY$$', 'EUR'), 'PLACEHOLDER' = ('$$INPUT_DATE_CURR$$', '''20030109'', ''20030113,''20030109''')) a11 group by a11.DAY_DATE
select a11.DAY_DATE DAY_DATE, sum(a11.QTY_SOLD) WJXBFS1 from "_SYS_BIC"."tutorial/AN_ORDER_DETAIL_CURR" ('PLACEHOLDER' = ('$$INPUT_CURRCY$$', 'EUR'), 'PLACEHOLDER' = ('$$INPUT_DATE_CURR$$', '''20030109'', ''20030113'',''20030109''')) a11 group by a11.DAY_DATE