Drill Across Worksheets

Use

This function enables you to create a separate worksheet in your workbook for each instance of the selected characteristic. A copy of the current worksheet is created for each member of the characteristic. The worksheets are fully independent from one another with respect to navigation.

Prerequisites

Note that this function is only available in the context menu of a characteristic in the navigation pane if:

• The selected characteristic is free, that is, is not in the drilldown.
• The selected characteristic is filtered on no more than one list of single values.
• No display hierarchies can be active.

Activities

You call the function in the context menu as follows:

1. You call this function in analysis mode by using the context menu for the selected characteristic in the navigation pane.
   • Select the cell using the secondary mouse button.
   • Or in the menu, choose BEx Analyzer → Context Menu for Selected Cell.

     The context menu that provides access to navigational functions for the selected cell appears, if available.

2. You choose Drill Across Worksheets in the context menu.

Example

You want to display the net sales for each quarter. Using this function, you generate a view of the data for the query; in this view, the net sales for each quarter are displayed on separate worksheets.

1. In the navigation pane, choose the Quarter characteristic using the right mouse button.
2. In the context menu for the selected cell, choose Drill Quarter Across Worksheets.
3. For each member of the selected characteristic Quarter, the system generates a current worksheet with the net sales for each quarter.