MatchPattern wildcard % behavior in Webi report

[former_member630262]

Hi,

I have a requirement where user don't want to put wildcard (%) in start and end of the string to search into database from webi report Prompt.

Is there any way to add wildcard in user input string start and end like %xxxxxx%

User input : xxxxxx

String requirement to hit DB for search pattern : %xxxxxx%

SAP BO version : 4.2 sp9

Report is on top of IDT single source universe

underlined database : SQL server

Thank you very much!

Nav

[nscheaffer · Accepted solution]

I do not think you can do this from within WebI with a universe query. You could with free-hand SQL, but that can be more complex to create and you lose some of the perks of using a universe. Perhaps using custom query script and adding the wildcards would be an acceptable compromise.

Outlet_Lookup.State  LIKE '%' + @Prompt('Enter State:','A',,Mono,Free,Persistent,,User:0) + '%'

Here are the results of a simple query using custom query script against the eFashion universe to retreive data for states that match the pattern of '%lor%'.

If you have control over the universe you could use this same approach in a universe prompt.

None of these options are great, but hopefully you can find something workable for the user.

Noel

[former_member630262 · Accepted solution]

Hi Noel,

Thank you very much for your respond. That's a great idea to use universe level parameter based on custom script LOV. I did the same thing taking user input in WHERE clause of universe object embedded with "%" and used the same object as filter of "Object from this query" to avoid redundancy at prompt level in Webi report.

Bingo ! its work fine to find the company names without wildcard entry in input string!

Thanks again for your great help!

Company_Lookup  LIKE '%' + @Prompt('Enter Company name:','A',,Mono,Free,Persistent,{' '},User:0) + '%'