3100438 - The calculated column returns numeric values instead of text when picklist fields are used.

Symptom

• When selecting Picklist fields in Calculated Column Designer, Calculated Columns do not display proper Description/Label of Picklist fields and always output the ID or code.

Environment

Story reports
Calculated Column Designer

Reproducing the Issue

Login into report
Create a new Story report
Create a calculated column like below and preview query in output we see numerical values
IF([Employment#Job Information#Employment Status]="Terminated","Inactive",[Employment#Job Information#Employment Status])

Cause

The id member returns a numeric response.

Resolution

Select the description member in calculated column for values based on a picklist.
IF([Employment#Job Information#Employment Status_Description]=
"Terminated","Inactive",[Employment#Job Information#Employment Status_Description])

Keywords

picklist, field, numerical, Code, value, Story, report, calculated column, Query, designer, data source , KBA , LOD-SF-ANA-SAC-QDS , Query Designer - Filter, Calculated Column, Params , LOD-SF-ANA-SAC-DAM , Data Modelling - Module & Entity Data Issues , Problem

Product

SAP SuccessFactors HCM Core all versions ; SAP SuccessFactors platform 2011