Symptom
You have created a story in Embedded SAC system based on Opportunity Item data source.
And notice that field Product Category shows only ID rather then Description and ID
Environment
Cloud for Customer
Embedded SAC System
Reproducing the Issue
- Login to Embedded SAC System
- Design Stories
- Open the story based on Opportunity Item data source.
- Add field Product Category and make it visible as "Description and ID"
- Only ID's are visible rather then both
Cause
Product Category : is a UUID field.
The values in the data source CODOPPIB for field "Product category", non of the UUID's match with the "Product category" of master data datasource PROD_CATG, hence no description can be derived.
Resolution
Product Category ID : is a ID field
The values in the data source CODOPPIB for field "Product category ID", only few of the ID's match with the "Product category ID" of master data datasource PROD_CATG, hence only few description can be derived. The descriptions can be seen only when the fields from "Product category ID" of CODOPPIB is selected.
Keywords
KBA , embedded sac , opportunity item data source , codoppib , product category id , product category , AP-RC-ANA , C4C, ByD, Travel: Analytics Tools & Frameworks , AP-RC-ANA-SAC , C4C, ByD: SAC Integration , How To