Does Cognos apply filters before or after retrieving data?

[cognosdelaware]

I had a question about Cognos and filters.

Does Cognos pull back all the data from the database/table and then apply filters to the data OR are the filters applied at a database/table level and the filtered records returned to Cognos?

Thank you

[Naveen nani01]

Yeah

Sent from my Lenovo K50a40 using Tapatalk

[Naveen nani01]

By using aggregations on filters after or before aggregations we will filter the date by using some queries

Sent from my Lenovo K50a40 using Tapatalk

[MFGF]

I had a question about Cognos and filters.

Does Cognos pull back all the data from the database/table and then apply filters to the data OR are the filters applied at a database/table level and the filtered records returned to Cognos?

Thank you

Hi,

The answer is either of those might happen, depending how you are filtering and how the report is written. In most cases, the query engine can figure out how to take your filters and write a database query to include them, thereby getting the database to apply the filters and return a filtered result set. In some cases this isn't possible, though - for example if you are reporting over multiple data sources and you have a filter comparing a value from one data source with a value from the other. If you're unsure, take a look at the generated SQL (the Native SQL) and you should see if the appropriate predicate(s) is/are included.

Cheers!

MF.

[cognosdelaware]

My question was, if I have a filter on my data, does the filter get applied at the database level BEFORE the data is returned to Cognos OR does ALL the data come back from the database and then Cognos applys the filters?

[Lynn]

My question was, if I have a filter on my data, does the filter get applied at the database level BEFORE the data is returned to Cognos OR does ALL the data come back from the database and then Cognos applys the filters?

MFGF answered your question quite clearly I thought. Did you see that response?

[Invisi]

Perhaps you mean before or after the aggregation result? This is a parameter you can set for the filter. By default the filter is applied before aggregation, so like a regular where. So if you want to have the filter work on your result (after aggregation), you must change the parameter.