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 file can be created in Interactive Reporting, and stores information about the database connections, such as user names and passwords.
If you frequently generate the same report, you only require one OCE file. If you create custom reports that access data from multiple sources, you may need many OCE files for one report.
To create an Interactive Reports OCE file:
Create an ODBC connection on the Interactive Reporting computer to the database that is to be used by the report.
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.
Select Start, then Programs, then Oracle EPM, and then Interactive Reporting Studio to create the .OCE file.
The Database Connection Wizard is displayed.
Under Create a New Document, click A New Database Connection File, and select Repository Document from the list.
Complete the wizard screens to define the database connection information:
Select ODBC as the type of connection software.
Select the database type.
Enter the database User Name and password
Enter the IP address or name of the ODBC database host
Close the Interactive Reporting Studio.
Import and publish the file to the Interactive Reporting Server.