SAP Knowledge Base Article - Public

3537176 - UUID Fields Are Showing Incorrect Descriptions In The Stories

Symptom

You create a story on a standard data source and you see that there are a few UUID type fields like Account, Contact Etc that does not show the correct descriptions. Instead, they show an alphanumerical value that is not readable or understandable.

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

Environment

SAP Sales Cloud and SAP Service Cloud Version 2 

Reproducing the Issue

Let us consider the below example.

  1. Login to the system using SSO credentials.
  2. Navigate to User Settings.
  3. All Settings
  4. Analytics
  5. Design Stories.
  6. Create a story on Appointments Data Source. 
  7. Add the Column Account.
  8. Open the story.
  9. You will see the values in non-readable format in the Account Column. Sample screenshot provided below.

Cause

The related tables to which the UUID fields belong to are not linked to the data source.

The related tables need to be added to the data source.

The UUID fields must be selected from the related tables to see the right descriptions for the respective fields in the stories.

Resolution

Execution of following steps can add related tables.

  1. In the query designer, click on the data source.
  2. Choose Show Related tables.
  3. From the data sources listed, choose the appropriate related table.
  4. Click on Add Column and choose the required UUID field.
  5. Click on Finish.
  6. Now when you preview or open the story, you will see the descriptions shown as expected.

For the above example, You must link the Appointments data source to the related table like Account. Below is the screenshot for your reference.

image (22).png

Keywords

Account, Contact, UUID, Field Descriptions, Descriptions, Wrong Text, Incorrect Value, Missing, Fields, Design Stories, Related tables, Show Related Tables, Link Tables, UUID fields, Descriptive fields, Data Source  , KBA , CEC-CRM-ANA , Analytics for SAP Sales/Service Cloud , Problem

Product

SAP Sales Cloud and SAP Service Cloud Version 2 1.0