CODEWITHSUNDEEP
parameterspromptjobsschedulecognos
user3017849
user3017849

Reputation: 93

Cognos Scheduling Multiple Parameter job

I have to schedule a .CSV report to run everynight for each Organisation in my Organisation_Table, then save this report to a directory in my file system specific to the organisation.

There could be 100s of individual organisations though, is there any way to only make one schedule and loop the prompt screen to go through each organisation?

or will i need to create a schedule job for each organisation(possibly 100s) and give the prompt screen variables for each organisation?

thanks

Upvotes: 1

Views: 1527

Answers (1)

Damienknight
Damienknight

Reputation: 1896

You are going to need a query to pull a list of the organziations. You can use the list of organizations to setup Bursting, where the report will create seperate copies of itself for each iteration of a list.

File->Burst Options

Once you select a list of organizations to include in the burst, you will setup the burst query to feed its organization code (or name, unique id, whatever you are using to identify organizations in the database) into your main query. Each time it runs an organization in your burst, it will filter the main query to only include data for the current organization in the burst sequence.

Bursts can be done to email, or to the Hard Drive (save the reports).

Two guides that outline the basics of bursting in Cognos:

http://www.ironsidegroup.com/2014/07/15/creating-a-burst-table-for-a-cognos-report/ http://www.clickdwh.com/Pages/Author_Bursting_Report.aspx

Upvotes: 1

Related Questions