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

Disabling All Scheduled Reports

Started by gatorfe, 01 Feb 2011 10:00:46 AM

Previous topic - Next topic

gatorfe

Hello! I was wondering if I could get some feeback.  We currently download data from an ERP system on a nightly basis into our Cognos DW.  Sometimes the refresh has issues that cause a delay in the data being avaliable to the users when they get to work.  Most of the users have scheduled reports that run before they get to work though.  I wanted to set some type of check in place so if the refresh is not done by X hour all schedules would be disabled.  Then once the refresh is complete the schedules would be enabled again.  Thank you in advance for any insight!

RobsWalker68

Hi,

There isn't really an easy way without using the SDK  I would imagine to disable scheduled reports. 

Perhaps you could handle it differently by setting up a job or series of jobs that are scheduled to run the reports and use the 'by trigger' to determine the frequency.  Have your load process then call the cognos trigger.

Regards

Rob

jive

Hi,
you could also set a table to get with one column and one line telling if the loading it's finish  or complete normally. We used that technique here and it's work very well for us.

Regards Jacques