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!