Tuesday, June 16, 2009

Parameter Maps on 8.3

I've been using parameter maps to implement data level security on Cognos 8.3
After some Cognos patches were installed my reports stopped to work.
It took me quite a while to trace the problem back to my use of parameter maps.
(The error messages did not help - business as usual.)
The parameter map I'm using is based on a SQL query. I think this is where Cognos got mixed up...
My queries are dimensional queries working off PowerCubes.
I have a feeling this did not mix well with the SQL in the parameter map.

I found a way to fix it... cannot really explain why it works but it did... so I'm sharing it here, maybe it can help someone.

I changed the value of the "Use for Parameter Info" proprty of the queries.
On the prompt page I set it to "Yes" and on the report I set it to "No"
This fixed the problem.

If anyone has related experience please share it in comments!