Changing Data Displays

Objectives

After completing this lesson, you will be able to:

  • Change data displays

Dimension/Attribute Member Displays

You can change how members (values) of dimensions and attributes are displayed in the crosstab: text only, key, or a combination of the two. Select the column header containing the dimension/attribute name and choose the desired option from the Members menu option in the Analysis ribbon.

The Member button in the Analysis ribbon to change how members are displayed in the crosstab

Measure Displays

You can specify the number format for each measure in your analysis, including the scaling factor, decimals used (Number Format . . .), currency conversion, and how zero and negative values are displayed (General Format . . .). Select the column header containing the measure name and choose the desired option from the Measures menu option in the Analysis ribbon.

The Measures button in the Analysis ribbon to change how measures are displayed in the crosstab

Totals Displays

You can define whether totals are displayed in the crosstab, and if they are displayed, you can decide where they are displayed. You can also define how the totals can be calculated. Select the column header containing the measure name and choose the desired option from the Totals menu option in the Analysis ribbon.

The Totals button in the Analysis ribbon to change how Totals are displayed in the crosstab

By default, totals are usually summed. However, you can change the totals calculation if that is helpful to your analysis. Select the column header containing the measure name and choose the desired option from the TotalsCalculate Totals As menu option in the Analysis ribbon.

The Calculate Totals As options
Note
For a complete list of all options and their descriptions, please see the Analysis Plug-in User Guide.

Change Data Displays

As the company analyst, you have been asked to create a new analysis workbook on your BW/4HANA system, which you can access from your SAP BusinessObjects BI Platform. You want to use features such as pause refresh, member display, and totals displays.

Task 1:

Log in to track your progress & complete quizzes