PowerPlay Reports

[CChrisC]

Hi,
We are trying to automate some PowerPlay reports (we are not using impromptu).
What we would like, is to automate the running to several standard reports. I think I can use macros for this. Unfortunately I am finding the macros are very confusing. Does anyone out there have any experience of this? Any samples I could pick through?
Also I would like to run some of the reports, filtering perhaps by Sales men etc.
Can I do this?

 

[ADB1]

To execute a simple schedule of Powerplay cube loads, we run MDL scripts through the cognos scheduler. MDL scripts can contain more than one cube.

Cheers,

Adam.

 

[CChrisC]

Adam,
Thanks for the help. However I am not sure you have answered the question.
I know how to generate multiple cubes. What I cannot do is run the PowerPlay reports from a macro.

Cheers
Chris

 

[CognosProfessional]

Hi Chris, Check out the code provided in the documentation that comes with your product. However, why do you want to 'run' a .ppr? You can just open it, and save it and it updates with each newly saved cube. To run a .ppr is to open it. You can have the filtering on various .ppr reports. I don't really understand what you are looking to do with pre-created .ppr reports. You want to build a report with a macro instead of just using the .ppr? Client based?
The only reason I would see that you would need this is for using it on the web only, but you want to 'run' PowerPlay reports. Clarify what you mean by this because macro's can open .ppr's after cubes are updated and are for you to view where you want them to be when the macro is done.
CP

 

[CChrisC]

CP,
What we need to do is run a set of reports, based on the updated cube. Ideally, these will be run (and be exported to Excel/PDF) as part of the batch job that creates the cube. What we don't want is to have a user manually run dozens of .ppr's every week.

Thanks
Chris