PowerPlay report outputting to excel

[dhines]

Hi all,
I have numerous cubes that need refreshing and then reports opening and their contents being output to excel files for formatting. I am using PowerPlay version 6.61 (R2), this ideally would be done in a cognos script, I think I know how to refresh the cubes automatically, but I am unsure how to export the reports data, automatically. By the way the reports have layers which also need to be output, and this is by two measures.

Any help would be appreciated.

Thanks

Dave.

 

[RVLF]

The SaveAs Method do it

Report.SaveAs FileName, Format

Format for Excel is 4, for ASCII 3