Escaping of apostrophe in variables with multiple values DS 1.5

[dmitri_marinin]

Hi All,

we encountered with strange behaviour of DS 1.5 when DS 1.5 transmits variables values to HANA. Test example:

1. We set a variable value in a HANA Calculation View according to this document:

     APPLICATION.setVariableValueExt("I_SALES_GRP_VAL", "041'',''042");

2. Debug it in DS 1.5 client:

[BICS HANA](102ms) SQL:SELECT "SALES_GRP_TXTSH", SUM("COUNTER") as "COUNTER" FROM "_SYS_BIC"."D00_DS_GENERAL.M_CLCV_10"  GROUP BY GROUPING SETS WITH SUBTOTAL STRUCTURED RESULT WITH OVERVIEW PREFIX '#BICS_1434463642382_' ((("SALES_GRP_TXTSH") ORDER BY "SALES_GRP_TXTSH" ASC )) WITH PARAMETERS ('PLACEHOLDER' = ('$$I_SALES_GRP_VAL$$','041\''\'',\''\''042'))

3.Debug it in DS 1.4 client:

[BICS HANA](124ms) SQL:SELECT "SALES_GRP_TXTSH", SUM("COUNTER") as "COUNTER" FROM "_SYS_BIC"."D00_DS_GENERAL.M_CLCV_10"  GROUP BY GROUPING SETS WITH SUBTOTAL STRUCTURED RESULT WITH OVERVIEW PREFIX '#BICS_1434463686339_' ((("SALES_GRP_TXTSH") ORDER BY "SALES_GRP_TXTSH" ASC )) WITH PARAMETERS ('PLACEHOLDER' = ('$$I_SALES_GRP_VAL$$','041'',''042'))

So, our DS reports with multiple input parameters work fine in DS 1.4 Local mode but don't operate correctly in DS 1.5 Local mode or DS 1.5 BI Platform mode.

Any ideas how to fix this transformation of variables values?

Many thanks in advance,

Dmitry.

[dmitri_marinin · Accepted solution]

Hi All,

according to SAP support team they will fix the issue with DS 1.5 SP2 (Week 42, 2015). See the note 2190351 - will be released soon.

So if you need to use HANA multiple input parameters, DO NOT UPGRADE YOUR DESIGN STUDIO UP TO 1.5 SP0 OR SP1.This issue is a disaster.

[former_member227362 · Accepted solution]

Hi Dmitry,

Please update the thread once they released the service pack, since we got stuck in between and waiting for the SP update.

Thanks,

Arjun N

[dmitri_marinin · Accepted solution]

Hi Arjun,

I've tested this bug in our BO development system with DS 1.5 SP2. This issue is fixed in SP2!

Dmitry.

[former_member227362 · Accepted solution]

Hi Dmitry,

Thanks for the reply. Even we checked last Friday and is working fine. Thank you for all the support.

[former_member227362]

Hello All,

Did any one checked by selecting only one value i.e selecting only one value from the dimension filter and passing to back end HANA system. I am facing same bug if am passing one value and if am selecting multiple value from dimension filter it is working fine.Find the attached screen shot for reference and kindly help..

Regards,

Arjun N