You are running a report on Tickets using the Table view and you notice there are Duplicate Ticket Categories when the Counter Key Figure is added
SAP Cloud For Customer
Reproducing the Issue
- Go to Business Analytics
- Go to Design Reports
- Search for the report SEODSRQDTS01_Q0001 as an exmaple
- Add the fields Ticket Category I, II or III to the view
- Add the Key Figure "Counter"
- You will now notice multiple rows and counters for the same Category
The reason you are seeing separate counters is because the Category ID has been reused in multiple catalogs across multiple different versions.
Please add the version column to the report and you will notice that though the catalog IDs are same, the versions will be different and hence the counter value will show multiple rows. You can find the version within add fields and it comes from the "Ticket" data source.
SEODSRQDTS01_Q0001, category, catagory, catagories, ticket, SEODSRQDTS01, Ticket Time Points and Contact Party , KBA , AP-RC-ANA , C4C, ByD, Travel: Analytics Tools & Frameworks , Problem