Bursting in cognos

new_perl_user used Ask the Experts™
I am using cognos 8.4. developed a report and want to burst it .  But one of the problem I am facing here in the header I am inserting a  start date and  End date.

So my cognos admin mentioned to me that the bursting will not allow any date queries in header. Is that true.
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®

how are you inserting the date and what is your burst key?


All my required columns are in Query 1,  then I created Query2 and in that two Dataitems.

one is start date (Expression for it is : _first_of_month(_add_months(current_date,-4))
other one is End Date (Expression for it is : _last_of_month(_add_months(current_date,-2))

I am creating a table in the header and dropping the above two items.

My burst Key is   Id

Have you tested and it failed or you just want to confirm your admin's statement?
When I tested a burst report with start and end date prompt values in header, it works fine.
Introduction to R

R is considered the predominant language for data scientist and statisticians. Learn how to use R for your own data science projects.

What burst options have you set in your report?
It's under 'File >> Burst Options'.


I am a bit new to cognos so I  am confirming my admins statement. One more help please  can you please let me know the steps to follow for bursting a Cross tab Report.

and also my  current date result will be  " May 1, 2011 - July31,2011"  how can I change  this to "May-Jul 2011"

Individual date display can be formatted to what you want to display using properties 'Data' and select date format.
Then, select what you want to display and what to hide.

If it is a range display, it'll be little tricky to have one part only show month and another full.


can you please let me know the steps to follow for bursting a Cross tab Report.

I don't think you can burst a cross tab report.

To add;
you can only burst list report.
However, you may be able to burst a crosstab by adding the crosstab inside a list cell.


This document should help you:

How to burst a crosstab report

Technote (troubleshooting)


This document describes how to burst a crosstab report.
Resolving the problem

Add the burst key to a data container with one dimension, such as a list report. To burst a data container with multiple dimensions such as a chart or crosstab, create a master-detail relationship between this query and a single dimensional query, and then add the burst key to the single dimensional query.

Drop the crosstab within a list object that contains the burst key. Please see the attached Cognos 8.2 report spec going against the GO Sales and Retailers package.

    Create a list report with the data item (Staff Name (Multiscript)) that you want to burst on as your first column. This will be the master list.
    Insert your chart or crosstab as the second column of the list. This automatically creates a second query, which will be the detail query.
    Add data items to your crosstab as needed. (Order Method as Rows, Order Year as Column, Quantity as Measure)
    In the list, create a section with the item you want to group on. This is for formatting only.
    Hide the list column title under the List property General -> Column Titles -> Hide.
    In the Query Explorer, add the burst key data item that is in Query1 to Query2 (Staff Name and Email)
    Select a crosstab cell and use the ancestor tool to move up to 'Crosstab' In the properties for the crosstab, edit the Master Detail Relationship property to link the burst key in both queries. (Staff Name)
    Click on the row section of the crosstab (Order Method in the example provided). In the properties pane under Data, open the Properties dialog and click on the box for the burst key so it is checked.
    Set Burst Options to burst on the list object's burst key.
    Burst the report and view the results.

I tested this by adding a crosstab under a list and then defining master-detail relationships.
Works fine.

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial