- Working with Oracle Smart View for Office
- Smart View and Reporting and Analysis
- Importing Financial Reporting Documents
- Importing Financial Reporting Documents into Excel
Importing Financial Reporting Documents into Excel
To import Financial Reporting documents into Excel:
- From the Oracle Smart View for Office ribbon, select Panel.
- In the Smart View Panel, connect to an Oracle Enterprise Performance Management Cloud service .
- 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 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 for User Point of View in the preferences for your EPM Cloud service.
- Click Next.
- 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.
- Change the page dimension by selecting Page.
- To import all pages of the document, select All Pages.
- Optional: To refresh the Financial Reporting document using the EPM Cloud service Point of View, select Refresh Using Workspace Point of View.
- 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 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.
-
- To display each page on a separate Excel worksheet, select Split Pages across worksheets.
Note:
This option available only if you selected Fully-Formatted in step 13.
- Click Finish.
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.
-
- Click
to refresh the Document Contents pane.
- 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 resize 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.
- Refresh.
- 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.