SAP Knowledge Base Article - Public

2818437 - WFA Drill to Detail CSV Export showing Incorrect Figures

Symptom

The Drill to detail export when adding a sum does not add up to the numbers on the main screen.

Image/data in this KBA is from SAP internal systems, sample data, or demo systems. Any resemblance to real data is purely coincidental.

Environment

  • HCM Success Factors
  • Workforce Analytics Drill to Detail

Reproducing the Issue

  1. Navigate to Work Force Analytics
  2. Select measure average headcount (did not select a time period or any other filters) 
  3. Observe numbers on screen
  4. Export DTD to CSV 
  5. Export table on screen 
  6. Compare sum of average headcount to numbers in WFA table - do not match

Resolution

  1. Login to the application, Navigate to OLAP WebAppPage
  2. Click on Measures link in the OLAP WebAppPage (Example Screenshot Attached)

capture_1.png

    3. Select the measure where it is needed to see exact decimal values, (for example average measure). So Select Average measure and Select Edit

    4. Change the scale and Click ok (Example Screenshot attached)

capture_2.png

5. Build the cube, A full reload is not required instead Click on "Build OLAP cube

6. Verify the build process is Success in OLAP Load Status page Job name is "Initial OLAP Processing (Debugging stage Build OLAP Cube)

Keywords

Drill to Detail, WFA, Workforce Analytics, Export to CSV, , KBA , LOD-SF-ANA , Analytics & Reporting (Ad Hoc, YouCalc, ORD) , Problem

Product

SAP SuccessFactors Workforce Analytics all versions