Create Data Source Connections to Oracle Essbase Cubes

Use the following procedure to create a data source connection to an Oracle Essbase cube.
Note: To connect to an Oracle Essbase data source, the client software must be installed and configured on the IBM® Cognos® Business Intelligence server and in the same location as IBM Cognos Framework Manager.

Procedure

  1. Launch IBM Cognos Administration.
  2. On the Configuration tab, click New Data Source.
  3. In the name and description page, type a unique name for the data source and, optionally, a description and screen tip, and then select Next.
  4. In the connection page, from the Type drop-down list, select Oracle Essbase, and then click Next. The connection string page appears.
  5. Type the name of the Oracle Essbase sever.
  6. Select Signons, and then click Password and Create a signon the Everyone group can use.
  7. Type the User ID, Password, and then confirm the password for the cube.
  8. Select Test the connection, and then Test to test whether parameters are correct. In the Status column, you can see if the connection was successful. If it was unsuccessful, select Close, return to the previous steps, and verify your connection parameters. If it was successful, go to the next step.
  9. Click Finish.

Results

To use this data source, you must create a package using this data source in Framework Manager, and then publish the package.
Parent topic: Creating Data Source Connections to OLAP Data Sources