Chapter 7. Dimensional security 153
򐂰 Grant Americas
Figure 7-7 Granted Miami and descendants, the Americas (1)
Figure 7-8 shows the result.
Figure 7-8 Granted Miami and descendants, the Americas (2)
For security view 3, Miami is granted, United States is a visible ancestor, Americas is granted,
and the All member is a visible ancestor.
7.4.4 Examples: View merge impact on visible ancestors
Visible ancestors are based on the final view of the cube, based on security views of a user.
If the combination of security views and filters results in a granted member being denied, a
visible ancestor will not be included for that now-denied member. The following examples
merge views with security view 4 to show the resulting visible ancestors. For more information
about the consolidate view from merging views, see 7.8, “Merging of security views or
security filters” on page 164.
Security view 4: Grant Miami and descendants and grant Asia Pacific
and descendants
Figure 7-9 on page 154 shows the granted Miami and descendants and granted Asia Pacific
and descendants, for example:
򐂰 Grant Miami and descendants
򐂰 Grant Asia Pacific and descendants
154 IBM Cognos Dynamic Cubes
Figure 7-9 Granted Miami and descendants and granted Asia Pacific and descendants (1)
Figure 7-10 shows the result.
Figure 7-10 Granted Miami and descendants and granted Asia Pacific and descendants (2)
Security view 4 has visible ancestors in the All member, Americas, and United States.
Security view 5: Deny Americas
Figure 7-11 shows the Americas as denied.
Figure 7-11 Denied Americas (1)
Chapter 7. Dimensional security 155
Figure 7-12 shows the result.
Figure 7-12 Denied Americas (2)
Security view 5 has no visible ancestors.
Consolidated view from merging security view 4 and security view 5
The visible ancestors, Americas and United States, that are required in view 4 are not in the
consolidated view because the members were denied with view 2. The All member is still a
visible ancestor in the consolidated view. Figure 7-13 shows this consolidated view.
Figure 7-13 Consolidated view of security views 4 and 5 (1)
Figure 7-14 shows the result.
Figure 7-14 Consolidated view of security views 4 and 5 (2)
156 IBM Cognos Dynamic Cubes
Security view 6: Deny Miami and descendants
Figure 7-15 shows Miami and descendants as denied.
Figure 7-15 Denied Miami and descendants (1)
Figure 7-16 shows the result.
Figure 7-16 Denied Miami and descendants (2)
Security view 6 has no visible ancestors.
Chapter 7. Dimensional security 157
Consolidated view from merging security view 4 and security view 6
The visible ancestors, Americas and United States, that were in view 4 are not in the
consolidated view because Miami is denied. Figure 7-17 shows this consolidated view.
Figure 7-17 Consolidated view of security views 4 and 6 (1)
Figure 7-18 shows the result.
Figure 7-18 Consolidated view of security views 4 and 6 (2)
Security view 7: Grant Americas and descendants
Figure 7-19 shows the granted Americas and descendants.
Figure 7-19 Granted Americas and descendants (1)

Get IBM Cognos Dynamic Cubes now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.