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.
SAP Knowledge Base Article - Preview