Skip to Content
Former Member
Nov 27, 2013 at 02:34 PM

Web Intelligence Prompts and Wild Card Selections



I have a WebI report connected to a SQL server database through a Universe. There is a prompt on the report that is set to 'In List'. If a wild card is enterd (Ex. for employee - '0001*') the list of values displays for all values starting with '0001', but if '0001*' is entered as a Selected Value WebI does not recognize the wild card and displays no data. Does WebI have the ability to have a wild card added as an actual selection? Or is the wild card only used to bring up a list of values, which must then be selected by the user and moved to the 'Selected Value(s)' section?

Thank you.