Cognos Analytics

 View Only

  • 1.  Burst Reports sending to me as well as the recipient

    Posted Fri January 03, 2020 11:26 AM
    Reply
    Using CA 11.1.3
    I have created a simple report that bursts to employees using the CAMID.
    The emails are being sent correctly and the data in the report filtered correctly.

    My issue is that I am being added as another recipent to every single bursted version. So if I went live with it, would recieve 45 separate emails everytime the job runs.

    I have looked through a lot of options both in the new interface and the 'classic' view but cant seem to see why this is happening or how to stop it.

    Help!

    ------------------------------
    Jonathan berry
    ------------------------------

    #CognosAnalyticswithWatson


  • 2.  RE: Burst Reports sending to me as well as the recipient

    Posted Mon January 06, 2020 11:00 AM
    Reply

    Hi @Jonathan berry,


    Here is one possible reason why that may be happening. Normally, Report server will ignore email addresses specified as recipients in the schedule delivery options when bursting.

    If you check burst then go to email, you can't specify recipients. However if you go to email first and specify recipients then check burst, the recipients are kept.

    The reason this might be important is that there is an advanced server property RSVP.USE_EMAIL_TO_RECIPIENTS_ON_BURST that when set to true, the report server will merge the burst recipients with the delivery recipient options. ​Hence why those recipients might be getting all the emails.

    What I would recommend is going to your report schedule, unchecking Burst the report, going back to the email delivery option and seeing if there are any emails that are present in the recipient list there.



    ------------------------------
    MOHAMMED OMAR KHAN
    Offering Manager
    IBM Cognos Analytics
    ------------------------------

    Original Message


  • 3.  RE: Burst Reports sending to me as well as the recipient

    Posted Mon January 06, 2020 11:04 AM
    Reply
    Hi Jonathan. I will take a look into this.

    ------------------------------
    TREVOR COMEAU
    ------------------------------

    Original Message


  • 4.  RE: Burst Reports sending to me as well as the recipient

    Posted Mon January 06, 2020 11:51 AM
    Reply
    Hi Jonathan. I've reproduced this issue when using the CAMID. I will discuss this with development. 

    As an aside. Using the straight email address doesn't show this behavior unless I set the RSVP.USE_EMAIL_TO_RECIPIENTS_ON_BURST to True. Setting it to False make no difference in either scenario.

    ------------------------------
    TREVOR COMEAU
    ------------------------------

    Original Message


  • 5.  RE: Burst Reports sending to me as well as the recipient

    Posted Tue January 07, 2020 09:23 AM
    Reply
    Hello all,

    Thanks for your help. 
    Trevor I was using the CAMIDs as this is what I had experience with previously a long time ago with 10.2.

    I have managed to resolve the issue by adding an email address field to the users table in the data warehouse, then changing the burst settings to use this field rather than Directory entities/CAMID.

    This actually made the task easier as I didn't need to go through the process of getting Cognos user CAMIDs one by one from the Admin consol.

    I've included a screen shot of my report burst settings just in case anyone else has the same issue.




    ------------------------------
    Jonathan berry
    ------------------------------

    Original Message


  • 6.  RE: Burst Reports sending to me as well as the recipient

    Posted Tue January 07, 2020 09:50 AM
    Reply
    Thanks for the update, glad you have a viable work-around. I will continue to investigate the original issue with dev to get this fixed.

    ------------------------------
    TREVOR COMEAU
    ------------------------------

    Original Message


  • 7.  RE: Burst Reports sending to me as well as the recipient

    Posted Tue January 07, 2020 10:07 AM
    Reply
    Glad you were able accomplish what you needed Jonathan! Thanks for sharing your solution as well, it will likely help more people who might come across the same issue as you mentioned!

    ------------------------------
    MOHAMMED OMAR KHAN
    Offering Manager
    IBM Cognos Analytics
    ------------------------------

    Original Message


Related Content