SAP Knowledge Base Article - Public

3100438 - Concatenating two fields give a response of numbers instead of text in People Analytics - Analytics Cloud for Success Factors

Symptom

The following occurs when selecting Picklist Description fields in Calculated Column Designer, Calculated Columns do not display proper Description/Label of Picklist fields and always outputs the ID or code.  The regular fields display the proper label, but once used in a Calculated Column, the values are always shown in ID/Code regardless of whether you pick ID or Description field in the formula.

Environment

  • People Analytics - Analytics Cloud for SF
  • Calculated Column Designer

Reproducing the Issue

1. Login and go to Reporting
 2. In Report Center, search for the Story report.
 3. Notice that the query has a join from Job Information all through Country Specific Global Information - this is to test some picklist fields
 4. This is a simple query with Calculated Columns set to display fields Disablity from Canada and Chile Global Information as is (Description field was selected).  The last one is a Concat function.

5. Preview the Query
Result:  Notice that the Calculated Column fields display the values as ID or code rather than labels or descriptions
6. Go to Story Designer and add a simple table.  Add the regular Disability fields and the Calculated fields
Result:  Notice that the Calculated Column fields display the values as ID or code rather than labels or descriptions

Query Designer - Calculated Column screen
1. Go back to the Story datasource and edit query
2. Click the grid icon to check the Calculated Columns
3. Try to add a new calculated column and ensure that you pick Description instead of ID
4. Click OK
5. Preview the query
Result: The new calculated column still displays values in ID or Code instead of label description.

Cause

The id member will return a numeric response.

Resolution

You must pick the description member when using the concat method for values based upon a pick list and use the text value and not a field value.

See Also

Your feedback is important to help us improve our knowledge base.

Keywords

SAP Cloud for Planning, sc4p, c4p, cforp, cloudforplanning, Cloud for Analytics, Cloud4Analytics, CloudforAnalytics, Cloud 4 Planning, BOC, SAPBusinessObjectsCloud, BusinessObjectsCloud, BOBJcloud, BOCloud., SAC, SAP AC, Cloud-Analytics, CloudAnalytics, SAPCloudAnalytics,Error, Issue, System, Data, User, Unable, Access, Connection, Sac, Connector, Live, Acquisition, Up, Set, setup, Model, BW, Connect, Story, Tenant, Import, Failed, Using, Working, SAML, SSO, sapanalyticscloud, sap analytical cloud, sap analytical cloud, SAC, sap analyst cloud, connected, failure, stopped , KBA , LOD-SF-ANA-SAC , People Analytics (Analytics Cloud for SF) , Problem

Product

SAP Analytics Cloud 1.0 ; SAP SuccessFactors HXM Core 2105