Skip to Content
avatar image
Former Member

Passing special characters in SAP Design Studio Query

Dec 26, 2017 at 03:43 PM | 147 Views

We have a query on SAP Design Studio with a prompt on a dimension. This dimension contains values with '(' and ')'. We are displaying this on a list box and then trying to pass the selected value to the prompt in the query. The query refresh fails with an error "Invalid Format". Any solution to this would be highly appreciated. Thanks!!

SAP BusinessObjects Design Studio
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • avatar image
    Tammy Powlas
    Dec 26, 2017 at 03:48 PM

    Hi - I recommend searching for this; I searched and found these threads: https://archive.sap.com/discussions/thread/3703975

    https://archive.sap.com/discussions/thread/3686092

    If this doesn't help, please share some screen shots, along with version and SP of Design Studio you are using

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Dec 26, 2017 at 04:17 PM

    Hi Tammy,

    Thanks for the links and appreciate your quick response. Even in the threads I couldn't find the right answer. I have the same issue when trying to replace special characters with a '\'. Design studio throws an error "Invalid Escape Sequence". Screenshots attached.special-characters-error-2.jpg special-characters-error.jpg

    Code:

    X_Filter_BUG = Convert.replaceAll(X_Filter_BUG, "(", "\(");

    We are using SAP Lumira Designer 2.0 SP2 Patch 1.

    Add comment
    10|10000 characters needed characters exceeded