Objective
After completing this lesson, you will be able to Change data 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.
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.
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.
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 Totals → Calculate Totals As menu option in the Analysis ribbon.
Note
For a complete list of all options and their descriptions, please see the Analysis Plug-in User Guide.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.
Log in to track your progress & complete quizzes