You are using a report based on a custom Data Source which uses the 'Opportunity Header and Item' Standard Data Source. When you add, for example, characteristics like 'Product' in the Rows, you notice that the actual value is displayed, however, an extra line showing 'Not Assigned' is also displayed in the report view.
SAP Hybris Cloud for Customer
The root cause for the extra line displaying 'Not Assigned' is due to the Data Source 'Opportunity Header and Item' which is being used. This Data Source is originally a combination between the Data Sources 'Opportunity Item' and 'Opportunity Header', which are also standard Data Sources.
When the characteristic 'Product' is added in the report, the extra line shows up because the products displayed are only available in the 'Opportunity Item' Data Source, and since you are using the 'Opportunity Header and Item', it also retrieves the 'Not Assigned' value from the 'Opportunity Header' Data Source, since by standard, there are no products values being maintained in this specific Data Source.
In order to correct your report's behavior, you may follow the approach below:
Create a Left Outer Join Data Source between the 'Opportunity Item' and 'Opportunity Header' Data Source.
- Select the 'Opportunity Item' as the anchor Data Source.
- Use simple join conditions like 'Account' and 'Opportunity', depending on your business requirement.
- Also notice that you don't have to select all the characteristics from the 'Opportunity Header' Data Source, since both have the same characteristics, just ensure to have to proper join conditions.
After creating the Data Source mentioned above, you may remove the 'Opportunity Header and Item' Standard Data Source from your original Join and use the Custom Data Source you just created, this will ensure that the extra line is not displayed in the report.
Not Assigned; Report; Analytics; Data Source; Product; Opportunity Header and Item; , KBA , AP-RC-ANA , C4C, ByD, Travel: Analytics Tools & Frameworks , How To