Bursting Reports in Cognos BI with Version 10 & 11

11/9/2016

Do you find yourself spending exorbitant amounts of time sending multiple reports to multiple people? Maybe you have a report that you have to manually slice to get to the right people? Do you want that time back to spend analyzing and providing real value to your organization? Bursting reports in Cognos BI may be a great time savings option for you!

Make Sure You Have a Burst Table or Fields Created

The first step in setting up bursting in either version 10 or 11, is to make sure that you have burst receipts available. You can do this by setting them up in a data warehouse table or through creating a calculated field that contains the info you need. You will need an email address, name and some sort of ID field that is used in your reports.

bursting reports in cognos bi

Now that we have the burst tables or fields created, it is time to build your report. Keep in mind that your report will need the data points for the burst table. In the example above, we are building a report based on product line code and the associated recipient. To save time, we will only build 1 report with all of the data that can be sliced on the product line code and distributed to the associated email address. With your report built, it is time set up bursting. Please check out the instructions below associated with the version of Cognos BI you are utilizing.

IBM Cognos Analytics 11 – Set up in Report

bursting reports in cognos bi

With the “Burst Options” open, you need to supply the query that contains the burst groups and the recipient. Identify the data item and the type of burst receipt. You will also need to drag the data item that represents the burst id to the group field. Lastly, if the report contains two nested data containers, you will need to set up the master detail relationship. You can find more data on master detail relationships at the IBM Knowledge Center site.

IBM Cognos Analytics 11 – Enable in Cognos

With the report set up to burst, we now need to enable bursting and set the output. Find the location of your saved report and click the more icon and then the “Run as” option.

bursting reports in cognos bi

Enable run in the background, choose the format of the report and then click into the advanced area. In this area, ensure that you have selected burst the report and then set the delivery method as seen below.

bursting reports in cognos bi

If you want to send by email, you can choose how it is delivered and write a message in the email body. You can also have the report printed or save it to a specific spot on the system. Now that you have set up bursting, you can schedule this to be automatically sent whenever you want. For more on scheduling BI reports, check out our blog HERE.  Furthermore, you can read more about bursting reports HERE.

IBM Cognos BI 10 – Set up in Report

Like in Cognos 11, you need to set the report up for bursting. Follow the above guidelines on building your report for bursting and then click file and burst options. With the burst options open, you need to supply the query that contains the burst groups and the recipient. Identify the data item and the type of burst receipt. You will also need to drag the data item that represents the burst id to the group field. Lastly, if the report contains two nested data containers, you will need to set up the master detail relationship. You can find more data on master detail relationships and bursting by visiting the IBM Knowledge Center.

IBM Cognos BI 10 – Enable in Cognos

From Cognos Connection, find your burst enabled report and click the more button. Next, click run with options. In the options area, select the format of report you want to burst and the type of delivery. In order to have the burst option you will need to choose something other than “view the report now”. Once selected, click on advanced options. You should be here:

bursting reports in cognos bi

The next step is to ensure you have the correct format of the report and will need to click the “burst the report” box. Next choose the deliver option(s) and then any options within that delivery type and you are all set to burst. To fully automate it, click on the schedule icon in Cognos connections and schedule your report to automatically run on the days and times you choose. You can read more about scheduling reports HERE.

By taking the time to build your reports correctly and use options like bursting, you can save numerous hours per week or per month. As a result, you will be utilizing that time to analyze data and provide more value to your organization.

And here's your call to action...

*If you are current on your IBM Cognos support, then you already own Cognos Analytics (Cognos 11), Release 4.  For more information on Cognos Analytics, check out last week’s blog HERE!

Should you be looking to upgrade or if you are considering adding Cognos Analytics to your organization, we highly suggest giving us a call so we can guide you through the processes needed. Feel free to contact us at Coaching@LodestarSolutions.com or call us at 813-254-2040.

10 thoughts on “Bursting Reports in Cognos BI with Version 10 & 11”

  1. Hi,
    I am currently bursting my report to all my stores for report data specific to each store. However, the problem that I am facing is in Distributing. All my stores are getting multiple emails each one containing the bursted reports for their stores and all other stores. How do I ensure that a store only receive the email containing their own report and do not receive the other stores. I am diligently following every step of bursting but still cannot stop all stores receiving others report.

    Reply
    • HI Anil.

      I have a quick question. Can we burst reports only if the report author defined burst options for the report?

      Thanks in advance.

      Reply
    • Bursting is taking 1 report and splitting it into multiple reports and sending it to people based on a field. For instance, cost center 1 goes to x, cost center 2 goes to y and so on. In this instance bursting needs to be enabled in the report options and the burst options need to be completed.

      Reply
  2. Is there a way the Bursted Report which is put into a file system be saved with the Productline code in the filename so that its easy to identify which file is for which Line code.
    We want to get it implemented in Cognos without macro or any server level setting changes.

    Reply
  3. Interesting article. Do you know if there a license requirement for the recipient of a bursted report or could it go to anyone?

    Many thanks

    Reply

Leave a Comment

X
Send this to a friend