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 table1.id=table2.id 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.

Join, Filter, ANSI92, Performance, push down , 1593922 , KBA , EIM-DF , Data Federator (use BI-BIP-DF) , Problem