DrillDown into Dimensional Data

The DrillDown feature enables you to use a predefined drill-down path to go directly to the next item in a hierarchy when working with dimensional analysis. For example, you may need to find out if a particular product sells better in different regions of the country. Using a drill-down path, all you have to do is follow the drilldown path to discover which state or even city is a more appropriate market for your product.

  To drill down into a Pivot or Chart label:

  1. Select any label for drill-down analysis.

    Because the drill-down into feature is not context sensitive, access the drill-down from any label shown.

  2. Click Drilldown into on the shortcut menu.

    All available drill-down paths are displayed. Each drill-down path shows the topic which is being drilled into, and the label from which it was drilled.

  3. Click the drill-down label.

    After you specify the drill down label, the label is added to the data layout and breaks out the additional data according to the label selected for drill-down.

  To drill up from data:

  1. Click the label that has been drilled downed.

  2. On the Pivot or Chart menu, select Drill Up.

    The report is redisplayed, reversing the drill-down and displaying the original item.