Report combining results from different periods with date versioning

[timvw]

Hi,

I'm looking for a solution for the following problem... we have quite an atypic historical database with date versioning per table.
Each table contains a "valid from" and "valid till" field. For every query (and table) we need to use a filter to select the data we need because of the versioning (e.g. today will result in a where clause : today > valid from and today < valid till (9999-01-01)).

I have solved this by using a session parameter in Framework Manager and all my tables have this "where condition" using the session parameter.

So far so good when the report is about 1 specific moment in time.
However for some reports we need to compare 2 or more periods (e.g. today vs last month vs last year).

How can I run/setup a report that compares 2 periods e.g. run a report for 1 period and run it again for another period and compare the results ?

When creating multiple queries in Report Studio, they all use the same "session" parameter.

How can I solve this ? In other words: select date 1 as session parameter, run query/report, select 2 as session parameter, run query/report and then finally combine the results?

Thanks

[Lynn]

Can you change for Framework model to use a prompt macro?  That way each query against the model will prompt for the desired time period.

[timvw]

Hi,

I'm using indeed a prompt in my session parameter, so each query/table/report is filtered for a specific date. However this of course does not solve my problem where I need data from 2 different dates.

Any idea how to do this (without duplicating namespaces in framework manager and having another session parameter for that namespace) ?
Thanks