x

1. Open the Control Panel.
2. Select the Stack Measures check pane to display measures in separate rows under one column.
3. Click Run to execute your report.

Tip: To restore the standard display, deselect the Stack Measures check pane and rerun the report.

Top of page

Example: Displaying Stacked Measures

The following is an example of displaying stacked measures.

1. Run the Standard Report OLAPREP4.

   Initially, this report is sorted vertically by Continent and Risk_Class and horizontally by Region, and the measures (Balance and CANADA_DOLLARS) appear as separate columns.

2. For this example, you will not need the Region dimension, but you will need the Country dimension. You can quickly make these changes to the report:
   1. Right-click Region and select Delete from the menu.
   2. Right-click Continent and select Unhide from the menu, then select Country from the secondary menu.

      The report now displays data by Continent followed by Country, as shown in the following image.

      

      You wish to show the measure titles and data values in rows.

3. Click the OLAP button on the band below the Selections pane to open the Control Panel.
4. Click the Stack Measures check pane below the Measures pane, as shown in the following image.

   

5. Click Run to execute the report and display the titles and values of the measures stacked over each other in separate rows, as shown in the following image.

   

x

To reposition a numeric column, drag and drop the field into a new column position.

The cursor changes to a plus sign (+) to indicate acceptable places into which you can drop the field. (Unacceptable positions are indicated by a circle with a slash cross the center.)

Top of page

Example: Repositioning Measure Columns

The following is an example of repositioning measure columns.

1. Run the Standard Report OLAPREP2.

   As shown in this image, the column for the Quantity measure precedes the column for the Line Cost of Goods Sold measure.

   

2. To change the order of columns, drag and drop Line Costs of Goods Sold before Quantity.

   The cursor changes to a plus sign (+) to designate where you can drop the field. The report, as shown in the following image, now displays the Quantity column as its last column.

   

x

To hide a measure column, right-click the column title and choose Hide from the menu. The column is automatically removed from the display.

To expose a hidden measure column, right-click a displayed measure and choose Unhide from the menu. A secondary menu lists any hidden measures.

Choose the one you want to reexpose in the report.

Tip: If you want to add a new measure to the report, you must return to the original request and add the field there.

Top of page

Example: Hiding and Exposing a Measure From the Report

The following is an example of hiding and exposing a measure from the report.

1. Run the Standard Report OLAPREP2.

   The report includes two measures: Quantity and Line Cost of Goods Sold.

2. Right-click the Line Cost of Goods Sold and choose Hide 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 and displays only the Quantity measure.

3. Right-click Quantity and select Unhide.

   A secondary menu displays the hidden measure.

4. Select LINE_COGS to redisplay Line Cost of Goods Sold, 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 now displays the Line Cost of Goods Sold column, as shown in the following image.

   

x

1. Click the down arrow to the left of the Measures control to display a list of the measures in the report.
2. Click the check pane next to a measure to display or hide it. The check pane toggles through three positions.
   • To hide the measure, click the check pane until it is blank.
   • To expose a hidden measure, click the check pane until you see a check mark.

Tip: You can use the same check pane to display a column of data visualization bar graphs for numeric measures. This setting is represented as a graph in the check pane. For details, see Visualizing Trends.

Top of page

Example: Hiding and Exposing a Measure Column From the Selections Pane

The following is an example of hiding and exposing a measure column from the Selections pane.

1. Run the Standard Report OLAPREP2.

   Because of the OLAP settings selected for this report, the Selections pane is hidden. For this example, you will need to expose it.

2. Right-click QUARTER and select Show Panel from the menu.

   As shown in the following image, the report now looks like this: two measures (Quantity and Line Cost of Goods Sold) appear.

   

3. In the Selection pane, click the arrow to the left of the Measures control to list the measures in the report. Notice that both measures are checked.
4. To hide Line Cost of Goods Sold, click the check panel until it is blank, as shown in the following image.

   

5. Click the Run button on the band below the Selections pane.

   Only Quantity now appears, as shown in the following image.

   

6. Open the Measures control again and recheck Line Cost of Goods Sold, as shown in the following image.

   

7. Run the report again.

   The output now looks as it originally did.

x

1. Open the Control Panel.
2. In the Measures pane, click the check pane next to a measure to display or hide it. The check pane toggles through three positions.
   • To hide the measure, click the check pane until it is blank.
   • To expose a hidden measure, click the check pane until you see a check mark.

   Tip: You can use the same check pane to display a column of data visualization bar graphs for numeric measures. This setting is represented as a graph in the check pane. For details, see Visualizing Trends.

3. Click Run to execute your report.