Skip to Content
avatar image
Former Member

How to pass multiple values to query variable in design studio

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

Add comment
10|10000 characters needed characters exceeded

  • Former Member

    I'm still unable to figure out this problem.

  • 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.

  • 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)
  • Get RSS Feed

0 Answers