3832182 - How to identify the data source of a column in Story report

• How to identify the data source of a column in Story report.
• A column in a Story report displays unexpected data.
• You are unsure what data a specific column is pulling from the SF system.

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

SAP SuccessFactors Platform

• Story report

When the data source of a column in a Story report is unclear, you can identify it by checking the Column ID.

1. Open the Story report.
2. Navigate to the Query Designer (Data Source).
3. Go to Column Overview.
4. Check the Column ID. 
5. The Column ID follows a path-based naming convention: <Schema>#<Object>#<Field> (example: user_information_sac#USER#USERS_SYS_ID). Therefore, the Column ID can be used as a reliable reference to determine 
   what data a column is retrieving.  

column id, verify field, verify column, what data a specific column pulling, output value incorrect, query designer, data source, Column Overview, <Schema>#<Object>#<Field> , KBA , LOD-SF-ANA-SAC-QDS , Query Designer - Filter, Calculated Column, Params , How To