x

1. Open the Control Panel.
2. Select a report layout pane (Drill Down or Drill Across) to indicate how you want the new sort dimension to be used in the report.
3. Expand a dimension in the Dimensions pane at the top of the window, then click the dimension element you want to add to the designated layout pane. The new dimension is added to the bottom of the list.
4. If you wish to change the position of the new sort field, click the up arrow to reposition it.
5. Click Run to execute your report with the new settings.

Top of page

Example: Adding a Dimension Element From the Control Panel

The following is an example of adding a dimension element from the Control Panel.

1. Run the Standard Report REP2.

   Initially the report is sorted by quarter, store, and product type, as shown in the following image.

   

   You want to sort by month within each quarter.

2. Click the square button next to QUARTER to open the Control Panel.
3. In the Control Panel:
   1. Click in the Drill Down panel to activate the buttons immediately above the pane.
   2. Expand the Time Period dimension and click MONTH. It is added to the bottom of the Drill Down list.
   3. Click the Shift Up arrow twice to move MONTH below QUARTER, as shown in the following image.

      

4. Click the Run button at the bottom of the Control Panel.

   The report is now sorted by quarter, month, store, and product type, as shown in the following image.

   

x

Right-click the dimension column you wish to remove and choose Delete from the menu.

The report runs automatically.

Top of page

Example: Deleting a Dimension Element From the Report

The following is an example of deleting a dimension element from the report.

1. Run the Standard Report OLAPREP2.

   Initially the report is sorted by quarter, store, and product type. You wish to remove PRODTYPE as a sort category.

2. Right-click the PRODTYPE column and choose Delete from the menu, as shown in the following image.

   

   Note: The options available may vary, depending on your OLAP format settings. For more information, see Setting OLAP Reporting Options.

   The report runs automatically. The new report is sorted by quarter and store, as shown in the following image.

   

x

1. Select the element in the Drill Down or Drill Across pane. The buttons above the pane become active.
2. Click Remove . The element is deleted from the Drill Down or Drill Across pane.
3. Click Run to see the new report.

Top of page

Example: Deleting a Dimension Element From the Control Panel

The following is an example of deleting a dimension element from the Control Panel.

1. Run the Standard Report OLAPREP2.

   Initially the report is sorted by quarter, store, and product type. You wish to remove PRODTYPE as a sort category.

2. Click the square icon button next to QUARTER to open the Control Panel.
3. Select PRODTYPE in the Drill Down pane, as shown in the following image.

   

4. Click the Remove button.
5. Click the Run button at the bottom of the Control Panel.

   The new report is sorted by quarter and store, as shown in the following image.