#CognosAnalyticswithWatson

Hi,
This sounds like something which Event Studio can manage for you. Event Studio agents are data driven and will generate an event list (a query result list) which can pass single data items as a prompt parameter to reports like a drill through, but in a batch process. Event Studio is using FM packages.

Cheers
Kai

------------------------------
Kai Zeller
------------------------------

Original Message:
Sent: Tue December 06, 2022 01:38 PM
From: moises suarez
Subject: Schedule multiple reports as a batch process

Hi 

I have a scenario where I would like to run multiple Bi Reports in a batch process.  Some of these reports have prompts in common and some have unique prompts.  The reports are not set up as different report pages in one report, they are separate unique reports.   Is there a way where I could set up something like a "master report" with all required prompts and then call each report and pass the parameters collected on the "master report"? I've looked into the option of creating a Job and add each report as a step, however, I could not get prompt parameters to prompt upon running the job.   Thanks for your input/comments in advance.

Thanks

Moises

#CognosAnalyticswithWatson

Original Message:
Sent: 12/7/2022 10:11:00 AM
From: Kai Zeller
Subject: RE: Schedule multiple reports as a batch process

Hi,
This sounds like something which Event Studio can manage for you. Event Studio agents are data driven and will generate an event list (a query result list) which can pass single data items as a prompt parameter to reports like a drill through, but in a batch process. Event Studio is using FM packages.

Cheers
Kai

------------------------------
Kai Zeller
------------------------------

Original Message:
Sent: Tue December 06, 2022 01:38 PM
From: moises suarez
Subject: Schedule multiple reports as a batch process

Hi 

I have a scenario where I would like to run multiple Bi Reports in a batch process.  Some of these reports have prompts in common and some have unique prompts.  The reports are not set up as different report pages in one report, they are separate unique reports.   Is there a way where I could set up something like a "master report" with all required prompts and then call each report and pass the parameters collected on the "master report"? I've looked into the option of creating a Job and add each report as a step, however, I could not get prompt parameters to prompt upon running the job.   Thanks for your input/comments in advance.

Thanks

Moises

#CognosAnalyticswithWatson

Hi Moises,

Most of the time, you will execute the jobs during the night so it is pointless to have prompts. I guess you should provide some default values and save them before you can execute your job.

You can use URL to run reports and pass parameters through this URL. It might be helpful.

Best regards,

------------------------------
Patrick Neveu
Positive Thinking Company
------------------------------

Original Message:
Sent: Tue December 06, 2022 01:38 PM
From: moises suarez
Subject: Schedule multiple reports as a batch process

Hi 

I have a scenario where I would like to run multiple Bi Reports in a batch process.  Some of these reports have prompts in common and some have unique prompts.  The reports are not set up as different report pages in one report, they are separate unique reports.   Is there a way where I could set up something like a "master report" with all required prompts and then call each report and pass the parameters collected on the "master report"? I've looked into the option of creating a Job and add each report as a step, however, I could not get prompt parameters to prompt upon running the job.   Thanks for your input/comments in advance.

Thanks

Moises

#CognosAnalyticswithWatson

Hi @moises suarez,

You can find example in the documentation:
Creating custom URLs to display and run Cognos Analytics content

Best regards,
​

------------------------------
Patrick Neveu
Positive Thinking Company
------------------------------

Original Message:
Sent: Thu December 08, 2022 03:21 AM
From: Patrick Neveu
Subject: Schedule multiple reports as a batch process

Hi Moises,

Most of the time, you will execute the jobs during the night so it is pointless to have prompts. I guess you should provide some default values and save them before you can execute your job.

You can use URL to run reports and pass parameters through this URL. It might be helpful.

Best regards,

------------------------------
Patrick Neveu
Positive Thinking Company

Original Message:
Sent: Tue December 06, 2022 01:38 PM
From: moises suarez
Subject: Schedule multiple reports as a batch process

Hi 

I have a scenario where I would like to run multiple Bi Reports in a batch process.  Some of these reports have prompts in common and some have unique prompts.  The reports are not set up as different report pages in one report, they are separate unique reports.   Is there a way where I could set up something like a "master report" with all required prompts and then call each report and pass the parameters collected on the "master report"? I've looked into the option of creating a Job and add each report as a step, however, I could not get prompt parameters to prompt upon running the job.   Thanks for your input/comments in advance.

Thanks

Moises

#CognosAnalyticswithWatson

Hi, We use a kind of master report to group similar reports. In fact it's more or less a report with only a table including a collection of drillthroughs to the single reports and some standard filters for all of the single reports. The single reports use a layout component reference to this table of the master report (where some of its single components even can be overwritten). Queries to populate the filters must be present in all of the reports including the master report. The prompts themselves are only defined in the master report, so it's secured that they're all the same. In the master report you can then work with default selections. Maybe that approach could be helpful for your case, too. Regards, Philipp

------------------------------
Philipp Hornung
Business Intelligence Manager
Techniker Krankenkasse
Hamburg
------------------------------

Original Message:
Sent: Tue December 06, 2022 01:38 PM
From: moises suarez
Subject: Schedule multiple reports as a batch process

Hi 

I have a scenario where I would like to run multiple Bi Reports in a batch process.  Some of these reports have prompts in common and some have unique prompts.  The reports are not set up as different report pages in one report, they are separate unique reports.   Is there a way where I could set up something like a "master report" with all required prompts and then call each report and pass the parameters collected on the "master report"? I've looked into the option of creating a Job and add each report as a step, however, I could not get prompt parameters to prompt upon running the job.   Thanks for your input/comments in advance.

Thanks

Moises

#CognosAnalyticswithWatson