SAP Knowledge Base Article - Preview

3455816 - Passing a date in Query level filter fails on refresh, Error:Low operand should be a single member. No member of <NAME> matches the query filter. (IES 00013)

Symptom

When a date range is provided in webi prompt with value which does not exist, below errors observed while refreshing :

  1. 'Low operand should be a single member. No member of 'CC_Transaction_Date' matches the query filter. (IES 00013)' 
  2. Query script generation failed. See your administrator. Index: 0, Size: 0 
  3. 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 
  4. “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.