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
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