Symptom
You entered a selection on characteristic Changed On in standard data source Registered Product (technical ID CRMREGPRODHB) or a custom report build on top of it and receive an error message.
Environment
SAP Cloud for Customer
Reproducing the Issue
-
Go to the work center Business Analytics and the view Design Data Sources.
- Search for standard data source Registered Product (technical ID CRMREGPRODHB) and click Preview.
- Enter a date in format DD/MM/YYYY in the selection area for characteristic Changed On.
- Click on Go.
- You will receive the error messages: "Value not valid for variable Changed On" and "Check your variable selections".
Cause
The characteristic Changed On (characteristic ID LAST_CHANGE_DATE_TIME) is a date/time field and you entered only a date as a variable selection.
Resolution
As the characteristic Changed On you need to enter a date and time plus the time zone. Please use the format like this DD/MM/YYYY hh/mm/ss UTC.
If you are not looking for a specific value you are also able to use is between and enter a date/time frame in the selection area.
Keywords
date/time field; date; time; selection; variable; characteristic; value not valid; selections; changed on; report; data source; CRMREGPRODHB; Check your variable selections , KBA , AP-RC-ANA , C4C, ByD, Travel: Analytics Tools & Frameworks , How To