Role Designer (Analysis Services - Multidimensional Data)

Use Role Designer in SQL Server Data Tools (SSDT) and SQL Server Management Studio to define or modify a role. You can display the Role Designer dialog box in SQL Server Data Tools (SSDT) by:

  • Right-clicking the Roles folder in an Analysis Services project in Solution Explorer and selecting New Role.

  • Double-clicking a role in Solution Explorer or right-clicking a role in Solution Explorer and selecting Open or View Designer.

You can display Role Designer in SQL Server Management Studio by right-clicking the Roles folder or a role in an Analysis Services database in Object Explorer and selecting New Role.

Role Designer contains the pages listed in the following table.

Pages

Page

Definition

General

Use this page to set the name, description, and database permissions for the role. For more information about this page, see General (Role Designer) (Analysis Services - Multidimensional Data).

Membership

Use this page to specify the Microsoft Windows users and groups included in the role. For more information about this page, see Membership (Role Designer) (Analysis Services - Multidimensional Data).

Data Sources

Use this page to specify data source permissions for the role. For more information about this page, see Data Sources (Role Designer) (Analysis Services - Multidimensional Data).

Cubes

Use this page to specify cube permissions for the role. For more information about this page, see Cubes (Role Designer) (Analysis Services - Multidimensional Data).

Cell Data

Use this page to specify cell permissions for the role. For more information about this page, see Cell Data (Role Designer) (Analysis Services - Multidimensional Data).

Dimensions

Use this page to specify dimension permissions for the role. For more information about this page, see Dimensions (Role Designer) (Analysis Services - Multidimensional Data).

Dimension Data

Use this page to specify dimension attribute and member permissions for the role. For more information about this page, see Dimension Data (Role Designer) (Analysis Services - Multidimensional Data).

Mining Structures

Use this page to specify mining structure and mining model permissions for the role. For more information about this page, see Mining Structures (Role Designer) (Analysis Services - Data Mining).

See Also

Reference

Analysis Services Designers and Dialog Boxes (Multidimensional Data)

Concepts

Security Roles (Analysis Services - Multidimensional Data)