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!
Subscribe to:
Post Comments (Atom)
Thanks for sharing such nice information with us.
ReplyDeletehotmail sign in hotmail