Symptom
When a date range is provided in webi prompt with value which does not exist, below errors observed while refreshing :
- 'Low operand should be a single member. No member of 'CC_Transaction_Date' matches the query filter. (IES 00013)'
- Query script generation failed. See your administrator. Index: 0, Size: 0
- BW System returned state 'NO_DATA_AVAILABLE'. Message = Invalid member value for characteristic "Transaction_Date". Cannot parse "#EMPTY_SELECTION_STATE#" to data type "CALENDAR_DAY". All selections for characteristic Transaction_Date are invalid and have been discarded
- “No data to retrieve”
Read more...
Environment
- SAP BusinessObjects Business Intelligence Platform 4.x
- Web Intelligence
- SAP HANA cloud
Product
SAP BusinessObjects Business Intelligence platform 4.2 ; SAP BusinessObjects Business Intelligence platform 4.3
Keywords
Webi webintelligence OLAP HANA 4.x date range prompt 4.3 , KBA , BI-RA-WBI , Web Intelligence , Problem
About this page
This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).Search for additional results
Visit SAP Support Portal's SAP Notes and KBA Search.