COGNOiSe.com - The IBM Cognos Community

IBM Cognos 8 Platform => COGNOS 8 => Report Studio => Topic started by: lifzgud on 18 Sep 2009 08:26:46 AM

Title: Urgent Help required in Bursting
Post by: lifzgud on 18 Sep 2009 08:26:46 AM
Hi folks,
I need a solution to the following urgently.Please help me out
I have a column named Division Number.There are five values to it.
1)I have to create a master report
2)I also have to create a report for the 5 division numbers individually..I think Bursting is an option
3)I need to save the reports in the cognos connection portal(i.e. content store) but they must be recognisable.that is they report names must specify whether it a master report or a division report.
May be i can append some name while i create it or maybe i can save them in diffrent folders.

That is 6 reports.Format is excel.one master and 5 division specific

Please help me out guys.i need a solution by end of day :-[
Title: Re: Urgent Help required in Bursting
Post by: adoremars on 18 Sep 2009 08:33:46 AM
Hi,

Create a master report which includes all the 5 divisions and then create 5 reports seperately for 5 divisions with a filter in each of the reports. For eg 'Column name'=1 This is the filter for the first report where in it populates data only for the division 1.
Title: Re: Urgent Help required in Bursting
Post by: lifzgud on 18 Sep 2009 08:50:34 AM
See i am trying to create it from user point of view.
Can't i create a single report and when i click it it bursts into one master and 5 divisions?
I know it sounds weird
Thanks anyways
Title: Re: Urgent Help required in Bursting
Post by: adoremars on 21 Sep 2009 05:01:34 AM
yup you can use drill through then
Title: Re: Urgent Help required in Bursting
Post by: billylodz on 21 Sep 2009 05:07:25 AM
what the users want to have ?
not sure what for you want to use bursting

create report with one total page and next one page per division (use page set)
you will have one excel with 6 sheets


or crate report with drill down with link to excel, when user will go to level they want, can next click link and open the report in Excel format
Title: Re: Urgent Help required in Bursting
Post by: lifzgud on 22 Sep 2009 12:11:29 AM
How do i use drilldown?
I'm sorry i have never used it before.