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.
Reproducing the Issue
Steps to reproduce:
1. Goto Business Analytics Work Center
2. Design Data sources
3. Any data source which is exposed (Eg: Opportunity Header and Item)
4. The Opportuntiy field shows description of Opportunity ID in Cloud for Customer
However, when these fields are passed to BW we can only see field UUID's but not there 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, Opportuntiy Header and Item stores 'Opportunity UUIDs' in Opportuntiy 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'Opportuntiy 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.
KBA , AP-RC-ANA , C4C, ByD, Travel: Analytics Tools & Frameworks , How To