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
- 2569847 - Where can you find SAC user assistance (help) to use, configure, and operate it more effectively?
- Have a question? Ask it here and let our amazing SAP community help! Or reply and share your knowledge!
- 2487011 - What information do I need to provide when opening an case for SAP Analytics Cloud?
- 2511489 - Troubleshooting performance issues in SAP Analytics Cloud
- Search for SAP Analytics Cloud content using Google or Bing:
- https://www.google.ca/search?q=site%3Ahttps%3A%2F%2Fapps.support.sap.com+SAP+Analytics+Cloud
- https://www.bing.com/search?q=site%3Ahttps%3A%2F%2Fapps.support.sap.com+SAP+Analytics+Cloud
- Note: Add relevant text or warning/error messages to the text search field to filter results.
- SAP Analytics Cloud Connection Guide
- Getting Started with SAP Analytics Cloud Expert Community page
- SAP Analytics Cloud Get More Help and SAP Support
- Need More Help? Contact Support or visit the solution finder today!
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 , Stories in People Analytics , Problem