SAP Knowledge Base Article - Public

3277088 - Only two decimal places would be shown

Symptom

Analysis for Office for Excel shows a maximum of 2 decimal places for Data Warehouse Cloud measures of type DecimalFloat even you select more than 2 decimal places in Analysis for Office client tool. The rest is filled with 0.

Environment

  • SAP Analysis for Microsoft Office 2.8
  • SAP Data Warehouse Cloud

Reproducing the Issue

1.Open Analysis for Office client tool and connect to Data Warehouse Cloud.

2.Open one Analytical model.

3.Select a measure in design panel and adjust the "Decimal Places" for this measure, for example, 0,00000(5 Decimal Places) for "Revenue" in below sample:

4.It is noticed that in the crosstab, data still is displayed with only 2 decimal places and the rest is filled with 0.

Cause

The underlying database only returned 2 decimals places.

Resolution

Analysis for Office client tool for Excel is working as designed. As there is no plan to change this on the data base side, Analysis for Office could only show 2 decimal places. As a workaround, you may use data type decimal for a higher precision.

Keywords

AO, Analysis for Excel, Analysis for Office, A4O, AFO, DWC, Data Ware house Cloud , KBA , BI-RA-AO-XLA , Excel Addin , Problem

Product

SAP Datasphere all versions