Customize the Dimension Viewer Toolbox

You can customize the buttons that appear in the dimension viewer toolbox.

For example, you can show the three buttons that you use most often. You can also choose to position the toolbox on the left, right, top, or bottom of the pane.

The following toolbox buttons are available for only Explorer reports:

Table 1. Toolbox buttons for Explorer reports
Click	To
	Draft comment: Graphic: replace_rows_button.gif Replace the rows with the selected categories.
	Draft comment: Graphic: replace_columns_button.gif Replace the columns with the selected categories.
	Draft comment: Graphic: replace_layers_button.gif Replace the layers with the selected categories.

The following toolbox buttons are available for only Reporter reports:

Table 2. Toolbox buttons for Reporter reports
Click	To
	Draft comment: Graphic: add_as_rows_button.gif Add the selected categories as rows.
	Draft comment: Graphic: add_as_columns_button.gif Add the selected categories as columns.
	Draft comment: Graphic: add_as_layers_button.gif Add the selected categories as layers.
	Draft comment: Graphic: average_of_button.gif Show the average of the selected categories in a new category.
	Draft comment: Graphic: share_of_button.gif Show the values of the selected categories as a percentage of their higher-level category.
	Draft comment: Graphic: sum_of_button.gif Show the sum of the selected categories in a new category.
	Draft comment: Graphic: next_level_children_button.gif Add categories at the next level down from the selected category.
	Draft comment: Graphic: lowest_level_children_button.gif Add all categories at the lowest level from the selected category.
	Draft comment: Graphic: each_button.gif Show the selected categories as new individual categories in the report.
	Draft comment: Graphic: intersect_button.gif Show the intersection between two categories.
	Draft comment: Graphic: create_nesting_levels_button.gif Preserve parent/child relationship when nesting levels from a dimension.
	Draft comment: Graphic: advsubset.gif Open the Advanced Subset dialog box where you can create an advanced subset definition.
	Draft comment: Graphic: parentage.gif Open the Parentage dialog box where you can create a level subset definition.

The following toolbox buttons are available for both Explorer and Reporter reports:

Table 3. Toolbox buttons for Reporter and Explorer reports
Click	To
	Draft comment: Graphic: pp_filter_button.gif Filter data using the selected category.
	Draft comment: Graphic: long_name_button.gif Switch between short and long versions of the category names.
	Draft comment: Graphic: format_measure_button.gif Open the Number Format dialog box, where you can format the measures in your report.
	Draft comment: Graphic: find_cube.gif Open the Find In Cube dialog box where you can create a find-in-cube subset definition.

Procedure

Right-click the toolbox and click Customize.
Do one the following:
- To add a new button, click it in the Available Toolbar Buttons box, and click Add.
- To remove a button, click it in the Current Toolbar Buttons box, and click Remove.
- To reset the toolbox to the default settings, click Reset.
If you want to change the order of the buttons, click an enabled button, and click the Move Up or Move Down button until the button is positioned where you want.
If you want to add a space before a button in the toolbox, click an enabled button, and then add a Separator button.
Click OK.
To chance the location of the toolbox, right-click the toolbox and click Location.
Click one of the four docking positions.