O'Reilly logo

Microsoft® SQL Server® 2008 MDX Step by Step by C Ryan Clay Bryan C Smith and Hitachi Consulting

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Implementing Attribute-Hierarchy Restrictions

Attribute-hierarchies are restricted through allowed and denied sets assigned to a database role. An allowed set identifies the members of an attribute-hierarchy the users in a role are permitted to access. A denied set identifies the members to which the users in a role are denied access. Both allowed and denied sets may be employed to fine-tune an attribute-hierarchy restriction but most database roles make use of just one or the other.

Note

Note

By restricting the members of an attribute-hierarchy, the other hierarchies in the dimension are restricted through auto-exists functionality.

In most implementations, ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required