Start of Content Area

Function documentation Key Figure Properties   Locate the document in its SAP Library structure

Use

You use this function to configure various settings for a selected key figure. The settings determine how the key figure works and how it is displayed in analysis mode. Settings for a selected key figure apply to all its values in the query results.

Features

There are three tabs in the key figure properties dialog box:

      Number Format – lets you configure options for displaying numbers.

      Calculations – lets you apply calculations to the displayed results.

      Sorting – lets you configure the sort order.

Note

To toggle the display of technical names, choose Display Technical Names/Do Not Display Technical Names on the tab pages.

Number Format

The following functions are available on the Number Format tab:

Scaling Factor

Use the dropdown box to set a scaling factor of 1 to ten billion (10,000,000,000). If, for example, you set a scaling factor of 1,000, the value 3,000 is shown in the analysis grid as 3.

Note

You can display the scaling factor currently applied in an additional cell using Display Scaling Factors in Query Properties.

Decimal Places

You use this dropdown box to specify the number of decimal places to be displayed, from 0 to 10. Example: Specify the number of decimal places to be displayed as 0, 0,0, 0,00… to 0,0000000000.

Background documentation

The standard settings for the scaling factor and the number of decimal places correspond to the settings that you made for query design under Selection/Formula Settings/Cell.

 If you have not made these settings in the query’s design, the system will use the default settings that you have made in InfoObject maintenance under Tab Page: Additional Properties. See also Priority Rule with Formatting Settings.

Highlight

Select this checkbox to display all the values of the selected key figure in a different color.

Note

Highlight assigns the Microsoft Excel style SAPBExEmph to the cell. If you want to display highlighted cells differently – for example, boldfacing instead of coloring their contents – simply alter this style as you wish.

 

Calculations

On this tab, you can set options for recalculating the results rows and single values that are displayed in the query results according to particular criteria:

Calculate Results As

Use this function to recalculate the results rows displayed in the report according to particular criteria. These local calculations include only those numbers in the calculation that appear in the current view of the report. In this way, you override the standard OLAP processor calculations.

More information: Calculate Results As

Calculate Single Values As

Use this function to recalculate the single values displayed in a report according to particular criteria. These local calculations include only those numbers in the calculation that appear in the current view of the report. In this way, you override the standard OLAP processor calculations.

See Calculate Single Values As

Cumulated

Use this function to cumulate the individual cells in an area. The first value is added to the second value, and the result is added to the third value, and so on. In the columns, the cells are cumulated from top to bottom and in the rows, the cells are cumulated from left to right.  With blocks of single values, that is, a drilldown in both the rows and the columns, the values are cumulated from top to bottom and from left to right.

Also Apply to Results

Select this checkbox to also apply the selected calculation to the results rows.

Calculation Direction

The default calculation direction is not always as expected. You can change the calculation direction as required using the values in this dropdown box:

      Use Default Direction (from top to bottom and from left to right)

      Calculate Along the Rows (from top to bottom)

      Calculate Along the Columns (from left to right)

Example

The Calculate Along the Columns setting is useful, for instance, for all queries for which a time dimension is drilled down in the columns, and a cumulated output is to be created.

 

Sorting

On the Sorting tab, you can configure the following sort options for the selected key figure:

      Keep Current Sort Order: Leaves the sort order as it is in the analysis grid.

      Descending: Sort in descending order.

      Ascending: Sort in ascending order.

 

Activities

...

       1.      In analysis mode, select a key figure cell in the analysis grid and access the context menu via the mouse or keyboard:

       Choose the cell with your right mouse button (secondary mouse button).

       From the menu, choose BEx Analyzer Context Menu for Selected Cell

       2.      Choose Properties.

The properties dialog box for the selected key figure appears.

 

 

 

 

End of Content Area