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)
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 the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
