SAP Knowledge Base Article - Public

2727809 - WFA on HANA - Change in Drill to Detail Measure Decimal Places configuration

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.

before.png

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.

after.png

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

Product

SAP SuccessFactors Workforce Analytics 1811