Options Tab (Cube Role Dialog Box)
Use this tab to control the role's access to data in cells in the cube for which the role is defined.
Options
Allow drillthrough
Select to allow end users in the role to drill through to the source data of a cell. This ability also requires that drillthrough is enabled for the cube or at least one of its partitions. For more information, see Specifying Drillthrough Options.
This check box is cleared and read-only if the cube role is for a linked cube. Linked cubes do not support drillthrough.
Allow linking to this cube
Select to allow end users in the role to use this cube as the source cube for linked cubes. This check box is selected by default.
Allow sending SQL queries to this cube
Select to allow end users in the role to perform SQL queries to find cell values in the cube. This check box is selected by default.