1. Administering Oracle Analytics Publisher in Oracle Analytics Server
  2. Set Up Data Sources
  3. Set Up a Connection to an OLAP Data Source

Set Up a Connection to an OLAP Data Source

You can create connections to several types of OLAP databases to access data for pixel-perfect reports.

  1. From the Publisher Administration page, click OLAP Connection.
  2. Click Add Data Source.
  3. Enter a display name for the data source. This name is displayed in the Data Source selection list in the Data Model Editor.
  4. Select the OLAP type.
  5. Enter the connection string for the OLAP database.
    Following are examples for each of the supported OLAP types:

    • Oracle's Hyperion Essbase

      Format: [server]

      Example: myServer.us.example.com

    • Microsoft SQL Server 2000 Analysis Services

      Format: Data Source=[server];Provider=msolap;Initial Catalog=[catalog]

      Example: Data Source=myServer;Provider=msolap;Initial Catalog=VideoStore

    • Microsoft SQL Server 2005 Analysis Services

      Format: Data Source=[server];Provider=msolap.3;Initial Catalog=[catalog]

      Example: Data Source=myServer;Provider=msolap.3;Initial Catalog=VideoStore

  6. Enter the user name and password for the OLAP database.
  7. Click Test Connection.
  8. Define security for this data source connection. Move roles from the Available Roles list to the Allowed Roles list. Only users assigned the roles in the Allowed Roles list can create or view reports from this data source.