
166 IBM Cognos Dynamic Cubes
7.8.2 Example 1
This example shows merging two views where the second view on its own has access to all
but Boston and Calgary. However, because no grant filters are specified in security view 2,
when merged with security view 1 that has grant filters, the grant filters take precedence.
Also, the denied Calgary in security view 2 still applies in the consolidated view.
Security view 1
Figure 7-36 shows granting Canada, Mexico, Brazil, and their descendants.
Figure 7-36 Security view 1: Grant Canada, Mexico, Brazil, and their descendants