Oracle Hyperion Smart View for Office, Fusion Editionfor Office provides a common Microsoft Office interface for these Oracle | Hyperion products:
The centralized interface enables simultaneous use of multiple Oracle | Hyperion products, and improves integration with Microsoft Office (2000, 2002, and 2003). The Smart View implementation provides this functionality:
Smart View enables these import options:
You can import the current page of the current data object to Word, PowerPoint or Excel as an image. After insertion, you can query the corresponding Web application to refresh the image.
You can import an entire report with multiple report objects to Microsoft Excel.
You can import documents to Microsoft Excel as query-ready HTML. When you export content as query-ready HTML, the current page of the current data object is converted to HTML and Oracle | Hyperion-specific formatting is removed. This enables Smart View to requery the data source independent of the Web application.
You can export documents to Microsoft Excel as formatted HTML. When you export content as Formatted HTML, the current page of the current data object is converted to HTML with the Oracle | Hyperion formatting definitions and calculated members. This formatting content prevents Smart View from directly querying the data source, but enables Oracle | Hyperion content to be leveraged by Office applications.
The following export options are supported in Web Analysis Studio.
Export image to Microsoft Word and PowerPoint
Export an image of the report screen to Microsoft Word, or PowerPoint.
Export formatted HTML files to Microsoft Excel
Export Query-ready HTML files to Microsoft Excel. Smart View should be installed to enable query-ready export.
Export all report objects to Microsoft Excel in separate worksheets
Export next data objects to Microsoft Excel: Spreadsheet, Chart, Pinboard, freeform Grid and SQL spreadsheet. All data object, regardless of their type, get exported as a spreadsheet.
Note: | Export to Microsoft Excel report can be refreshed against a Web application, but export to Microsoft Word and PowePoint does not support refresh. |
Because Excel worksheets prevent users from entering data into read-only cells, some Excel functions such as AutoSum, F9, and some formatting functions are disabled in Smart View. Also note that Microsoft Excel, Word and PowerPoint must be installed on the computer running the Oracle's Hyperion Reporting and Analysis client.