Skip to Content

Unable to Creat Multiple Pattern Filter prompt

Hello Experts,

I am trying to create a single filter prompt which will to take one pattern, multiple pattern or all values of that field.

I have created a filter that uses a parameter in Universe that takes one pattern value or * for all values.

In parameter settings I have unchecked the "select allow multiple" value checkbox.

Since, I want the user to select more then one pattern and select the check box " Allow multiple values", I get an error when I do so while using that filter(see error message image below):

I have read some blogs stating that SAP BO IDT and WebI doesn't allow multiple patterns to be entered in one filter. Is it true? If not can I have a solution how I can implement this?

Trying to achieve:

I want the user to enter as many patterns in the prompt as he/she wants in 1 prompt and get a solution as the image below but in WebI.

Tools Using:

SAP Web Intelligence 4.2 SP03, Information Design Tool 4.2 SP03

Thanking you in advance,

Best,

Bassam Jamil

1.png (17.8 kB)
2.png (11.7 kB)
5.png (19.0 kB)
6.png (6.2 kB)
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Best Answer
    Mar 20 at 08:31 PM

    Thank you for your reply Amit. I did manage to get it done by using the REGEXP_LIKE Function in a filter created in the universe. The user can enter different patterns separated by pipe( | ) operator in a single filter. e.g. LEE|PE|BAS

    Add comment
    10|10000 characters needed characters exceeded

  • Mar 15 at 12:35 PM

    Yes in webi you can not use multi pattern in the prompt.other option you can try to create multiple prompts let say 5 optional pattern prompt and based on the user need they can enter values in 1 or all 5.

    Add comment
    10|10000 characters needed characters exceeded