Cognos Analytics

Expand all | Collapse all

Bursting report with cognos

  • 1.  Bursting report with cognos

    Posted Fri March 15, 2019 12:00 PM
    Hi
    I have tried to use bursting feature but it doesn't seem to work as expected
    here is what i do:

    1) create the report in cognos analytics 11, set bursting features
    2) create agent in event studio for scheduling and send out emails to dynamic emails. i use event studio because analytics 11 doesn't allow dynamic subject in bursting emails.

    what i expected to see is each 3 user should receive a mail with dynamic subset of data attached, but the result is, each of them received 3 attachments in one mail.


    ------------------------------
    ella ye
    ------------------------------


  • 2.  RE: Bursting report with cognos

    Posted Mon March 18, 2019 12:08 PM

    Hello Ella,

    It's been a while since I setup bursting and emailing in Event Studio. Give me a bit of time to test this and I will get back to you later this week.



    ------------------------------
    DENNY NAREZNY
    ------------------------------



  • 3.  RE: Bursting report with cognos

    Posted Wed March 20, 2019 08:33 PM
    Thank you I appreciate that.
    Our project is going live this week, this issue has been pending for 1 month so its a bit frustrating.


    ------------------------------
    ella ye
    ------------------------------



  • 4.  RE: Bursting report with cognos

    Posted Wed March 20, 2019 08:46 PM
    I just found something new. For example , if our burst key is country, and
    if the report recipient mapping relation is 1) China -> Person A  2) Japan -> Person B, 3) US -> Person C,
    There is no issue. Each of them receives a mail with one report.

    However, if the report and recipient   is 1) China -> Person A  2) Japan -> Person A & B, 3) US -> Person C
    Then Person A will receive 2 mails, each has 2 reports, which doesn't make sense.







    ------------------------------
    ella ye
    ------------------------------



  • 5.  RE: Bursting report with cognos

    Posted Thu March 21, 2019 07:23 AM

    Good Morning Ella,
    Thank you for posting your additional findings. After doing a bit of investigation on my end, there is already an RFE (Request Functional Enhancement) logged requesting this functionality.  I would suggest getting your team to vote on it. (I voted on it as well)

    I will also reach out to our team internally to see if there is any other way to workaround this.

    Link to RFE - https://ibmanalytics.ideas.aha.io/ideas/CAOP-I-2025



    ------------------------------
    DENNY NAREZNY
    ------------------------------



  • 6.  RE: Bursting report with cognos

    Posted Thu March 21, 2019 04:52 PM
    hi Denny,

    Thanks! I have voted on the RFE. looks like same issue/limitation was created last year and is still outstanding?
    Please let me know what workaround we can have at the moment.

    Also if we give up on event studio and just use cognos 11 to burst the reports,  is there a way to set email subject dynamic? if yes, that will meet our needs too. (Looks like there is also a limitation to achieve that https://ibmanalytics.ideas.aha.io/ideas/CAOP-I-29)

    Ella

    ------------------------------
    ella ye
    ------------------------------



  • 7.  RE: Bursting report with cognos

    Posted Sun March 24, 2019 09:00 AM
    Hi Denny,
    Have you found the workaround for this ?

    ------------------------------
    ella ye
    ------------------------------



  • 8.  RE: Bursting report with cognos

    Posted Mon March 25, 2019 08:52 AM
    Edited by DENNY NAREZNY Mon March 25, 2019 08:52 AM

    Good Morning Ella,

    With the out of the box functionality, it does not look possible to have Event Studio burst one report per email when they burst recipient is tied to multiple burst keys.

    I'm checking down one more avenue and will get back to you shortly.

    Thanks,

    Denny



    ------------------------------
    DENNY NAREZNY
    ------------------------------



  • 9.  RE: Bursting report with cognos

    Posted Mon March 25, 2019 12:38 PM
    Hello Ella,
    The only way I can think of getting this to work would be to concatenate the burst key. This way the user would get one email with all the attachments and the Subject line would have a concatenated string for the burst key. Would this be acceptable? If so, what database vendor are you using? and is the package CQM or DQM?

    ------------------------------
    DENNY NAREZNY
    ------------------------------



  • 10.  RE: Bursting report with cognos

    Posted Mon March 25, 2019 12:51 PM
    Hi Denny

    we dont want user to get one email for all the report, because for each report we have 1) email body that has some summery of each report data 2) PDF.

    What we want is, just one email for one report.

    eg, if:

    1) Report 1 is for user A,B,C
    2) Report 2 is for user B, C,D

    We want 2 emails in total. One for report 1 and another for report 2.
    Currently we see 2 emails but in both emails we see both reports, maybe its because user B and C are the recipients for both reports so systerm get confused.


    Ella

    ------------------------------
    ella ye
    ------------------------------



  • 11.  RE: Bursting report with cognos

    Posted Mon March 25, 2019 01:30 PM
    Hello Ella,
    Thanks for the update. That is current product design. I would suggest voting on the RFE - https://ibmanalytics.ideas.aha.io/ideas/CAOP-I-2025

    ------------------------------
    DENNY NAREZNY
    ------------------------------



  • 12.  RE: Bursting report with cognos

    Posted Mon March 25, 2019 04:04 PM
    I have voted already last week as suggested, and i think we were looking for a workaround before the design is changed.

    ------------------------------
    ella ye
    ------------------------------



  • 13.  RE: Bursting report with cognos

    Posted Tue March 26, 2019 09:57 PM
    Hi Denny 
    i heard cognos 11 or event studio allows u to write your own script 
    i wnat to see if I can use script to do burst
    how can I acces to script mode? Don't see an option on UI

    ------------------------------
    ella ye
    ------------------------------



  • 14.  RE: Bursting report with cognos

    Posted Tue March 26, 2019 10:08 PM

    Hello Ella,

    I'm not familiar with any Script Mode for Event Studio. There is the Cognos SDK if that is what you are referring to?



    ------------------------------
    DENNY NAREZNY
    ------------------------------



  • 15.  RE: Bursting report with cognos

    Posted Tue March 26, 2019 10:21 PM
    Not sure about SDK. 
    How to access it?

    发自我的 iPhone





  • 16.  RE: Bursting report with cognos

    Posted Wed March 27, 2019 11:54 AM
    I saw people use code in some articles like this
    https://community.ibm.com/community/user/businessanalytics/blogs/steven-macko/2018/05/08/ibm-cognos-analytics-11-javascript-what-is-the-difference-between-a-custom-control-and-a-page-module

    Not sure if this can be used to change the subject dynamic in cognos 11 though.

    ------------------------------
    ella ye
    ------------------------------



  • 17.  RE: Bursting report with cognos

    Posted Wed March 27, 2019 12:32 PM

    Hello Ella,

    Javascript controls are used for Authoring and not Event Studio.

    If you are interested in exploring the Cognos SDK and you think it will meet your business requirement, I would suggest viewing the link below and explore the different offerings available:
    https://www.ibm.com/analytics/us/en/services/cloud-expert-services.html



    ------------------------------
    DENNY NAREZNY
    ------------------------------



  • 18.  RE: Bursting report with cognos

    Posted Sun May 24, 2020 05:45 PM
    Hello all,

    Is there any way to simple way of resolve the Dynamic subject line change in Email Bursting.

    1. Not using Cognos SDK and Java scripts, as well as Cognos configuration and admin level changes using vb script code.
    2. Is Event studio is supported - If yes - can any one provide me the steps and links please
    3. Any other alternative work around - recommended.

    Thank you
    -----------
    ID

    ------------------------------
    Indraneel Debbata
    ------------------------------



  • 19.  RE: Bursting report with cognos

    Posted Sun May 24, 2020 07:42 PM
    Yes event studio can handle this.
    Let me send you screenshots and steps when I'm in office Monday

    发自我的iPhone





  • 20.  RE: Bursting report with cognos

    Posted Wed May 27, 2020 10:42 AM
    Hello Ella,

    Thank you for the reply. Hope you are doing good.

    Just want to check with - you are sending the Event studio screenshot steps doc.

    Thanks
    Indraneel

    ------------------------------
    Indraneel Debbata
    ------------------------------



  • 21.  RE: Bursting report with cognos

    Posted Wed May 27, 2020 01:54 PM
    1. Set up burst options in cognos.
    how many queries do u have in the report ? If more than one you also have to set master child relationship between queries otherwise your report won't show all data 





    ------------------------------
    ella ye
    ------------------------------



  • 22.  RE: Bursting report with cognos

    Posted Wed May 27, 2020 02:15 PM
    Edited by ella ye Wed May 27, 2020 02:17 PM
    2. set up burst email in event studio. Open in IE only.
    i have 4 tasks below:
    set condition -> generate pdf  And html Format ( ken for attachment and the other for email body) -> send email

    step 2 and 3 are same except for format.


    ------------------------------
    ella ye
    ------------------------------



  • 23.  RE: Bursting report with cognos

    Posted 8 days ago
    I still couldn't find a appropriate solution to include a data item that will show in Subject line ..
    I am not sure why 'Label' data item is not appearing in Report email subject line?
    Using Event Studio with Report bursting is not staright forward, Can you please shed some light on ?

    Thank you!.

    ------------------------------
    Rohin Vangala
    ------------------------------