Sub Report

[darners]

Hello everyone

First post on this forum and hope someone can help with a query I have

I have a requirement to filter on previous working day, I have created a query using running difference to give me the previous working day from our calendar table.

I want to use this to join to an existing query to give me the previous working date for each line

However when I try to join it is doing the running differnece calculation again

I have tried using 'Use Local Cache' but to no avail

Any help greatly appreciated

[anjidwh.cognos]

Hi Darren,

You can add a filter in existing QS say "datecolumn = _add_days(current_date, -1).

I hope it will help you!

Thanks
SRK

[darners]

Hi , thanks for the reply, but that wont work for working days

I have two queries.

1. Brings back all transactions for particular filter (this includes a transaction date)

2. Second query to calculate previous working day from a table

When I try to join them it is doing the calcualtion for previous working day again

My question is, how can I run the second query, then cache those results to be used to join to the first query, to give me previous working day for each transaction line

Thanks

[darners]

Any ideas ?

[BigChris]

Both queries will run each time you run the joined query. I think there are ways to cache some query results, but i'd stay away from those if possible...I've never been a fan! Surely the query to get the previous working day should be lightning fast - and arguably you should load that data into the calendar table for each date so that it's a simple read of the table...no calculation required.