Importing Financial Reporting Documents into Excel

  To import Financial Reporting documents into Excel:

  1. From the Smart View ribbon, select Open.

  2. In the Smart View Panel, connect to a EPM Workspace data source.

  3. Navigate to the Financial Reporting document that you want to import.

  4. From the action panel, click Open.

    The Import Workspace Document wizard is displayed.

    Note:

    Some wizard screens do not apply to some documents.

  5. In Select a Document, expand the repository, select a Financial Reporting document, and click OK.

    The document is previewed in the Import Workspace Document window.

    Note:

    Some options may not be available for some documents.

  6. If the Preview User Point of View is displayed, preview the current POV or change the members of the POV.

    Note:

    To display this screen, select Preview in EPM Workspace preferences, for User Point of View.

  7. Click Next.

  8. Optional: If you want to change the default value, in Respond to Prompts, make a selection for prompts, and click Next.

    Note:

    This screen is displayed only if the document contains prompts.

  9. Optional: In Preview from Grid POV, change the POV by selecting a POV.

  10. Change the page dimension by selecting Page.

  11. To import all pages of the document, select All Pages to import all pages of the document.

  12. To display each page on a separate Excel worksheet, select Split Pages across worksheets.

  13. In Import Document As, select an option:

    • Fully-Formatted (displays reports in a fully-formatted HTML)

    • Query-Ready (enables you to run ad hoc analysis on reports when connected to Financial Management and Essbase data sources)

    • Function Grid (a dynamic grid format)

  14. Click Finish.

    The document is imported into Excel. If you used the Fully-Formatted option, you can only view the Reporting and Analysis document. If you used the Query-Ready option, then connect to a Financial Management or Essbase data source, you can perform ad hoc analysis, such as retrieving, zooming, or pivoting data.