Is it possible to use a 'wild card' in a query prompt?
For example, rather than select a Name from the Values list and get data just for that Name, enter a wild card to retrieve data for all Names.
From the BO User Guide "Accessing Data and Data Analysis..."
Using wildcard characters
Conditions with the Match pattern and Different from pattern operators are great
for finding lists of similar values, such as customer names beginning with S.
Wildcards are special characters that can denote any single character, or any
number of characters. BusinessObjects supports the standard wildcard
characters, which are:
% Replaces several characters, or in the
response to a prompt. For example, N%
returns all values beginning with an N (New
York, Nevada)
_ Replaces a single character in a constant. For
example, GR_VE returns Grave, Grove,
Greve.
Cheers for that.
I found the answer after I posted. I was getting no results because I was using 'Equal To' instead of 'Matches Pattern'.
(Heavy week and my brain has gone soft)
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.