Creating .OCE Datbase Connection Files

An Interactive Reporting database connection file (OCE) is a portable file that describes the connection to your data source for the relational or Essbase database. The.OCE file can be created in Interactive Reporting, and stores information about the BQY’s (queries) database connections, such as user names and passwords.

If you frequently generate the same report, use the same .OCE file. If you create custom reports using data from multiple sources, you may require multiple .OCE files for one report.

  To create an Interactive Reporting .OCE file:

  1. Create an ODBC connection on the Interactive Reporting computer to the database for the report.

  2. Select Start, then Synchronize With Shared Services, then Programs, then Interactive ReportingUtilities and Administration, and then Service Configurator.

    Select the DAS service and add the ODBC connection information including the connection type (ODBC), database type and the name of the data source, which is the ODBC connection name.

  3. Select Start, then Programs, then Oracle EPM, and then Interactive Reporting Studio to create the .OCE file.

    The Database Connection Wizard is displayed.

  4. Under Create a New Document, click A New Database Connection File, and select Repository Document from the list.

  5. Define the database connection as follows:

    • Select ODBC as the type of connection software.

    • Select the type of database you are using, such as Oracle.

    • Enter the database User Name and password

    • Enter the IP address or name of the ODBC database host

  6. Click Finish.

  7. Save the file.

  8. Close Oracle's Hyperion® Interactive Reporting Studio.

    Publish the OCE file to the Interactive Reporting Server. See Importing .OCE Files Using EPM Workspace.