Cognos Burst Reporting Capability

[tstagliano]

Has anyone utilized the Burst Reporting functionality within the Cognos suite?  Curious on how the BurstingID field was used in the 1000 employee import template  We are investigating setting this up so we can burst reports to all users so they can see specfic report information for themselves rather then our AP team manually running these reports and carving out the specifc user details to send

Thoughts?

tom

[Felix · Accepted solution]

Hello Tom,

Our company does not send reports to individual employee but we do use this burst feature for various purposes. Here is my steps to create a burst report:

1. You need to have the "Email" column in your query for this burst option to work.

2. In your report studio, find "file" - "busrt option" and set it up like the below image

3. Schedule the report to run daily (or you can run this report now for testing purposes)

When I created this report, I only use two employees (me and my colleague in the accounting team) for testing purposes.

Hope this helps!

Felix

[GrantC]

Hi Tom,

The good news is that as long as you're just sending an individual user's data to that user, you do not need to anything with the 1000 record import. As the previous commenter mentioned you just have to include the email field in the query and turn on bursting within the report.

The 1000 record import is only required if you want to turn on what we call custom bursting, which is where you're sending data related specific to a specific data object to a specific person. For example, if you want to send a list of all expenses allocated to Project X to Project Manager X, then you'd need to do the import.

Thanks,

[KFriedhoff]

When I add the Employee E-mail Address from the Bursting folder to my report, I receive the following error.  This is a report that shows cash reimbursements that will be paid out to the employees for the last 2 weeks. 

I am using Query Studio.  Can I burst reports?

Karen

Cross joins (between query subjects: [Report Tables].[Fct_Rpt], [Report Tables].[FCT_REPORT Payment Dim_Status_Lang], [Report Tables].[Dim_Rpt_Minutia], [Report Tables].[FCT_REPORT Processing Payment Dim_Date], [Report Tables].[FCT_REPORT Dim_Employee], [Report Tables].[FCT_REPORT Dim_Employee_Custom_Lang], [Reporting Hierarchy Bursting].[Rpt_Hier Dim_Employee]) are not permitted for the user who has the identity '*'.

Details CAF-WRN-2082 An error has occurred. Please contact your administrator. The complete error has been logged by CAF with SecureErrorID:2019-07-29-13:16:14.746-#829

[GrantC]

Hi Karen,

Two things here:

First, when doing bursting the way we have been discussing in this thread you would not pull in the email address from the Bursting folders, you'd bring it in from the same area you're pulling in the rest of your data for the report. In your case it would most likely be from Expense\Expense Reports\Report Header Information\Additional Employee Details\

Second, Report Studio is required to complete the bursting configuration, so unfortunately, if you only have access to Query Studio you cannot burst.

Thanks,

[J-Kap]

Hi All,

Could someone be kind enough to walk me through how to turn on custom bursting- where you're sending data to a specific person. I would like to send 2 custom reports to a specific person on a daily basis.

Many thanks