Note: | When exporting multiple pages to PowerPoint, all pages are placed in a single slide. To have them automatically placed in separate slides, use Oracle Hyperion Smart View for Office, Fusion Edition in PowerPoint to import the reports. |
To export Financial Reporting report and snapshots to Microsoft Word or PowerPoint as an image, you must install and configure either GNU or AFPL Ghostscript on the Financial Reporting Print server. |
html and pdf reports with or without Page dimension – any report with or without a page dimension, when exported as an image to Microsoft Word or PowerPoint only exports the first physical page. A report with a page dimension behaves as follows:
Export to Microsoft Excel – only the currently selected page dimension member is exported. For a selected page dimension value, the report may spread across multiple pages.
Export to Microsoft PowerPoint – only the first physical page of the report is exported.
When exporting a Financial Reporting document to a Microsoft Office format (Excel, Word or PowerPoint), when using Microsoft Office 2007, you may receive the following warning: "The file your are trying to open <filename>, is in a different format than specified by the file extension. Verify that the file is not corrupted and is from a trusted source before opening the file. Do you want to open the file now?". This warning notifies users that, although the file has an Office extension ( ".xls", ".doc" or ".ppt"), the content of the file is different from the expected (native) Office format. Although Financial Reporting reports are generated in an MHTML format during export, this is not a security concern. Microsoft Office is just warning a user of a file format that is different than expected. Upon selecting “Yes” in the warning, the file will successfully open in Microsoft Office.
To export a report or snapshot to Microsoft Excel, Word, or PowerPoint:
To export a grid on the report as query ready, select Export in Query-Ready Mode. This option is located at the bottom of the report. You cannot use this option to export snapshots.
Note:
Because of limited object positioning in html, exported objects may overlap and will need to be repositioned in Microsoft Excel.
Select one of the following submenu commands:
To export the current financial report as formatted HTML, select Excel , then Fully-Formatted Grid and Text.
To export the current page of the current financial report to Microsoft Word as a static image, select Word.
To export the current page of the current financial report to Microsoft PowerPoint as a static image, select PowerPoint.
Snapshots are always exported as static images.
The File Download dialog box displays profile information about exported content.
The file is opened in the selected mode. To save the file to your machine, select File, and then Save As.
Note: | When exporting Financial Reporting grid objects to Excel the values are exported as displayed in the report. The desired number of decimal places for precision should be set in the report before exporting. |