Search and Select Prompt

At one of my customers I recently got involved in Cognos 10.2.2

During test work it was noticed that the Search & Select Prompt behaves different.

For example the prompt is filled by a query containing the following values:

“My name is Nanno”

“MY NAME IS NANNO”

“my NAME is NANNO”

Result in Search & Select Prompt:

Cognos 10.1.1 Cognos 10.2.2

“My name is Nanno”

“MY NAME IS NANNO”

“my NAME is NANNO”

“My name is Nanno”

In Cognos 10.2.2 for some reason all the “same” values (upper/lower/initcap) are merged to one value.

Of course when you filter with this merged result you will miss the data for “MY NAME IS NANNO” and “my NAME is NANNO”. Because you only filter on “My name is Nanno”.

There is a workaround found for this:

1. Go to the query that contains data for the prompt

2. Go to the properties of the query

3. Change the value “Use Local Cache” to NO

 

 

Email this to someoneShare on FacebookShare on LinkedInTweet about this on TwitterShare on Google+Pin on Pinterest

Leave a Reply

Your email address will not be published. Required fields are marked *