Select the Basic tab to modify basic security settings for attribute hierarchies in the selected dimension. The Basic tab has the following options:
Select the attribute hierarchy for which you want to manage member security.
The selected attribute hierarchy appears in the attribute member display. You can use this display to view child members and allow access to members. To view child members, expand or collapse parent members. To allow access to a member for the role, select the member.
Select all members
Select to grant access to all members listed in the attribute member display, and to automatically grant access to new members added to the topmost level of the attribute hierarchy.
Deselect all members
Select to revoke access to all members listed in the attribute member display, and to automatically revoke access to new members added to the topmost
Select the Advanced tab to modify advanced security settings for individual attributes in the selected dimension. The Advanced tab has the following options:
Select the attribute for which you want to manage member security.
Allowed member set
Type the Multidimensional Expressions (MDX) statement used to define the set of allowed members for the specified attribute. Click Edit MDX to open the MDX Builder dialog box in which you can edit the MDX statement. For more information, see MDX Builder (Analysis Services - Multidimensional Data).