3563161 - Customer Consignment Report is giving incorrect data

Customer Consignment Report is giving incorrect data when adding fields from the Add fields

SAP Business ByDesign

1. Goto Business Analytics Workcenter
2. Design Reports
3. Customer Consignment Report
4. Filter on Outbound Delivery ID
5. 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

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.

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. 

KBA , AP-RC-ANA , C4C, ByD, Travel: Analytics Tools & Frameworks , Problem