How do You Manually Fill In a Prompt without Respecting the Case Sensitivity Constraint?
| The information in the article refers to |
BusinessObjects
Universe Design
A report has been created with a prompt in the query panel.
You enter values in the prompt in either lower case, or a mix of upper and lower case, and you receive the message "No Data to Fetch".
Cause: All values in the database are stored in upper case and the Oracle database is case-sensitive.
*****CONFIGURATION******
BusinessObjects version 11
*****RESOLUTION******
Use the function UPPER in the definition of the object.
For example:
- Object: Select_a_Country
- Select: Customer.country
- Where: ucase(Customer.country) =ucase(@Prompt('Which Country?','A','Customer\Country',,))
- This ensures that the comparison will only take into account uppercase strings.
- The WHERE clause above can be embedded in the WHERE clause of an object or it can be in a predefined condition (Insert > Condition).
