3753498 - Time type Field in Employee time object returns numeric values instead of time type codes/names in Story report

Time type Field in Employee time object returns numeric values instead of time type code/name in Story report

"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

1. Go to report center, create a new story report.
2. Select Employee Time object in query designer page.
3. Select Time Type column(column id: TIMEMANAGEMENT#EmployeeTime#timeType), set it as dimension, preview query.
4. Observe that values appear as numeric IDs instead of the expected codes or names.

Time type data needs to be fetched from separate Time Type object.

1. Add/link the related Time Type object to Employee Time object.
2. Select the External Name or External Code from Time Type object(column id: TIMEMANAGEMENT#TimeType#externalName or TIMEMANAGEMENT#TimeType#externalCode)，set as dimension
3. 
4. 
5. The Time Type code or name values will be output properly.

TIMEMANAGEMENT, EmployeeTime, timeType, TIMEMANAGEMENT#EmployeeTime#timeType, numeric id, internal id, external code, external name, ec time, sac story, time type object , KBA , LOD-SF-EC-REP , Reporting Data (EC core only) , LOD-SF-ANA-SAC-DAM , Data Modelling - Module & Entity Data Issues , Problem