Skip to Content

Passing special characters in SAP Design Studio Query

Dec 26, 2017 at 03:43 PM


avatar image

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!!

10 |10000 characters needed characters left characters exceeded


How are you displaying your list box values?.

Thru a code?.




Hi Jothi,

List box values are populated through code - LISTBOX_1.setItems. The values contain '('.

* Please Login or Register to Answer, Follow or Comment.

2 Answers

Tammy Powlas
Dec 26, 2017 at 03:48 PM

Hi - I recommend searching for this; I searched and found these threads:

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

10 |10000 characters needed characters left characters exceeded
Karthikayan Thirumallai 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


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

We are using SAP Lumira Designer 2.0 SP2 Patch 1.

10 |10000 characters needed characters left characters exceeded