Bursting

[mrcool]

Hi Frnds,

                   Here is our requirement.We are designing dashboard reports.Each report must be run for different levels and output must be saved.i.e we have level0,level1,level2,level3.For example if level0 has global reports level 1 reports europe,asia and there next level continues.So like this in all combination I will get more than 2000 reports(outputs).we created a folder structure in cognos like we have folder name Global(we will hav global report outputs)--->Europe,asia n othere folders--->inside europe next level folders will be there.

So I want to use the burst option instead of running the report for each and every level and country and saving it....

Can Any 1 suggest me how to do this with bursting.I know that we must create table in database,so I need on what r the columns 2 b used.Can I use one column as country and other column which has folder path.So that wen we burst the report will the report output gets saved in the respective folder given in the path?

Please help me out....thanks in advance...If u need any more details plz let me know.....