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