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

Refresh Cache on Report View Jobs

Started by Starfish2201, 07 Aug 2013 03:43:49 PM

Previous topic - Next topic

Starfish2201

Hi Gurus,

Due to huge data volume, we are using 2 UIDs as parameter Value in our report filter.In our Database, the UIDs get refreshed daily. Due to this, I need to clear the report cache everyday before the scheduled report runs so that the parameter value gets replaced by latest value from database.

Users have created report views and they run the views by scheduling job. Users do not want to create a report cache job to clear the cache. My question is, if I create a report cache job for that report and schedule it to run before the "report view jobs" run, would it also clear the cache from the "report views"? Or it just works only for the "report jobs" and not "report views"?

Please throw some light on this. Thanks in advance for your help and guidance !!!

Starfish2201

Any help is really appreciated. Thanks