Symptom
You run the standard report Leads by Status and notice that not all Leads are contained.
Environment
SAP Cloud for Customer
Reproducing the Issue
- Go the Analysis work center
- Go to the Reports view
- Find and open the report Leads by Status
The total number of leads shown in the report may be different from the total number of leads maintained in the Sales work center
Cause
There are two global restrictions applied to this report:
- 1) Leads without Lifecycle Status are not considered
- 2) Leads without Employee Responsible - Sales are not considered
If one of the above applies to a lead it will not be shown in the report.
Resolution
If you want to have a similar report without this restriction you can create a copy of the standard report and remove the global restrictions:
- Go to the Business Analytics work center
- Go to the Design Reports view
- Find the report Leads by Status (technical ID: CODMKLEAH_Q0003)
- Select New > Report as Copy
- In step 1 of the report wizard select a name of your choice for the new report
- Proceed to step 4 of the report wizard
- Find the two rows Lifecycle Status and Employee Responsible - Sales
- Switch the value selection from Fixed Value Selection to No Value Selection
- Finish the report wizard
Keywords
leads, Fixed Value Selection, life cycle, status , KBA , number of leads , leads by status , codmkleah_q0003 , AP-RC-ANA , C4C, ByD, Travel: Analytics Tools & Frameworks , How To