Priority Rule with Formatting Settings 

Use

You can maintain formatting settings for the numerical display of key figures (such as decimal places, scaling factors, highlighting, local calculations and formula collisions) in various places in the system.

You are already able to change formatting such as decimal places and scaling factors in the InfoObject Maintenance (under Tab Page: Additional Properties). In the Query Designer, you can make changes to the formatting settings in the Properties of Structure Elements. You can override these settings during the Analysis in Web or in the BEx Analyzer.

The system functions so that always the last made setting is displayed. In addition to the setting, the system also saves the order in which the settings were made and displays the last made setting.

Features

Settings for the Properties of Structure Elements

Collisions may arise with settings for the properties of structure elements in the Query Designer when two structures are involved.

When a structure element of the row structure gets a scaling factor of 1000 and a structure element of the column structure gets a scaling factor of 10, a cell results in which the two settings collide. In this cell, the system has to decide which of the two scaling factors, for the row (1000) or the column (10) is displayed.

The priority rule – that the last changed setting is the one used – as described above is also valid here. 

Unanticipated display results can arise when using reusable structures, since the settings sequence is saved for each query and the sequence information in the other queries in which the structure is used is not fully available.

For more information, see SAP note 568630 under point 3.

Decimal Places

The settings for decimal places have the following priority:

       1.      The following applies depending on whether you work in the Web or in the BEx Analyzer:

¡        When working on the Web, immediately move the settings you have made and saved in the local properties of the key figure.

¡        When working in the BEx Analyzer, move the settings that were saved with the workbook when starting the workbook the next time.

The following applies if you have not made a setting:

       2.      The settings in the structure element are moved upon execution.

The following applies if you have not made a setting:

       3.      The special SAP standard is moved upon execution. This special SAP standard is identical to the settings in the InfoObject or the settings in a calculated key figure.

The following applies if you have not made a setting:

       4.      The generic standard is moved upon execution.

This generic standard stands for currencies in table TCURR, for amounts in table T006. The standard settings are moved for the counter and quotient, the currency settings are moved for price (calculation accuracy takes up several positions.)

The generic standard is set as follows:

Amount: 2 decimal places

Amount: 3 decimal places

Price: 2 decimal places

Counter: 0 decimal places

Quotient: 4 decimal places

Float: 7 decimal places

Others: 5 decimal places

Note the following when displaying decimal places:

¡        Decimal places are not correctly displayed in transaction RSRT.

¡        Changes to the tables T006 or TCURR are not transferred when refreshing in the BEx Analyzer (the reason for this is the internal buffering of the table). To see the changes you need to log out of the system and log back in.

¡        With the changes to the table T006, no more decimal places are displayed than is set in the generic standard (the reason is that data is saved to the database).

¡        Changes to the InfoObject are not updated until after the query has been regenerated (after refreshing). The reason for this is that changes only flow into the query upon generation.