After creating the OCE file, it must be imported to the EPM Workspace server for use in generating the reports.
To import the OCE file:
Log on to EPM Workspaceas an Administrator, and ensure that the Hyperion Workspace Agent and Web Application services are running.
Select Explore and navigate to the location of the repository.
Right-click, and then select New Folder to create a folder for the imported file. If you do not want to create a folder, leave the file under the Root (/:).
The Create New Folder box is displayed.
Right-click to display the shortcut menu, and select Import, then File to publish the .OCE file within Interactive Reporting.
The Choose File tab is displayed.
Under File on the Choose File tab, click Browse to navigate to the location of the .OCE file.
By default, the file is located in c:\hyperion\products\BIPlus\data\OpenCatalogExtensions.
Under Processing OCE Options, select these options and information:
From Data source access, select Use the username/password specified below.
Enter the Username and Password for the database.
Select Allow pass-through where end user’s authentication system is enabled for it.