Master Detail Relationship filtering

[LOUM]

Good Day everyone:

I have a List report which I have a couple queries pulling data togethers.

The main information is housed in Q1 which has a PO ID. I pull all my base information from this report. Q2 has my expiration date in it and I have a mater detail relationship built of the PO ID.

The report works great except for when I try and add a detail filter on my expiration date for in_range. It spins and spins and has not opened or doesn't seem to want to. If I run it in view tabular it opens in one minute but when the report runs it just spins.

This filter is optional.

I run other filters at the parent level and have no issues the report run efficiently and correctly. I am guessing it is because I am kinda back pulling from the child query first... Any ideas?

Thank you.
LOUM

[cschnu]

I think Cognos is forced to query the database for each row in the master list which means the total report execution time is equal to the number of rows in master list times child query execution time.

[LOUM]

CG:

Thank you for the response. I just figured out my issue, I had the filter at the child level query. Once I moved it to the parent level it functions correctly.

LOUM