Export a Report to a Different File Format

Another way to integrate IBM® Cognos® PowerPlay® with other application environments is to export your PowerPlay reports to other formats. You can export a PowerPlay report in the following formats.

  • Delimited ASCII text file
  • Microsoft Excel
  • PDF

When you export a report in delimited ASCII or Microsoft Excel format, the top of the text file or the first few rows of the Microsoft Excel worksheet show the date and time of export, the report file name, the name of the associated cube, and the report type (Explorer or Reporter). The folder names in the dimension line and the data appear below this information.

If your PowerPlay report includes layers, a separate Microsoft Excel worksheet is created for each layer.

When you export a report in delimited ASCII or Microsoft Excel format, you can export only the level of data you see in the report.

Procedure

  1. From the File menu, click Save As.
  2. Select a folder and type a name for the file.
  3. In the Save As Type box, click the file format, and click OK.