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

Technote (troubleshooting)


Problem(Abstract)

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.

Symptom

Incorrect data results


Cause

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

Environment

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

Rate this page:

(0 users)Average rating

Document information


More support for:

Cognos Analytic Applications
Adaptive Warehouse

Software version:

10.1

Operating system(s):

Windows

Reference #:

1640501

Modified date:

2013-06-11

Translate my page

Machine Translation

Content navigation