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.
Steps to define a database connection are:
-
From the Financial Reporting Center work area, open the Tasks panel and select the Open Workspace for Financial Reports task.
-
From within the workspace, select the Navigate menu > Applications > BI Catalog.
-
From the Tools menu, select Database Connection Manager.
-
On the Database Connection Manager window, click New.
-
Enter a user-friendly name for the database connection name.
-
Enter Essbase as the Type, your server, user name, and password.
-
Select Application (cube) and Database from the list of values.
-
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.
-
Click OK twice to save your selections.
-
Click Close to save the connection.
For more information about configuring Essbase database connections in Workspace see: Oracle Essbase Database Administrator's Guide.