Where Can I Drill?

You can drill in the following types of views:

• Table and Pivot Table
• Graphs
• Maps
• Drilling in Tables and Pivot Tables

When you drill down in a table or a pivot table, the detail level data is added to the current data. For example, when you drill from a continent, the table displays data for the continent and for the countries in that continent. For an attribute column, the list of members in the header is expanded, and it includes the original member.

The way that you drill in tables and pivot tables depends on the column type, as described in the following sections:

Drilling in Attribute Columns

To drill in an attribute column, click the heading or member in which you want to drill. When you hover over the value before clicking, an underline is displayed below the value to indicate that you can click to drill.

When you drill in an attribute column, you add the lower level to the view. All views are affected by drilling in an attribute column, which is equivalent to a filter drill. After you click the value, a column is added to the analysis and a filter is automatically created and listed in the Criteria tab.

You cannot drill on groups for attribute columns. To see the definition of a group for an attribute column, edit the corresponding step in the Selection Steps pane.

Drilling in Hierarchical Columns

To drill in a hierarchical column, click the Expand and Collapse icons beside the members. Click to expand or collapse one level. For example, expanding from Total Products to Products inserts the Product members while retaining the value for Total Products.

When you drill in a hierarchical column, you expand and collapse the nodes of data that are in the view. Drilling in a hierarchical column affects only that particular view. No other views are affected.

Drilling in level-based hierarchies and value-based hierarchies works the same. Each time you drill in a hierarchy, you expand or collapse one level. For example, if the hierarchy has a level for continents, regions, and cities, and the view shows continent data, you can expand from Australia down one level to display regions in Australia. From there, you can expand one level from a region, to cities in that region, or you can collapse one level, back to continents.

When you drill, the drill state is preserved. If you collapse at a higher level and re-expand, then the members are re-displayed at the same drill point.

When you click the Collapse icon, you collapse back to the current level any levels in the hierarchy that are present in the analysis, regardless of whether they were added by drilling down or by adding the levels from the Subject Areas pane.

You can perform asymmetric drilling, which enables you to drill various members to different levels. For example, if you expand World, then you might see Americas, Asia, and Australia at the same second-level for continents. You can then drill Americas to expand it and see its regions, while Asia and Australia are not expanded.

You can expand and collapse the members of a group for hierarchical columns. For example, if you have a group that includes cities and the group is included in a view, then you see the cities when you click the group name.

Drilling in Graphs

When you drill down in a graph, the detail level data replaces the current data. For example, when you drill down from a continent, the graph displays data for the countries in that continent, but not for the continent itself.

You can drill down in the following ways:

• You can click a label (for which drilling is available) on any axis or in the legend to drill down. A change in the mouse pointer indicates that drilling is available.
• If the graph contains only attribute columns and measure columns, then you can click a data point to drill all columns.
• If the graph contains multiple columns including at least one hierarchical column, then when you click a label or a data point, you see a menu from which you can select which columns to drill down. If there are action links available, then the menu also displays those links.

You do not drill up in a graph. Click the Back button on the browser to return to a previous graph.

Note:

The time series line graph does not support drill down on a time column where data types other than data or date-time are used.