Cognos Analytics

Cognos Analytics

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

 View Only

  • 1.  Distributing report based on parameter

    Posted Tue October 06, 2020 03:54 PM
    Hi
    I have a question that is probably rather beginner level.
    We have 4 scheduled reports that are the same except for the region parameter. The 4 reports are scheduled to be sent to different group of users that work in that region.
    When I need to make a change to the report I have to do it 4 times.
    The list of users are manually added to the schedule details

    Any way to do this more elegantly?
    Thanks for your help.

    ------------------------------
    Balazs
    ------------------------------

    #CognosAnalyticswithWatson


  • 2.  RE: Distributing report based on parameter

    Posted Tue October 06, 2020 08:33 PM
    I think it should be the same question as I post just now, I got @Dariusz Danielewski​ 's feedback, burst report might be help.

    My post: https://community.ibm.com/community/user/businessanalytics/communities/community-home/digestviewer/viewthread?GroupId=3061&MessageKey=4df1083d-7304-4b2b-9d22-b521309f6e2f&CommunityKey=6b10df83-0b3c-4f92-8b1f-1fd80d0e7e58&tab=digestviewer&ReturnUrl=%2fcommunity%2fuser%2fbusinessanalytics%2fcommunities%2fcommunity-home%2fdigestviewer%3fcommunitykey%3d6b10df83-0b3c-4f92-8b1f-1fd80d0e7e58%26tab%3ddigestviewer

    ------------------------------
    Tom Z
    ------------------------------

    Original Message


  • 3.  RE: Distributing report based on parameter

    Posted Tue October 06, 2020 09:04 PM
    • You can create report views and schedule for each region and maintain email list. 
    • Other way is to add same report in a Job with different Parameters and email lists. 


    ------------------------------
    Buddhi Gupta
    ------------------------------

    Original Message


  • 4.  RE: Distributing report based on parameter

    Posted Wed October 07, 2020 02:21 AM
    Hi Balazs,

    We had the same requirement and solved it with Cognos Event Studio. I use a standard report and can use Event Studio to set the execution parameters and target group distribution. So I can use a report for 'N' use cases.

    The prerequisite is that you have a trigger that ensures that the reports are executed. That can be tricky.

    I hope that this will help you.

    Regards Peter


    ------------------------------
    Peter Hess
    ------------------------------

    Original Message


  • 5.  RE: Distributing report based on parameter

    Posted Thu October 08, 2020 10:31 AM
    Use burst report for each of the region and distribute to a Directory Group (a CAMID) or using email to a distribution group. This way you can control it directly in your LDAP/AD directory, eMail server, or Cognos itself.

    ------------------------------
    Dariusz Danielewski
    ------------------------------

    Original Message


Related Content