SAP Knowledge Base Article - Preview

3796292 - WebI report filter IsNull on merged queries returns rows with empty values

Symptom

When applying a report-level IsNull filter on a measure in a table built from two merged queries, Web Intelligence displays unexpected results: rows where the filtered measure is not null still appear in the table, but those values are shown as empty/blank.


Read more...

Environment

SAP BusinessObjects Business Intelligence platform 4.3

Product

SAP BusinessObjects Business Intelligence platform 4.3

Keywords

WebI, Web Intelligence, report filter, block filter, IsNull, merged queries, merged data providers, merge dimension, null filter, empty rows, incorrect result, unexpected rows, multi-query, filter evaluation , 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.