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.
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.