Symptom
When we filter using a particular department ID in selection, we are getting the error message: "Value not valid for variable Department ID; Check your variable selections"
Environment
SAP Cloud for Customer
Reproducing the Issue
- Go to Business Analytics work center.
- Navigate to Design Reports.
- Open the report.
- In the selection, set the filter with a particular Department ID.
- Run the report.
- An error message is shown "Value not valid for variable Department ID; Check your variable selections" .
Cause
No employees are maintained in the selected department at the time of execution.
Resolution
- Maintain the employee data for the department (for example, assign at least one employee to the department).
- Run the report with the Department ID filter.
- The report shows the expected data.
Keywords
report filter, department id, value not valid for variable, variable not valid, business analytics, custom report, selection filter, no data available, error message,report variable, department selection , KBA , AP-RC-ANA , C4C, ByD, Travel: Analytics Tools & Frameworks , Problem
Product
SAP Cloud for Customer core applications 1.0
SAP Knowledge Base Article - Public