Financial Reporting Center: 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 the
following capabilities:

Refresh report data using runtime points of view or
parameters

Drill through from parents to other
parents

Drill down to detail balances, journal
lines, and subledger transactions

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.

Define Financial Reporting Center

Configure Financial Reporting Center

You have access to the reports through the folder
structure in the Financial Reporting Center and Workspace installed
with Oracle Fusion Financials. Your Oracle Fusion Business
Intelligence (BI) administrator defines the folder structure in Workspace
taking into consideration your company's security requirements for
folders and reports, as well as report distribution requirements for
financial reporting batches.

Security can be set on folders and reports from Workspace.
BI Catalog stores both the Financial Reports and the BI Publisher
Reports. You are granted access to the folders and reports you need
to view by your BI administrator.

Create and Secure Folder Structure

To create a folder or sub-folder:

Start at the Navigator by selecting Financial
Reporting Center.

From the Financial Reporting Center task panel, select Open Workspace for Financial Reporting.

Go to the Tasks panel and click Permissions. The Permission dialog is displayed.

Click the Add users/roles button.

In the Add
Application Roles, Catalog Groups and Users dialog box,
query the roles and select those desired. In this example, select
General Ledger Functional Administration Duty and General Ledger and
Profitability Managerial Duty.

Click the Move button.

Set Permission
to the level desired. In this example, select Full Control.

Click OK.

Configure Smart View Client for Users

Smart View is a multidimensional pivot analysis
tool combined with full Excel functionality. Smart View enables you
to interactively analyze your balances and define report using a familiar
spreadsheet environment.

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. Use the Smart View
Shared Connections URL. You can derive the Shared Connections URL
by following the following steps.

Launch Workspace from the Financial Reporting Center.

Edit the Workspace URL, for example, if the Workspace URL is https://fusionsystemtest-p-external-bi.us.oracle.com/workspace/index.jsp.
Remove index.jsp and add SmartViewProviders at the end of the URL.

If the Workspace URL is https://efops-rel5st4-cdrm-external-bi.us.oracle.com:10622/workspace/index.jsp,
the Shared Connections URL is https://efops-rel5st4-cdrm-external-bi.us.oracle.com:10622/workspace/SmartViewProviders.

Copy the URL.

Launch Excel.

Navigate to the Smart View menu > Options

Select the Advanced option.

Paste the URL in the Shared Connections URL field.

Click the OK button.

For more information on configuring the Smart View
client for users, see Oracle Hyperion Smart View for Office User's
Guide for Oracle Hyperion Smart View.

After performing the prerequisites and completing
the installation, launch the Financial Reporting Studio. You must
provide your user ID, password, and the Server
URL. Derive the Server URL information by following the steps:

If the Workspace URL is https://fusionsystemtest-p-external-bi.us.oracle.com/workspace/index.jsp,
the Financial Reporting Server URL is https://fusionsystemtest-p-external-bi.us.oracle.com.

If the Workspace URL is https://fusionsystemtest-p-external-bi.us.oracle.com:10622/workspace/index.jsp,
the Financial Reporting Server URL is https://fusionsystemtest-p-external-bi.us.oracle.com:10622.

Copy the modified URL to the Server URL field.

Note

For end users installing the Oracle Fusion Financials
Reporting Studio, the installer launches a separate console window
that continues to run for a brief time after the installation completes
the setup tasks. The process is normal, expected, and applies to Oracle
Hyperion Reporting Studio installations in both the Oracle Fusion
Applications and Enterprise Performance Manager modes.

Note

You must save a new report before attempting to preview
it with Web Preview.

Define Essbase Database Connections in Workspace

You need to create database connections from
Workspace so you can access the cubes from Workspace and Financial
Reporting Studio.

Note

Ledger setup has to be completed before the database
connection can be created. Oracle Fusion General Ledger balances 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.

From the Financial Reporting Center task panel, select Open Workspace for Financial Reporting.

The database connection is available in both Workspace
and Financial Reporting Studio. Optionally, the database connection
can be setup in Financial Reporting Studio while entering the grids
on a report.

Create Financial Statements: Explained

In Oracle Hyperion Financial Reporting Studio,
you can design traditional financial report formats such as balance
sheets, profit and loss statements, and cash flow reports. You can
also design nontraditional reports for financial or analytic data
that include text and graphics. Use Financial Reporting Studio that
is a client-based application and is launched from your desktop to
create your reports. Perform the following basic tasks to begin defining
this report.

Access the Financial Reporting Studio on your desktop.

Tip

The first time you sign in, you must set the Server
URL in this format: https://<servername>-bi-ext.us.oracle.com:port.

(B) New Report (1st icon on the tool bar) or (M) File > New > Report.

Use the Report Pallet page as the
container to build your report.

(B) New
Grid. (First icon in second set on the tool bar.)

Press the left mouse button and drag
the mouse to select a large area of the grid in which to create your
report.

Click the Database Connection list.

Select your database. A unique cube
exists for each combination of chart of accounts and accounting calendar.

(B) OK.

Set the Row, Column, and Page Points of View

Set the point of view dimensions and accounts for
the rows, columns, and page levels.

Use the Dimension
Layout window that opens to arrange your dimensions.

Drag and drop:

Accounting Period to Columns.

Account to Rows.

Company to Pages.

Tip

Click the icon in front of the name to select the
dimension to drag to the designed area.

(B) OK.

Double-click on Account to open the Select Members dialog box to select the data to use in your report.

Click the Account list item in the Selected box on the right.

(B) Remove in the center to remove the default Account.

(B) Expand for Account node.

Expand:

All Corporate
Accounts

[Account]@[T]

95001

Select 95011 Revenue.

(B) Add.

(B) OK.

(M) File > Save As...

Select My
Folders.

Enter the name for the report: XXInFusion
Income Statement.

(B) Save.

Select the last row in the grid.
Click the row header (row with the account in it).

(M) Insert
> Row > Text to add
a blank row.

Right-click the row header.

(M) Insert Row > Data to add another blank row.

Add expense accounts by double-clicking
on account 95011 in line 3.

Remove the Selected account 95011.

Expand:

All Corporate
Accounts - V1

[Account]@[T]

95001

95021 - Expenses

Select all three accounts: 50000, 60000, and 70000.

(B) Add.

Check the Place selections into separate rows check box on the
bottom right.

(B) OK.

(I) Save. Leave the report open for the next activity.

Add a Formula

Add a formula to calculate total expenses.

Right click the row header of the
row below row 5.

(M) Insert > Row > Formula.

Click in the blank cell on row 6.

Click the Custom Heading option in the panel on the right hand
side of the window.

Add a custom heading: Total Expenses.

Click the formula cell at row 6 and
column A.

(B) Sum(). The formula Sum() is entered into the Edit box.

Enter [3], [4], [5].

After entering the formula, validate
the syntax by clicking the blue check mark.

(I) Save. Leave
the report open for the next activity.

Define Columns Using a Range Function

Define the columns using a range function to create
a rolling 12 period column type report.

In the first column on the grid,
double-click the AccountingPeriod cell.

Remove the default selection to assign
a custom period selection.

Click the AccountingPeriod in the Selected window.

(B) Remove.

(T) Functions.

Click the Range list item.

(B) Add.

(B) OK.

Use the Edit
Range Function window to add the range function start
and end members or to select a hierarchy to use to select your report
data.

Select the StartMember row.

Click in the Value field.

(B) Lookup.

(T) Functions.

Click the RelativeMember list item.

(B) Add.

Select the Member row.

Click in the Value field.

(B) Lookup.

Click the Current Point of View list item.

(B) Add.

(B) OK.

The Offset value determines periods
to include from the current point of view. Since this is a rolling
12 month report, enter -12.

(B) OK twice.

Click the EndMember list item.

(B) Lookup.

Click the Current Point of View list item.

(B) Add.

(B) OK three times until you return to your report.

(I) Save. Leave the report open for the next activity.

Define User Points of View

Define the user points of view for the dimensions
and specify values for those dimensions.

Select the Grid object (The intersection of rows and columns on
the left margin.)

Right-click the Grid object.

(M) Grid
Point of View. The points of view appear across the top
of the window.

(B) Ledger:
User Point of View for Ledger.

Expand:

Ledger

All Ledgers

Highlight the Ledger item to include
in the report: InFusion USA PL.

(T) Scenario.

Expand Scenario.

Select Actual as the Scenario member to determine
what should be included in the columns.

(T) Balance
Amount.

Expand the Balance Amount.

Select Period
Activity as the balance amount to include in the report.