Define Database Connections in Workspace for Financial Reports

You must create database connections so you can access the cubes from Workspace and Financial Reporting Web 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. Each combination of chart of accounts and accounting calendar has a separate cube. Each cube needs a database connection.

Steps to define a database connection are:

1. From the Financial Reporting Center work area, open the Tasks panel and select the Open Workspace for Financial Reports task.

2. From within the workspace, select the Navigate menu > Applications > BI Catalog.

3. From the Tools menu, select Database Connection Manager.

4. On the Database Connection Manager window, click New.

5. Enter a user-friendly name for the database connection name.

6. Enter Essbase as the Type, your server, user name, and password.

7. Select Application (cube) and Database from the list of values.

8. Expand the Application name to see the related database, for example, db.

   The following figure shows the Database Connection Properties window with the completed fields from steps 5 through 8.

   

9. Click OK twice to save your selections.

10. Click Close to save the connection.

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

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