To import Financial Reporting documents into Excel:
In the Smart View Panel, connect to an EPM Workspace data source.
Navigate to the Financial 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.
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.
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.
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.
Optional: In Preview from Grid POV, change the POV by selecting a POV.
To display each page on a separate Excel worksheet, select Split Pages across worksheets.
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, allows you to further select a report option, as described in step 17.
Your next steps depend on the option you selected in step 13:
If you selected:
Fully-Formatted—the document is imported into the Office application, and you can only view the Reporting and Analysis document.
Query-Ready—the document is imported into the Office application, and you can now connect to a Financial Management or Essbase data source, where you can perform ad hoc analysis, such as retrieving, zooming, or pivoting data.
Function Grid—continue with step 15.
Select the function grid object in Document Contents, right-click and select Insert New Reporting Object/Control.
From the Insert New Reporting Object/Control dialog box, select one of these report types to place on the grid:
Function Grid — a dynamic grid format
When you refresh a function grid, data cells are refreshed; members are not. To refresh both data and members, you must reinsert the function grid into the sheet. For this reason, function grids are most useful for reports in which members remain reasonably static. For reports whose members may change more often, tables and charts are better report types. Although you can have multiple reports on a worksheet, you can have only one function grid.
You can use Excel formulas, for example SUM, with function grids. To retain such formulas as part of the function grid, you must leave one empty row between the grid and the cell containing the formula and include the empty row in the range of cells selected for the formula definition. This permits retention of the formula when refreshing the data results in a different number of rows in the grid.
To format a function grid, use Excel formatting capabilities.
Table
Table reports display results in a grid format that floats on the document and can be moved and re-sized. When you refresh a table, both members and data are refreshed. Tables are useful for displaying large grids in a smaller space; their scroll bars enable you to quickly access rows and columns.
You can zoom in and out in a table report, but you cannot perform other ad hoc operations or use free form.
Chart
Chart reports display results in a chart format that floats on the document and can be moved and re-sized. When you refresh a chart, both members and data are refreshed.
Optional: To move or re-size a table or chart, in Document Contents, click the down arrow next to
, and from the menu, select Toggle Design Mode.You can now move objects within the sheet, slide, or page.
When you are ready to exit design mode, select Toggle Design Mode again.
To insert a report control, select the report object in Document Contents, right-click and select Insert New Reporting Object/Control.
From the Insert New Reporting Object/Control dialog box, select one of these report control types:
POV—a report can contain only one POV
Slider—a report can contain multiple sliders. See Sliders.
A report can contain a POV or sliders, but not both.
Optional: to create a separate report for any or all of the members of one dimension in the report and cascade these reports separately across the worksheets of the workbook, see Cascading Reports and Ad Hoc Grids.
Note:
In reports that contain a chart and a table, cascading may cause the chart and table to overlap the next time you open the workbook.
to refresh the