Share via


Cubes (Role Designer) (SSAS)

Use the Cubes page of Role Designer to specify cube permissions for the role.

Note

All options on this page are not available if Full control (Administrator) is selected on the General page of Role Designer.

Options

  • Cube Name
    Displays the name of the cube.
  • Access
    Selects the access level for the selected cube in this role. The following table lists the available access levels.

    Value Description

    None

    Users will be unable to access information from the cube.

    Read

    Users will be able to read information from the cube.

    Read/Write

    Users will be able to read from and write to information to the cube.

  • Local Cube/Drillthrough Access
    Selects the access level for local cube or drillthrough functionality with the selected cube in this role. The following table lists the available access levels.

    Value Description

    None

    Users are unable to access information from the cube.

    Drillthrough

    Users are able to use drillthrough functionality, but unable to create local cubes from the cube.

    Drillthrough and Local Cube

    Users are able to use drillthrough functionality and create local cubes from the cube.

  • Process
    Grant users who are in this role permission to process the selected cube.

    Note

    This option is selected but not available if the Process database option is selected on the General page of Role Designer.

See Also

Reference

Role Designer (SSAS)

Other Resources

Roles (Analysis Services)

Help and Information

Getting SQL Server 2005 Assistance