COGNOiSe.com - The IBM Cognos Community

IBM Cognos 10 Platform => Cognos 10 BI => Transformer => Topic started by: fshahul on 14 Apr 2015 01:15:16 PM

Title: How to Exclude members based on the Custom Views in Cognos 10.1.1 Transformer
Post by: fshahul on 14 Apr 2015 01:15:16 PM
Hi,

We have deleted the existing Custom views and created new Custom views in the existing Cognos 10.1.1 Transformer model and included Security groups for each custom views. Dragged all Custom Views under the PowerCube. Deleted and generated the categories. Switched over to the custom views tab at the categories diagram. Excluded the members for the custom views as below.

For example:
1. Custom Views with PRR Group - Nothing to exclude
2. Custom Views without PRR Group - Exclude member "X2 ABC PRR"

Built the Cube. But still I am seeing PRR data for Non-PRR group in the Cognos Report. Exclude is not working. Please suggest.

Thanks.