Is it possible to use a Macro to create a Power Play Report?

[nan01]

I am very new to Macros and Cognos in general and I would like some advise on the best way to create a set of Reporter reports through a macro or if there is a better way to do this.

The problem I have encountered is the data in a Reporter report is not dynamic therefore if new categories get added after running the cube that were not present when the Reporter report was created, they do not show up in the rows of the report.
I already have a macro that opens up the set of reports and prints them.

I am running Power Play version 6.6.

What I have to do now is manually open up each report after a new monthly run of the cube, double click on the total line to include any new categories go to the top of the report and erase the previous categories, Move the total line to the bottom of the report, Rename it TOTAL, Insert a blank line above the TOTAL and resave the report.

It seems possible but I wanted to ask the experts instead of wasting time and finding out it was not possible or there was a better way to do this.

Thanks ahead of time for your response.

 

[MerIT]

for what i know it is possible and there is even an example in help / pdfs that covers your question but I don't remember where now because I'm also new to cognosscript macros (brrrr)
Cognos Reference Guide for PPlay and for Transformer will be a help: GenerateCategories Method in Transformer and CategoryList Object in PowerPlay.
regards
Gregory

 

[GJParker]

You can make the data in reporter reports dynamic by using subsets. Take a look in the help, if you need any further help then let me know.

HTH

Gary Parker
Systems Support Analyst
Manchester, England

 

[flex13]

You could also just use Subsets in the report and bypass most of the automation tasks.

Flex