Symptom
Setting Drill To Detail Measure Decimal Places from Measure Configuration screen.
Environment
SAP Successfactors Workforce Analytics
Cause
Earlier the decimal values used to get derived from measures datatype & decimal precision from DBI which is the setting that is meant to be for the Aggregate level. For Average Headcount this is 1 decimal place.
Resolution
Before Fix:
Earlier the decimal values used to get derived from measures datatype & decimal precision from DBI which is the setting that is meant to be for the Aggregate level. For Average Headcount this is 1 decimal place.
After Fix:
The number of decimal places in Drill to Detail(WFA on HANA) is now determined based on the Datatype that is used in the WFA on HANA Data Factory -> Measure Configuration page.
Where the changes are reflected:
- QueryWorkspace
- Export(xls/xlsx)
- Report designer / runtime
Note:
This will not affect the aggregated measures on site, only Drill To Detail, and will affect all metrics where decimal values are returned. Some examples include:
- Currency measures (based on configuration)
- Average measures (Average Headcount, FTE, and derived measures based on these)
Keywords
Drill to Detail Decimal Places Average Measures Measure Configuration , KBA , LOD-SF-WFA , Workforce Analytics & Planning , Product Enhancement