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.
There are three tabs in the key figure properties dialog box:
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.
You can display the scaling factor currently applied in an additional cell using Display Scaling Factors inQuery 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.
The standard settings for the scaling factor and the number of decimal places correspond to the settings that you made for query design underSelection/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 underTab 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.
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.
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:
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:
The properties dialog box for the selected key figure appears.