To import Interactive Reporting documents into Excel:
In the Smart View Panel, connect to a EPM Workspace data source.
Navigate to the Interactive Reporting document that you want to import.
From the Action Panel, click Open.
The Import Workspace Document wizard is displayed.
Note:
Some wizard screens do not apply to some documents.
Refresh and Preview, to change filters or values prior to previewing the document
Preview, to preview the document with default settings
If you are importing a CubeQuery section in query ready format, do not select this option.
If you selected Preview in step 6, skip to step 11. If you select Refresh and Preview, continue with the next step.
If user authentication is required to change filters, such as variable, value, or option in the document's settings, in Specify Database Credentials, enter the username and password, and select Next.
The connection name is displayed in parentheses (for example, Sample.oce).
To import all pages of the document, leave the All Pages field check enabled.
If your document contains multiple pages, select Split pages across worksheets to display each page on a separate Excel worksheet.
From the Import Section As drop-down, select one of the following:
Data to import content as query-ready HTML. The current page of the current CubeQuery section is converted to HTML and Smart View formatting is removed. This enables you to requery the data source independent of the Web application.
Image to import content as formatted HTML. The current page of the CubeQuery section is converted to HTML with Smart View formatting definitions and calculated members. Smart View does not directly query the data source. This option is available only for a CubeQuery section for Refresh and Preview.