Inserting a Financial Reporting Function Grid

When you connect to a Smart View query (specifically a function grid—a series of cells that contain cell functions), in Microsoft Excel or Word (imported Financial Reporting report), Disclosure Management imports all concepts automatically. Metadata (data source members) in the query—which has concepts mapped at the data source level, is also imported. Consequently, all that Smart View query requires are the context, units and footnote mapping performed in the same manner as report level mapping.

The benefit of importing as a function grid is that Function grids display query results in a dynamic grid format, in which the characteristics of each cell is displayed when you place the cursor over each cell. You can use Excel formulas, such as the SUM function with function grids.

Note:

To retain a formula as part of the function grid when you refresh function grid data, you must leave one empty row between the grid and the cell containing the formula. Remember to include the empty row in the range of cells selected for the formula definition.

  To import a Financial Reporting report as a function grid in Smart View:

  1. Connect to an Oracle Hyperion Enterprise Performance Management Workspace data source.

  2. In the Smart View pane, navigate to the Financial Reporting report.

  3. Right-click the report and select Open.

    Image shows Import Workspace Document dialog box

  4. Select All Pages to import all pages of the report.

  5. Select Split Pages across worksheets, to display each page on a separate Excel worksheet.

  6. Select Refresh Using Workspace Point of View, to refresh the report using the EPM Workspace POV.

  7. In the Import Document As, keep the default selection FunctionGrid.

    In Excel, you may also import a report as a function grid, in addition to the existing fully-formatted and query ready import formats.

  8. Click Finish.

    The function grid of the report is imported into Smart View.

  9. On the Smart View ribbon, select Refresh.

  To launch the Disclosure Management Mapping Tool:

  1. Select the Disclosure Management tab.

  2. Select Connect to connect to the Disclosure Management server.

  3. Enter the user name and password in the Name and Password fields, and click OK.

  4. On the Disclosure Management ribbon, select Map.

  5. Map the data source member or data cells using the Disclosure Management Mapping Tool.

    See Generating XBRL Instance Documents .