Skip to Content
avatar image
Former Member

Escaping of apostrophe in variables with multiple values DS 1.5

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.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Best Answer
    avatar image
    Former Member
    Jul 17, 2015 at 07:11 AM

    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.

    Add comment
    10|10000 characters needed characters exceeded

  • Nov 05, 2015 at 08:18 AM

    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


    Capture.JPG (75.0 kB)
    Add comment
    10|10000 characters needed characters exceeded