Skip to main content
Planview Customer Success Center

V2014 Cognos filter screen missing values

SYMPTOMS

In a Cognos fitler screen, a drop down list does not propose all possible values (e.g. all available workgroups).

 


ANSWER

1. Make sure you use a separate query for the parameter values. If you reuse the main query from your report, the filter value drop down list will only propose values for which the report would return data. This might be or might not be the behaviour required.

2. Access control is also applied to queries for parameter values. E.g. a drop down list on the workgroup query subject will only show workgroups you have access to. To bypass security (for the entire report), you can use the unsecured data model in Changepoint V2014 SP2 and above.