The text fields like 'Opportunity, Activity' shows only UUID's in BW system when exposed from Cloud system but the description cannot be found in BW system.
- SAP Cloud for Customer
- SAP Business byDesign
Reproducing the Issue
- Go to the Business Analytics work center.
- Go to Design Data Sources.
- Preview any data source which is exposed (E.g: Opportunity Header and Item).
- The Opportunity field shows description of Opportunity ID in Cloud for Customer.
However, when these fields are passed to BW, we can only see field UUIDs but not their corresponding description or text.
We get the description of these UUID fields from the corresponding Master Data source with which it is referenced and show it in the UI.
If you enable text and ID from Settings> characteristics in report for these fields you can see UUID's along with its description. However, when you expose it to BW system since the reference Master Data will not be exposed it will show only the UUID's which is expected behavior.
In such cases for example, Opportunity Header and Item stores 'Opportunity UUIDs' in Opportunity field, which act as foreign keys. Using these keys, you need to find out the corresponding IDs & Descriptions from the Master Data data source(Opportunity Header in this case) and show them in their reports in BW.
Since the master data source is responsible for fetching the descriptions for these UUID's you need to expose the referenced Master Data in this case'Opportunity Header' and for this you can see the text for UUID field with field name Doc_name for Opportunity. Later, you need to map internally these texts and UUID's in your transactional data source in your BW system.
Note: You can find the reference Master data source from the data source documentation under Design Datasources.
BW, odp, extraction, descripton missing, text missing, uuid, wrong entries, data source, business analytics , KBA , AP-RC-ANA , C4C, ByD, Travel: Analytics Tools & Frameworks , How To