Skip to Content
0

How to pass multiple values to query variable in design studio

Aug 25, 2017 at 08:42 AM

157

avatar image
Former Member

I used setVariableValueExt() for multiple values but its not working.

10 |10000 characters needed characters left characters exceeded

Hello Ali - I have changed your tag from ByDesign (which is a Cloud product) to Lumira Designer

Have you searched for this? Which version of the product are you using - 1.6 sp? 2.0?

0
Former Member

thanks for your contribution I'm using SAP BusinessObjects Design Studio (Release 1.6 SP5 Patch 2)

0
Former Member

I'm still unable to figure out this problem.

0

Hi Ali,

In order to try to assist further we will need more details, such as:

1) What type of data source you are using: BW Bex, HANA or Universe;

2) An example of the multi-value string you are trying to pass.

Regards,

Mustafa.

0

Hi Ali

Sometimes its tricky to figure out what format filter is reading when applied, such as semi-colon, comma separation for multiple values.

Try this

  • Take Text component (Text_1)
  • Take Dimension Filter and add DS_1 (Source) assign desired Dimension and Target Data source (DS_2).
  • Add script to Dimension Filter "TEXT_1.setText(DS_1.getFilterExt("ZXXX_LOB"));
  • Pass single value as filter for test, then pass multiple values and see the output on TEXT_1 how values are concatenating.
  • Similar way pass using SetVariableExt.

Note if you are trying to filter on dates it will be quite tricky as you may see output as "MM/DD/YYY" however when you want to retrieve passing setvariableExt, good possibility is it may be looking for different format "DDMMYYY.

*** below screenshot after semi-colon there is SPACE. Things to consider

Hope it helps

Regards,

Fahad

filter.png (81.5 kB)
1
* Please Login or Register to Answer, Follow or Comment.

0 Answers