Skip Headers

36 Define Financial Reporting

This chapter contains the following:

Financial Reporting Center Configuration: How It Works

Setting Up Your Financial Reporting Center: Critical Choices

Financial Reporting Center Configuration: How It Works

The Oracle Fusion Financial Reporting Center provides functionality for reporting on Oracle Fusion General Ledger balances. It provides secure, self-service access to reports that use real time account information.

You can design traditional financial report formats such as balance sheets, profit and loss statements, and cash flow reports. You can also design nontraditional formats for financial or analytic data that include text and graphics.

Components

Financial Reporting Center is comprised of numerous components:

Financial Reporting: Financial users and analysts access live reports and books or published snapshot reports and books from previously scheduled batches in a variety of formats. Other functionality includes:
- Refreshing report data using runtime points of view or parameters
- Drill through capability from parents to other parents
- Drill down to detail balances, journal lines, and subledger transactions.
Smart View: Financial analysts view, import, manipulate, distribute, and share data from your Oracle Fusion General Ledger balances in Microsoft Excel.
Account Monitor and Account Inspector: Financial analysts monitor and track key account balances in real time at every level of your dimensions and hierarchies. These tools provide multidimensional account analysis and drill down capability.
Workspace: Reporting administrators create, open, save, and delete folders and store report objects, reports, and snapshot reports.
Financial Reporting Studio: Report authors use an object-oriented graphical report layout with report objects, such as text boxes, grids, images, and charts, to design reports.

Setting Up Your Financial Reporting Center: Critical Choices

Oracle Fusion Financial Reporting Center is a powerful tool for accessing, designing, and presenting financial reports and analytic data. The steps needed to configure and install the components in Financial Reporting Center consist of:

Configuring Financial Reporting Center
Configuring Workspace Database Connection
Installing Financial Reporting Studio
Installing Smart View

Configuring Financial Reporting Center

Users access reports through the folder structure in Workspace. Administrators should define the folder structure in Workspace considering security requirements for both folder and reports, as well as report distribution requirements for financial reporting batches. Security should be set up on folders and reports from Workspace so users can only view the folders and the reports that they can access.

For more information on configuring the Financial Reporting Client including user name, password, server, and report structure, see the following:

Oracle Hyperion Enterprise Performance Management System Installation Start Here for Oracle Hyperion Enterprise Performance Management. See especially the following topics:
- Installing EPM System Products
- Financial Reporting Ports
Oracle Hyperion Enterprise Performance Management System Installation and Configuration Guide for Hyperion Enterprise Performance Management. See especially the following topics:
- Configuring EPM System Products
- Performing Post Configuration Tasks
Oracle Hyperion Financial Reporting, Fusion Edition Administrator's Guide for Oracle Hyperion Financial Reporting

Configuring Workspace Database Connection

Administrators need to create database connections from Workspace so users can access the cubes from either Workspace or Financial Reporting Studio.

Note

Ledger setup has to be completed before the database connection can be created. Cubes are created as part of ledger setup. There is a separate cube for each combination of chart of accounts and accounting calendar. A database connection is needed for each cube.

Steps to define a database connection are:

Start at the Navigator by selecting Financial Reporting Center > Launch Workspace
From within Workspace > Navigator > BI Catalog > (main tab), select Tools > Database Connection Manager
Select New button
Enter a user friendly name for the connection
Enter the Essbase server, user and password, and select Application (i.e. cube) and database

For more information on configuring Essbase database connections in Workspace see: Oracle Essbase Database Administrator's Guide for Oracle Essbase

Note

The database connection is available in both Workspace and Financial Reporting Studio. Optionally, it can be setup in Financial Reporting Studio when putting grids on a report. This should only be done by an administrator.

Installing Financial Reporting Studio

Financial Reporting Studio is client-based software. Report authors need to download the installation files in Workspace from Navigator -> Tools -> Download Desktop Integrator Installer to install Financial Reporting Studio.

After completing the installation, obtain financial reporting server information from your system administrator to connect from the local client to the Oracle Fusion instance.

For more information on configuring Financial Reporting Studio client for users, see the following: Oracle Hyperion Enterprise Performance Management System Installation and Configuration Guide for Oracle Hyperion Enterprise Performance Management. See especially the following topics:

Installing Financial Reporting Studio and Financial Reporting Print Server
Configuring the Financial Reporting Print Server
Administrative Information for Financial Reporting

Installing Smart View

Smart View is an Excel add-in that must be loaded to each client. Users need to download the installation files from Workspace, which is launched from the Financial Reporting Center work area. In Workspace, navigate to Tools > Install > Smart View.

Note

Since Smart View is an add-in to Microsoft Office products, you can install Smart View only on a Windows operating system.

Once Smart View is installed, it must be configured to connect to Oracle Fusion Applications. This is done using the Smart View Shared Connections URL. You can derive the Smart View Shared Connections URL by following the steps below:

Launch Workspace from the Financial Reporting Center.
Edit the Workspace URL, for example, https://fusionsystemtest-p-external-bi.us.oracle.com/workspace/index.jsp. Remove index.jsp and add SmartViewProviders at the end of the URL to launch Smart View.
Note

For example, the URL now appears as https://fusionsystemtest-p-external-bi.us.oracle.com/workspace/SmartViewProviders.
Copy the URL.
Launch Excel.
Navigate to the Smart View menu > Options > Advanced.
Paste the URL in the Shared Connections URL field.
Go to the Smart View menu > Open -> Shared Connections.
Note

The login window is displayed.
Enter your user name and password.
Click Shared Connections > Select Server to Proceed.
In the Add New Server field, add the Essbase server.
Note

The Essbase server URL is the BI Managed Server host (internal) and port 10215. For example: slcac.us.oracle.com:10215. If you are unsure of the host name for the internal BI host, contact your system administrator. You must enter the internal BI host in this URL or drill through functionality won't work.

For more information on configuring Smart View client for users, see the following:

Oracle Hyperion Enterprise Performance Management System Installation and Configuration Guide, for Oracle Hyperion Enterprise Performance Management, especially the Installing Smart View topic
Oracle Hyperion Smart View for Office, Fusion Edition User's Guide for Oracle Hyperion Smart View