Using Smart View, you can import Web Analysis documents into Microsoft Excel, Word and PowerPoint. Web Analysis has five data object display types, but Smart View can import only three types (spreadsheet, chart, and pinboard). Smart View cannot import Freeform Grid and SQL spreadsheets.
To import Web Analysis documents:In Specify Database Credentials:
Enter a Username and Password for each data source.
Select Skip to omit the credential to any of the data sources
Note:
If a report has only one data source and you skip entering credentials, the report is not imported. If your report has data objects with different data sources and you only want to import one of the data objects, you can enter the credential for the data object you want to import and skip credentials for the data objects you do not wish to import.
Select Save Credential to save credentials with a Web Analysis object.
Click Next.
In Preview — Import Document As:.
For Excel, select Fully-Formatted to import a fully formatted HTML of the report, or Query-Ready to run ad hoc analysis on reports when connected to Financial Management and Essbase data sources.
For Word and PowerPoint, select Image to import the Reporting and Analysis document as image objects.
If the data object has multiple Pages, select a page to import (combo box in top left) or select All Pages to import all pages of the document. Leave the box cleared to import only the current page.
For Microsoft Excel, Word or PowerPoint, select Split pages across worksheets to display each page on a separate worksheet. For Query-Ready, when All Pages is selected, the pages are split across worksheets.
In Preview—All Report Objects for Microsoft Excel, Word and PowerPoint
Select Split pages across worksheets to display each page on a separate worksheet instead of one worksheet.
Select All Objects to import all objects of the report.
Select Split objects across worksheets to display each object on a separate worksheet.
In Preview—All Reports for Microsoft Word and PowerPoint: select Import Screen to import a screen print of the entire report.
Click Finish.