COGNOiSe.com - The IBM Cognos Community

IBM Cognos Analytics Platform => Cognos Analytics => Reporting => Topic started by: am@rav.no on 24 Oct 2017 03:23:42 AM

Title: Refresh of dataset with av JOB ?
Post by: am@rav.no on 24 Oct 2017 03:23:42 AM
Hi, does anyone know if it is possible to refresh a DATASET with a JOB in Cognos Analytics ?

I plan to have several dataset and I dont want to manage the refresh Schedule by each dataset. I want to mange this with a job that starts the refresh of data. But I cant see how this can be done. Its not possible to pick up a dataset when I create a job.

Hope anyone can help me :-)

Regards
Atle
Title: Re: Refresh of dataset with av JOB ?
Post by: DaBaker on 13 Nov 2020 10:58:05 AM
This was asked a while ago but, has anyone found a solution for this yet?    Has Cognos been able to help with Refreshing of datasets? 
Does the data in the datasets get stale?
What is Cognos Analytics way to refresh the data currently?

Thanks!
Title: Re: Refresh of dataset with av JOB ?
Post by: adam_mc on 13 Nov 2020 11:22:23 AM
I am told the functionality of adding Data Set refreshes to a Job is incorporated in CA 11.1.7.
However, I have not confirmed this as we have not upgraded yet.

You can certainly add a schedule to a Data Set refresh.
This gives you the option for time dependent reloads.
For event dependent reloads, you can use the Trigger based scheduling functionality plus appropriate scripting to execute the defined trigger.

Hope this helps.
Thanks,
Adam.
Title: Re: Refresh of dataset with av JOB ?
Post by: MFGF on 16 Nov 2020 07:46:25 AM
Quote from: DaBaker on 13 Nov 2020 10:58:05 AM
This was asked a while ago but, has anyone found a solution for this yet?    Has Cognos been able to help with Refreshing of datasets? 
Does the data in the datasets get stale?
What is Cognos Analytics way to refresh the data currently?

Thanks!

Hi D,

You can either create a schedule for refreshing a data set in isolation, or in 11.1.7 you can add refreshing a data set as a step in a Job.

Cheers!

M.