SAP Knowledge Base Article - Preview

1186518 - Filters in a Webi Report are not pushed down to data sources


If a webi report wirtten on top of a Data Federator virtual DB, contains joins and filters and generates a SQL statement in this form:

select * from table join table2 on and table2.year=2006 and table2.month=12

Data Federator does not push down the constraints table2.year=2006 and table2.month=12 when querying the datasource. Instead it will bring back the joined dataset and filter the records based on the date. In turn the report may be slow to refresh.



SAP Data Federator XI R2 ; SAP Data Federator XI R2 Accelerated


Join, Filter, ANSI92, Performance, push down , 1593922 , KBA , EIM-DF , Data Federator (use BI-BIP-DF) , 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.