SAP Knowledge Base Article - Preview

3636637 - Decimal Rounding behavior for Key Figures with Units in SAC Story based on BW Query

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

SAP Analytics Cloud all versions ; SAP BW/4HANA all versions ; SAP Business Warehouse all versions ; SAP S/4HANA all versions

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.