Chapter 7. Dimensional security 199
Figure 7-90 shows a metadata tree with only Unit Cost, Unit Price, Unit Sales Price measures
visible.
Figure 7-90 Restricted view of metadata tree
When the user queries the same report as the administrator, they see a different result
because of dimensional security (Figure 7-91).
Figure 7-91 User queries as administrator
The members Camping Equipment, Mountaineering Equipment, Personal Accessories, and
Golf Equipment are not visible to Alan White under the All level. Only Outdoor Protection is
visible under the All member.
Also, under Outdoor Protection, Insect Repellents and its descendants, and Insect Bite Relief
under First Aid, are not visible to the user.