How to specify drillthrough options for a virtual cube

Analysis Services

Analysis Services

How to specify drillthrough options for a virtual cube

To specify drillthrough options for a virtual cube

  1. In the Analysis Manager tree pane, under the database that contains the virtual cube, expand the Cubes folder.

  2. Right-click one of the source cubes of the virtual cube, and then click Edit.

  3. On the Tools menu, click Drillthrough Options. (If this command is not available, the cube structure is not valid. You can determine the problem by clicking Validate Cube Structure on the Tools menu.)

  4. In the Drillthrough Options dialog box, ensure that the Enable drillthrough check box is selected. Drillthrough must be enabled on the source cube before you can enable drillthrough for the virtual cube.

  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. (Optional.) If you do not want drillthrough to be enabled for the source cube after selecting the display columns, clear the Enable drillthrough check box. This option provides users the ability to drill through to the selected columns through the virtual cube but not through the current source cube.

  8. Click OK.

  9. In Cube Editor, on the File menu, click Save.

  10. (Optional.) If there is more than one source cube, select the name of the next source cube from the Cube box within Cube Editor. Repeat Steps 3 through 9 as necessary for each source cube.

  11. Exit Cube Editor.

  12. In the Analysis Manager tree pane, right-click the virtual cube for which you want to enable drillthrough and click Edit. If the properties pane is not expanded in Virtual Cube Editor, expand it by clicking Properties beneath the tree pane.

  13. Click the Advanced tab of the properties pane, and then click the value next to the Enable Drillthrough property.

  14. Click True to enable drillthrough for the virtual cube.

  15. In Virtual Cube Editor, on the File menu, click Save.

See Also

Cube Role Manager

Database Role Manager

Specifying Drillthrough Options