Mindmajix

Formatting options

After learning how to add and remove characteristics and key figures in our workspace (get a quick revision from Adding or removing characteristics and key figures),  we will now continue by formatting the elements in the cross tab.

Our workspace from the previous section (see Figure 4.35) shows the characteristics, Country and Region in the Rows and the key figures Net Value, Product Cost, and Transport Cost in the columns.

Screenshot_171

Figure 4.35 Analysis Workspace
  1. Select characteristic Country in the Rows of the Layout Panel.
  2. Use a right-click to open the context menu.
  3. Select the menu Display as (see Figure 4.36).

Screenshot_172

Figure 4.36 Menu – Display as

Here, you can select between the different display options for the characteristic. The list of available options depends on the definition of the InfoObject in SAP NetWeaver BW and not necessarily on how the display options for this characteristic have been defined in the BEx query.

      4. Select the option Text.

      5. Now select the column Net Value.

      6. Navigate to the tab Display (see Figure 4.37).

Screenshot_173

Figure 4.37 Tab Display

      7. Click on Measure Format (see Figure 4.38).

Screenshot_174

Figure 4.38 Formatting Measures

Here you can select between the different formatting options for all key figures. The option Server will format the number based on the configurations in the BEx query.

After formatting the characteristics and key figures we will use the options to sort the data in the next section.

 

 

 


 

 

 

0 Responses on Formatting options"

Leave a Message

Your email address will not be published. Required fields are marked *

Copy Rights Reserved © Mindmajix.com All rights reserved. Disclaimer.
Course Adviser

Fill your details, course adviser will reach you.