- The IBM Cognos Community

IBM Cognos Analytics Platform => Cognos Analytics => Framework Manager => Topic started by: BIengineer on 28 Sep 2020 10:35:21 am

Title: Cognos 11 FM embedded security filters
Post by: BIengineer on 28 Sep 2020 10:35:21 am

I am trying to add security filters to the package, but they don't seem to work due to some unknown reasons. The package deals with several dimensional and fact tables, with joins between them - In the Source layer.

Since the filters I try to add are in the same layer, I add them as embedded filters in the query subjects like so:

Code: [Select]
select col1, col2, col3 from Table_A
where (col1 not in (select col_value from Table_B where col_protected='1')
or (UPPER(#sq($account.personalInfo.userName)#) IN (select user_id from User_Table where user_access='1')))

The main idea is that there are two database tables that should:
1* Remove the col_protected rows in case they exist in Table_B
2* Select the rows in case the user has access to see the rows

The SQL itself works in Oracle, and running the Cognos Generated SQL in Oracle also works.