Cognos Analytics

Cognos Analytics

Connect, learn, and share with thousands of IBM Cognos Analytics users! 


#Product
#Analytics
#CognosAnalytics
#Analyticstools
#TechXchange Partner
#TechXchange Session
#TechXchange Presenter
#AI
 View Only

  • 1.  Schedule multiple reports as a batch process

    Posted 12/06/22 01:38 PM
    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


  • 2.  RE: Schedule multiple reports as a batch process

    Posted 12/07/22 10:11 AM
    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
    ------------------------------



  • 3.  RE: Schedule multiple reports as a batch process

    Posted 12/08/22 05:05 PM
    Thanks for your suggestions/comments!

    Moises




    Original Message


  • 4.  RE: Schedule multiple reports as a batch process

    Posted 12/08/22 03:22 AM
    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
    ------------------------------



  • 5.  RE: Schedule multiple reports as a batch process

    Posted 12/09/22 04:00 AM
    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


  • 6.  RE: Schedule multiple reports as a batch process

    Posted 12/08/22 04:37 AM
    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
    ------------------------------



Related Content