3689654 - Fields defined with the data type 'Generic Object' in Time related objects are displayed as numerical values in Story Reports.

When a user selects the Time Type field (from the Employee Time object) or the Time Account Type field (from the Time Account object), the output displays numerical values instead of labels.

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

• Data Modelling - Module & Entity Data Issues

1. Navigate to the Report Centre.
2. Create a new Story report.
3. Select "Time Type" field from Employee Time object.
4. Click on Preview Query.
5. Numerical values are displayed in output instead of Labels

Usually when you have an entity in Query Designer and this entity has a navigation to another entity, you add autojoin fields to have them available directly in the entity and you don't have to add a navigation to this object, if you only need the autojoin fields:

In Time related objects these auto join fields are missing

Resulting in Numerical values in output

Join Employee Time with Time Type object and select the External Name field. 

Once the field is chosen, update its semantic type from Measure to Dimension.

Time Type is used here as an example, but the same approach should be applied to any field defined as a Generic object within Time related objects. 

• Refer to: 3245500 - Semantic Type for Name fields in Foundation Objects by default showing as Measure.
• Refer to: Picklist ID and Number in People Analytics.
• Refer to: 3479296 - Label field displays ID/numerical value/blank data instead of label in Story report.

story report, time management schema, numerical values, external names, sub-object fields, employee time, time type, measure to dimension, ID instead of label, auto join, object, Time, Time account type, Labels, Generic object, Codes , KBA , LOD-SF-ANA-SAC-DAM , Data Modelling - Module & Entity Data Issues , Problem