Effects of Drilling on Filters and Selection Steps

This is a short description.

Drilling in columns affects their filters and selection steps as described in the following list.

• Hierarchical columns: No steps are added to the selection when you expand or collapse members in a hierarchical column. That is, the expanding and collapsing does not change the selection of data for the column.

  For example, suppose that you create a pivot table in which you select 2008 as the only member in the Time dimension, and you arrange the data so that this one Time member is the column header in the pivot table. You can expand to show quarters in 2008 and then the months in the last quarter. At this point the pivot table has child members for 2008, Q1 2008, Q2 2008, Q3 2008, Q4 2008, October 2008, November 2008, and December 2008. If you display the Selection Steps pane, however, you see that the selection for the Time dimension still contains only the 2008 member.

  Expanding and collapsing in a hierarchical column affects only that particular view. No other views are affected.

• Attribute columns: You can drill down from the row heading or column heading or from a member in an attribute column. Drilling on a heading adds the lower level to the view. Drilling on a member adds the lower level and affects both filters and selection steps:

  • Drilling on a member adds a filter for the current member, thereby limiting the results. For example, if you drill on the Game Station member in a table that includes the P1 Product column, you add the E1 Sales Rep Name column, which adds a filter that specifies that P1 Product equals Game Station.

  • Drilling on a member adds the lower-level column to the analysis and updates the column in the Selection Steps pane without providing a step update during design.