Cognos what is bursting

No Account? Sign up. By signing in, you agree to our Terms of Use and Privacy Policy. Already have an account? Sign in. By signing up, you agree to our Terms of Use and Privacy Policy. Enter the email address associated with your account. We'll send a magic link to your inbox. Email Address. All Sign in options. Enter a Email Address. Choose your interests Get the latest news, expert insights and market research, sent straight to your inbox. Newsletter Topics Select minimum 1 topic.

Big Data. TedCole Posted January 20, 0 Comments. Ted, if I run without burst for one store it takes less then 10 minutes. TedCole Posted January 21, 0 Comments. Yes, it goes to the last page. Any Suggestions? Definitely 'Report View' is inefficient as numbers will grow and people keep on changing. Right now i wish to know from server resource consumption point of view , which is expensive? Bursting or Scheduling? Good Evening MF, thanks for reply, yes, you are right i was of interested which one is efficient.

Cheers, Vinu. If you want to attach more than one different report to an email then you can use event studio. Figure Adding a second report task in Event Studio as a precursor to making it a second attachment to the burst email.

Figure The result of reordering the tasks. This is the final stage in setting up this Event Studio instance. Sometimes burst reports can be empty if there are no figures to display. If this is a report to highlight exceptions then it can be tedious for the recipient to get an empty report most days. It can be more effective to send the report out only when data appears. See attached report example. Bursting only where there are figures doc.

The attached report achieves this by having two queries feeding the main figures on the report. One is a detailed query going down to country, genre and media type level which supplies figures to the crosstab.

The outer list is based on another query which just goes down to country level and is joined on a master detail relationship. The outer list query supplies the data items for the burst options. Figure How to set up a report studio report to dynamically filter burst keys which have data. This example is using dimensional data but the same principle applies to relational. This is defaulted to be in the hands of administrators. Review capabilities and decide who can have this facility. If your BI environment is pretty big and complex, then you might want to only restrict this to administrators anyway.

This is because bursting can take considerable time depending on how long it takes to run the report and how many files you need to burst out. Depending on how you have Cognos Connection set up you might only be able to run 3 reports in the background at one time. This will lead to a backlog of reports pending and waiting to run for hours. Tight controls over who can burst reports and when is advisable. The reason being that you may need to burst 1, files like one per cost centre which amounts to over 8 hours.

If this report failed during the burst or came out with incorrect figures then it may need rerunning. This delays the distribution by a day and could be a high profile issue for those who rely on the information to do their work on time. Work out a reasonable time frame for bursting a report and divide up by the number of files required for the burst now and growth potential in the future and come up with a target run time per report.

Some options for coping with or speeding up long running bursts:. Many fancy printers now have the ability to print ready-stapled! See figure 25 below for where this run option exists. Home Blogs Are you fit to Burst? An advanced guide to bursting reports in Cognos Report Studio. How to burst a crosstab or chart without nesting inside a list!

This process requires… Deciding which field will form the basis of separating the files e. If bursting the reports to an email address or CAMID CAMID is a method that restricts which users can see which output when they view it within Cognos Connection, based on authentication against their Cognos login , deciding how to correlate the burst key to a set of email addresses.

Steps to Burst a report to Directory Entries:. Create a List report with the following fields. Create a data item with the name BusrtRecipients and add the expression as shown below. Go to File menu and click on Burst Options and select the options shown below. Save it with some name. Go to the Cognos Connection where this report is saved. Click on Run with Options and again click on Advanced Options link in the right-hand side.