Note:
In this topic, references to Oracle Hyperion Financial Reporting apply to both the on-premises and Oracle Planning and Budgeting Cloud versions of Financial Reporting.
To import Financial Reporting documents into Excel:
The Import Workspace Document wizard is displayed.
Note:
Some wizard screens do not apply to some documents.
The document is previewed in the Import Workspace Document window.
Note:
Some options may not be available for some documents.
Note:
To display this screen, select Preview in EPM Workspace preferences, for User Point of View.
Note:
This screen is displayed only if the document contains prompts.
Fully-Formatted—displays reports in a fully-formatted HTML.
Query-Ready—enables you to run ad hoc analysis on reports when connected to Oracle Hyperion Financial Management and Oracle Essbase data sources.
Note:
Perform a Refresh on an imported report before you begin working on it in query-ready mode to ensure that the report and the POV are in sync.
Function Grid—a dynamic grid format, allows you to further select a report option, as described in step 18.
Note:
This option available only if you selected Fully-Formatted in step 13.
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 16.
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.
You can now move objects within the sheet, slide, or page.
When you are ready to exit design mode, select Toggle Design Mode again.
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.