Columns Tab (Drillthrough Options Dialog Box)
Use this tab to select the columns that are displayed when a drillthrough is executed.
Important If you select a column to which a cube role is denied access and then grant drillthrough permissions to the cube role, you will create a security exposure. (You can deny access to a column by using either dimension security or cell security. For more information, see Dimension Security and Cell Security.) When the end users in the cube role drill through, they will access the denied column.
If you are editing a cube, options in this tab can be overridden in the cube's partitions. For information about accessing the drillthrough options of a partition, see Specifying Drillthrough Options.
Options
Column
Select the columns that are displayed in the result set when a drillthrough is executed. By default only the tables in the cube's or partition's schema are displayed. To add other tables in the cube's or partition's data source, click Add Table, and then use the Select Table dialog box.
Table
View the tables in which the columns are defined.
In multiple-partition cubes, fact table names can vary among the partitions. However, if you are editing a multiple-partition cube, the Columns tab displays only the columns and tables in the cube's default partition. For drillthrough in a multiple-partition cube, Microsoft® SQL Server™ 2000 Analysis Services automatically changes the fact table name, if necessary, for each partition.
Add Table
Click to display the Select Table dialog box, where you can add a table and its columns to the list. You can select tables only from the data source of the cube or of the partition.
Select All
Click to select all columns.
Deselect All
Click to clear the selections of all columns.