Cognos 10 Search and Select Prompt

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”

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”

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



Cognos Issue PRS-TRS-0906

Issue PRS-TRS-0906

I was creating a report schedule for the user. The user provided text to add to the email body of the scheduled report. After pasting the text and clicking OK, it resulted in Error PRS-TRS-0906 The “VALIDATE” transform instruction could not validate the given XML content”


The issue was caused by copy/paste of text from the users email. This text was copied from the users email and seems to contain attributes that cognos can’t handle.


Paste the users text to notepad and copied from notepad to the body of the email. Then switched the setting to “Change to HTML format”.
The requested styling could be provided now such as bold and underlined.
Similar solution was descibed on Cognoise.com:

BI Centre Blogs