Cognos Analytics

Hi, 

So far we can generate a report in pdf, Excel, csv, etc. format. Now, ¿is it possible to generate from a Cognos report several Excel files? for example several Excel files  for different users. 

Thanks a lot

Hello Diego

It is possible to generate multiple Excel files from a single Cognos report, each tailored for different users or with specific data subsets. Here's an approach to achieve this:

1. Create a Cognos report: Design and build your report as per your requirements, including the desired data, filters, prompts, and formatting.

2. Create a Bursting Query: Define a bursting query or a query with a parameter that generates the necessary subsets of data for each user or specific criteria. This query will determine the data that will populate each Excel file.

3. Define Output Formats: Configure the report to generate the output in the desired Excel format. You can specify the formatting options, such as column widths, font styles, and sheet names.

4. Enable Bursting: Enable the bursting feature in Cognos Analytics. Bursting allows you to create multiple output files based on a defined criteria or parameter.

5. Configure Bursting Options: Define the bursting options, such as the bursting key or parameter, the output file name pattern, and the location where the files will be saved. You can also specify any additional customization or file naming conventions based on user-specific data.

6. Schedule the Report: Set up a schedule to automatically run the report at specific intervals or on-demand. Specify the burst recipient or parameter values for each scheduled execution.

7. Execute and Distribute: When the report is executed based on the schedule or on-demand, Cognos Analytics will generate separate Excel files for each bursting criteria or parameter. These files can be saved to a designated location or distributed via email to the respective users.

Hi, 

So far we can generate a report in pdf, Excel, csv, etc. format. Now, ¿is it possible to generate from a Cognos report several Excel files? for example several Excel files  for different users. 

Thanks a lot

Hi, 

So far we can generate a report in pdf, Excel, csv, etc. format. Now, ¿is it possible to generate from a Cognos report several Excel files? for example several Excel files  for different users. 

Thanks a lot

Yes, it's possible. You need to read about bursting e.g.
Bursting Reports - IBM Documentation
Note. Please make sure to adhere to the licencing rules

Hi, 

So far we can generate a report in pdf, Excel, csv, etc. format. Now, ¿is it possible to generate from a Cognos report several Excel files? for example several Excel files  for different users. 

Thanks a lot