How to pass multiple values to query variable in design studio

[former_member334261]

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

[TammyPowlas]

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?

[former_member334261]

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

[former_member334261]

I'm still unable to figure out this problem.

[MustafaBensan]

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.

[former_member197738]

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