Skip to Content

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 a comment
10|10000 characters needed characters exceeded

Related questions

2 Answers

  • Best Answer
    Posted on 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 a comment
    10|10000 characters needed characters exceeded

  • Posted on 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 a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.