Symptom
-
A query level filter on Date/Date Time object with "Null" or "Empty_Value" or any other string passed as Constant string, throws below error on running the query
"A filter contains a wrong value. You cannot run this query. (Error: INF IES 00007)". - IsNull() and IsNotNull() options are not available in filter when a document is based on BW BICS
- The same error is seen from BI Launchpad as well as Webi Rich client.
- The same works for a Dimension with String value
Read more...
Environment
- SAP BusinessObjects Business Intelligence platform 4.x
- Web Intelligence
- OLAP BICS connection
- SAP BW
Product
SAP BusinessObjects Business Intelligence platform 4.2
Keywords
BICS, date prompt, IsNull, string, constant,query,filter , 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