I am using Cognos 11.1.2 and am converting several parameter maps which are filled manualy to parameter maps based on
existing query item. This is far more flexible because publish of the package is no longer necessary.
All the parameter maps have a default value in case a key is not found.
Load on demand is false, Freshness = -1.
The package containing the parameter map uses DQM.
The parametermap is used in the filter of a query subject. For example: [Organisation Code] in CSVIdentityName( %ParamMap )
Before using a query item this worked correctly and in the case any of groups a user belonged to did not exist as a key in the parameter map,
then the default value of the parameter map would be used.
But now the parameter map is based on a query item the default value is ALWAYS included in the result. After a lot of trying I discovered that
this issue only happens when using DQM. If I validate the filter definition, the values are not populated. Only after expanding the
parameter map on the tab parameters in the available components. If I test the query and check the query it looks good. But when I check the
Use Dynamic Qyery Mode box, then the query includes the default value.
I have tried several things like: load on demand = true, freshness = 0 or > 0, Use Local Cache, Clear cache, Governer settings. But nothing helps.
Can someone confirm this is a bug or has a solution for this problem?
------------------------------
Thomas van der Meer
------------------------------
#CognosAnalyticswithWatson