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
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.
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