Dimensional Report Sectioning

[cognos05]

Hi I have report with prompts showing 3 levels of hierarchy and crosstab with products in rows and measures on column .

User requesting the report to run for all territories which is one of the level ,so that when they export it to excel each tab will have data filtered for each territory.

How can we achieve this in general , do i need to section my dat item on territry and nest to the rows before product .

They are also asking if its possible to put a button and on hit of button it exports to excel with all the territories .

Any suggestions on how to approach is much appreciated.

Thanks,

[Francis aka khayman]

you can use page sets for territory per tab.

button can't be done but it will be really cool if someone proves me wrong or has some kind of workaround.

[Andrei I]

They are also asking if its possible to put a button and on hit of button it exports to excel with all the territories .

You can add a Drill-thru with an Excel icon and configure it to run either the same report or another one with relevant parameters.