2335450 - WFA - How to create a spreadsheet to upload as Static Data

SAP Knowledge Base Article - Public

2335450 - WFA - How to create a spreadsheet to upload as Static Data

Symptom

How to create a spreadsheet correctly to be able to upload it to use in a component "Static Data Table".

Environment

WFA
Online Report Designer

ORD

Reproducing the Issue

Add a table view based on static data component. Upload spreasheet containing static data.

Resolution

1. Ensure it is on the first sheet.
2. When created columns, ensure that headings contain text, or else they will be regarded as Data
3. One Column and One Row will populate the Chart correctly, more than one of each will not.
4. All data must contain only numbers, or it will not be populated correctly
5. Ensure it is in the top Left corner.
6. Ensure the Space A1 is left blank.
7. Static Charts will not access multiple sheets.
8. Static Charts will not read merged cells.
9. Static Charts will interpret numbers (even when changed in Formatting to time etc) as Data
10. Numbers with letters will be misinterpreted
11. Ensure it is in the top left corner, or it will not read properly
12. Multiple Layers of headings will be misinterpreted. Similarly, Report Designer will not distinguish colour differences between rows in Excel.
13. Percentages cannot be used as the data will be misconstrued

Keywords

KBA , LOD-SF-WFA , Workforce Analytics & Planning , How To

Product

SAP SuccessFactors Workforce Analytics 1402 ; SAP SuccessFactors Workforce Analytics 1511 ; SAP SuccessFactors Workforce Analytics 1602 ; SAP SuccessFactors Workforce Analytics 1605 ; SAP SuccessFactors Workforce Analytics 1608 ; SuccessFactors Workforce Analytics 1207 ; SuccessFactors Workforce Analytics 1210 ; SuccessFactors Workforce Analytics 1302 ; SuccessFactors Workforce Analytics 1305 ; SuccessFactors Workforce Analytics 1308 ; SuccessFactors Workforce Analytics 1311 ; SuccessFactors Workforce Analytics 1405 ; SuccessFactors Workforce Analytics 1408 ; SuccessFactors Workforce Analytics 1411 ; SuccessFactors Workforce Analytics 1502 ; SuccessFactors Workforce Analytics 1505 ; SuccessFactors Workforce Analytics 1508