IBM Support

Filter not being applied when using 'Specify Data Security' in Target model

Technote (troubleshooting)


To filter data by a particular group of employees, a Data Security filter was applied to the query subject in AW > Target Model. When running the query to test, the filter was not applied.


Incorrect data results


Not knows.. recreated the Data Security Filter and query now tests fine


Windows 7
AW 10.1

Diagnosing the problem

To diagnose the problem, simply run the query where the security filter is applied. Check the generate SQL and the filter is missing

Resolving the problem

Recreated the Security Filter

Document information

More support for: Cognos Analytic Applications
Adaptive Warehouse

Software version: 10.1

Operating system(s): Windows

Reference #: 1640501

Modified date: 11 June 2013