How to specify drillthrough options for a regular cube

To specify drillthrough options for a regular cube

1. In the Analysis Manager tree pane, under the database that contains the cube, expand the Cubes folder.
   
   
2. Right-click the cube, and then click Edit.
   
   
3. On the Tools menu, click Drillthrough Options. (If this option is not available, the cube structure is not valid. You can try to determine the problem by clicking Validate Cube Structure on the Tools menu.)
   
   
4. In the Drillthrough Options dialog box, perform one of the following actions:
   • To enable drillthrough, select the Enable drillthrough check box.
     
     
   • To disable drillthrough, clear the Enable drillthrough check box. Go to Step 7.
5. In the Columns tab, select the columns to be displayed when drillthrough is executed.

   Important  If you select a column to which a cube role is denied access and then grant the cube role the ability to drill through, you create a security exposure. (You can deny access to a column by using 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 access the denied column.

6. (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
   

   For more information, see Drillthrough Filters.

7. Click OK.
   
   
8. In Cube Editor, on the File menu, click Save.

See Also

Specifying Drillthrough Options