Symptom
Customer Consignment Report is giving incorrect data when adding fields from the Add fields
Environment
SAP Business ByDesign
Reproducing the Issue
- Goto Business Analytics Workcenter
- Design Reports
- Customer Consignment Report
- Filter on Outbound Delivery ID
- Add fields >try to add from reference Master data field, Eg: Outbound Delivery ID dimension >Serial ID
In case of multiple line item it results in repetitive data in the serial ID field
Cause
The display feature which will work fine in scenarios where there is single line item but in case of multiple line item it results in repetitive data as the report design is such that on the mapping.
Resolution
Currently, this is standard system behavior specially incase where the report design is complex and involves combining multiple data sources each containing multiple line of data.
However, you can try creating a custom data source joining the data source which has the serial ID so that it will be directly part of the report metadata and we need to add field via Add Fields and report created on top of this data source will list the serial ID correctly against Product and Outbound Delivery ID.
Keywords
KBA , AP-RC-ANA , C4C, ByD, Travel: Analytics Tools & Frameworks , Problem