Symptom
You created an extension field of type Multivalued List and added it to a basic data source, which is used in a combined or joined data source. Now you created a report on top of it but when you run it and want to show the field description it is not displayed in the report view. Instead you will see the code list or ID.
Environment
SAP Cloud for Customer
SAP Business ByDesign
Reproducing the Issue
-
Go to work center Business Analytics, view Design Reports.
- Show all and open report ABC (ABC stand for your custom report) based on data source CDE (CDE stands for a custom combined or joined data source).
- Run the report and add your multivalued list extension field to the report view.
- You will notice that it is displaying the ID but you are expecting to see the description.
Cause
This is the expected system behaviour. Extension fields of type multivalued list do not work on combined and joined data sources. It only works on the data sources in which the extension field was directly added.
Resolution
If you create the report on top of the basic data source it will successfully display the description or ID.
Keywords
multi code, multi code values, extension field, code values, combined data sources, joined data sources, code list, report shows ID , KBA , AP-RC-ANA , C4C, ByD, Travel: Analytics Tools & Frameworks , How To