Symptom
SAC Story or Data Analyzer based on a BW Query via BW Live Connection or S/4HANA Live Connection is executed.
There is a unit e.g. PC (Piece) that has the setting of 0 in transaction CUNI for field "Decimal Rounding" (that is table T006 field ANDEC).
In SAC, for key figures with this unit, below symptoms are observed:
- The values that are smaller than or equal to 0.4 are displayed as 0. ("Decimal Rounding" setting is applied)
- The values that are larger than 0.4 are displayed with the decimal places. ("Decimal Rounding" setting is ignored)
For example:
- 0.328 is displayed as 0
- 0.487 is displayed as 0.487
- 0.562 is displayed as 0.562
- 2.796 is displayed as 2.796
On the other hand, in transaction RSRT or Analysis for Office, all values are rounded to 0 decimal places according to the "Decimal Rounding" setting.
- 0.328 is displayed as 0
- 0.487 is displayed as 0
- 0.562 is displayed as 1
- 2.796 is displayed as 3
Read more...
Environment
SAC BW Live Connection or S/4HANA Live Connection
Product
Keywords
T006 DECAN ANDEC 0,4 0.4 0,5 0.5 max_prec return_on_zero zero , KBA , LOD-ANA-LDC-BW , SAC Live Data Connection BW , BW-BEX-OT-OLAP , Analyzing Data , BW-BEX-OT-BICS-INA , BW INA provider , Problem
About this page
This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).Search for additional results
Visit SAP Support Portal's SAP Notes and KBA Search.
SAP Knowledge Base Article - Preview