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.....

Mrcool

[trbadami]

Create a table with Country name, email address and Folder columns. If you want to burst on email then email column is required. In folder column you will have to save CAMID value of each user. You can get this value of each user by Directory option under tool. Make sure that your report is grouped on country and a matching column like country is present in your report query. try it out and let me know if you any need any help.

Regards
Tanweer Badami