If you are unable to create a new account, please email support@bspsoftware.com

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

using AS_OF_TIMESTAMP

Started by phoenixfire, 19 Aug 2008 06:57:46 PM

Previous topic - Next topic

phoenixfire

Hello everyone,
I have two crosstabs in my report. (as two different queries). one of them runs based on a date prompt for 2008 and the other runs based on a built-in filter for 2007. The report runs fine but I need an extra feature.
The crosstab which runs for 2007 has to be restricted to run for before Jan 2008. For eg, the query runs for Jan1 2007 to Dec 31 2007. Currently it runs as of today. The data has been modified a lot since January 2008. So when I run the query, it runs with all the changes. Is there anyway I can manipulate the query using a flashback function or something so that the query gives out data as of Jan 31 2008?
That way all the changes will not be visible.


Thanks a lot in advance...Will appreciate any help...