When reporting on data source Appointment Involved Parties, several lines with Not Assigned (#) values are displayed under Activity related columns, like "Activity Appointment", "Activity Type", and "Activity Category".
SAP Cloud for Customer
Reproducing the Issue
- Go to the Business Analytics work center.
- Go to the Design Data Sources work center view.
- Find and open data source Appointment Involved Parties [CODAPAPTYB] in "Preview" mode.
- Run the data source by adding the relevant characteristic fields.
- The Activity related columns, like "Activity Appointment", "Activity Type", and "Activity Category" are displaying several Not Assigned (#) records.
This is the expected behavior. The data source Appointment Involved Parties is designed to display the list of all the parties with or without appointments/activities.
To remove the Not Assigned entries, filters can be applied in the report selection for the relevant fields (for example, Activity Category) to remove the undesired Not Assigned entries, hence displaying only lines with Activities information.
Appointment Involved Parties; Data Source wrong; wrong values in data source; Not Assigned; , KBA , LOD-CRM-ACT , Activities , AP-RC-ANA , C4C, ByD, Travel: Analytics Tools & Frameworks , How To