Drilling on a Grid/Graph in a document is similar to drilling on a report. Drilling allows you to look at specific data at levels other than that of the originally displayed Grid/Graph. It allows you to retrieve more information after the document has been executed. The new data is obtained by requerying the database at a different attribute or fact level.
Before you can drill on a Grid/Graph in a document, you must enable drilling for that Grid/Graph. Steps to enable or disable drilling for a Grid/Graph are below.
This procedure assumes you have already added the Grid/Graph you want to drill on to the document.
Open a document in Design Mode or Interactive Mode.
Right-click the Grid/Graph, then select Properties and Formatting. The Properties and Formatting dialog box is displayed.
From the left, select Grid.
In the Drilling section, select one of the following from the Drill drop-down list:
To disable drilling, select No drilling.
To allow users to only drill using objects that are within the dataset report, select Drill within. Only drill paths from the drill maps that are included in the dataset report but not already on the report grid are displayed to the user.
To allow users to drill on attributes other than those available in the dataset, select Drill anywhere. All drill paths in the drill map for the dataset report are shown. If the dataset does not have a custom drill map, the drill paths in the project drill map are used.
Click OK to save the changes and return to the document.