Security model filter is not being honoured for DMR models against dynamic query mode

Content

Within IBM Cognos Framework Manager, a modeler can restrict the data represented by query subjects in a project by creating security filters. These security filters can be embedded within the SQL of a Data Source Query Subject or defined as filter object on a Model or Data Source Query Subject. These security filters are usually created using the Session Parameters via macro expressions in order to restrict the data based on the user who is running the report.

This issue only occurs if:

1. Security Filters have been created as filter objects or embedded in the SQL within the model and utilize the session parameters via a macro expression. Some of these session paramters include but are not limited to: $account.defaultName,$account.personalInfo.userName.
   
   
2. The model is Dimensionally Modeled Relational and has been published out using the Dynamic Query Mode.

1. On each of the dispatchers in the environment, locate and backup the configuration/xqe/dmr.properties file.
   
   
2. Open the dmr.properties file using a text editor.
   
   
3. Locate the entry which reads: blockingPrePlanSameMetaDataObjects=true
   
   
4. Change the true value to false. When completed, the changed entry should read: blockingPrePlanSameMetaDataObjects=false
   
   
5. Save the changes and close the file.
   
   
6. Stop and Restart the IBM Cognos BI Service.