About drilling

Drilling lets you view report data at levels other than that displayed in the report. For an introduction to drilling, levels, and hierarchies, see the Basic Reporting Guide.

You can drill down, up, or across attributes, some metrics, custom groups, and consolidations displayed in a report. You can also drill on a report displayed in a document, as described in Drilling on a document.

Drilling example

The results on your report are organized by countries and stores (the attributes Country and Store are on the report). The report shows sales by Country. You can drill down from the country level to see the sales for the regions that make up that country. You can also drill up from stores to view sales for the cities where those stores are located.

The relationship between attributes defines how you can drill between them. Country is the parent of Region, so you drill down from Country to Region. Region is the child of Country, so you drill up from Region to Country. Region is the parent of City, City is the child of Region and the parent of Store, and Store is the child of City.

The image below shows a report that allows you to drill on any of the Customer Regions:

Example of Drilling

Below is the drilled-to report, which is the result of drilling on the Southeast Region in the report above:

Result of the Drilling

Related topics

Drilling on a grid report
Drilling on a graph report
Drilling on objects on the Page-by axis
Using the Drill panel