Smart View enables the following export options:
Export 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 again to refresh the image.
Export documents to Microsoft Excel as either query-ready HTML or formatted HTML.
When you export content as query-ready HTML, the current page of the current data object is converted to HTML and Hyperion-specific formatting is removed. This enables Smart View to query the data source independent of the web application.
When you export content as Formatted HTML, the current page of the current data object is converted to HTML with the Hyperion formatting definitions and calculated members. This formatting content prevents Smart View from directly querying the data source, but enables Hyperion content to be leveraged by Office applications.
Not all export options are supported by all data sources and web applications. The following table indicates export options for Smart View:
Because Excel worksheets prevent users from entering data into read-only cells, some Excel functions, such as AutoSum and F9, and some formatting functions, are disabled in Smart View.