Database Connection Manager

Use the Database Connection Manager to manage reports, books, saved reports objects (row/column templates, grids), batches, and scheduled batches.

Reports and report objects can be moved from a development environment to a production environment, or between production servers.

The Database Connection Manager provides the following information about each database connection:

• Name—Name assigned to the database connection by the user who created it

  For example, Vision:Plan1, or Vision:Plan2, or Vis1ASO.

• Type—Data source type (Oracle Fusion Forecast Management, Oracle Hyperion Planning, or Oracle Essbase)

• Value—Application and database name

  For example, if your application is Vision and your database name is Plan1, then the value would be Vision:Plan1.

Note:

Oracle Fusion General Ledger only uses Essbase as a database.

Designers can use Oracle Hyperion Enterprise Performance Management Workspace to create, maintain, and assign names to database connections.

Users can select an existing database connection when prompted in Oracle Hyperion Financial Reporting Studio; for example, while adding a grid to a report. A database connection consists of a database name, ID, password, and several values that are different for each data source.

Note:

This release of Oracle Hyperion Financial Reporting does not support SAP BW and MS OLAP as data sources.