MSAS - Defining and Creating Drillthrough Page - 2

Specifying Drillthrough Options for Individual Partition

In the Analysis Manager tree pane, under the cube that contains the partition, expand the Partitions folder.

Right-click the partition, and then click Edit.

Advance to the Finish step of the Partition Wizard, and then click Advanced.

In the Advanced Settings dialog box, click Drillthrough. Note that drillthrough options for the parent cube has to be enabled for the option to be available for the partition.

In the Columns tab, select the columns to be displayed when drillthrough is executed.
Please note that if the users select a column to which a cube role is denied access and then grant the cube role the ability to drill through, security exposure will be created. (Access to a column can be denied by using dimension security or cell security.). When the end users in the cube role drill through, they can access the denied column.

Optional.) In the Filter tab, specify a filter (WHERE clause expression) to limit the result set returned by drillthrough. Do not include the keyword WHERE. For example, to limit the result set to fourth quarter data, specify:

"shipment_facts"."quarter"=4

Click OK.

In the Advanced Settings dialog box, click OK.

In the Partition Wizard, click Finish.