Enterprise RTView communicates with your OLAP database using either an ODBO (OLE DB) connection or an Applix Java API connection. The ODBO connection will enable writing MDX queries against your Microsoft SQL Server Analysis Services or Applix TM1 database in the Attach to OLAP Data dialog. The Applix Java API connection will allow you to display views from your Applix TM1 database in addition to allowing you to use aliases in your queries, but will not allow you to write MDX queries.

You will need to add your database and specify a connection type in the Display Builder in the Application Options dialog on the OLAP tab before Enterprise RTView will attempt to connect to your database. If Enterprise RTView is unable to connect to your database, either the connection string is incorrect, the OLAP server is not currently running, or you do not have permission to access the database. NOTE: Databases that have been setup to Use Client Credentials will not connect unless you are logged in and you have objects in your display that are using that connection.

If you are connecting to your database using ODBO, you will be required to specify a connection string. The connection string is vendor specific. Enterprise RTView supports connecting to Microsoft SQL Server 2000 Analysis Services and Applix TM1 8.4.3+.
 

Example Microsoft SQL Server Analysis Services Connection String:     Provider=MSOLAP;Location=MyServer;Database=MyDB Example Applix TM1 Connection String:     Provider=TM1OLAP;Data Source=planning sample

NOTE: Depending on your SQL Server installation, you may need to specify MSOLAP.2 for the Provider in your connection string for Microsoft SQL Server Analysis Services.

Sample Databases
Two sample databases are used in our sample displays located in demos\dstutorial, one for use with Microsoft SQL Server Analysis Services and one for use with Applix TM1. The following steps will need to be run on the system running the OLAP server.

Microsoft SQL Server Analysis Services
Import the sample database into Microsoft SQL Server Analysis Services:

1.    Open Analysis Manager.

2.    Select your OLAP server.

3.    Right-click on your OLAP server and select Restore.

4.    In the Open Archive File dialog, go to demos\dstutorial located in your Enterprise RTView installation directory and select SampleMD.cab.

5.    Click Open.

6.    In the Restore Database dialog click Restore.

Add the sample database to the Enterprise RTView Display Builder:

7.    Start the Display Builder.

By default, the Display Builder requires a login to support role based security. The default user name and password are:

•  User Name: admin
•  Password: admin

8.    Select Tools>Options to bring up the Application Options dialog.

9.    Select the OLAP tab and click Add Database.

10.    In the Add Database dialog, enter the following:
 

Name - SampleMD_SQLSAS Connection Type - ODBO User Name - <blank> Password - <blank> Connection String - Provider=MSOLAP;Location=localhost;Database=SampleMD NOTE: If you are not running the OLAP server locally, change Location to the name of the machine running the OLAP server. Depending on your Microsoft SQL Server Analysis Services installation, you may need to use MSOLAP.2 for the Provider.

11.    Click OK to add the sample database and close the Add Database dialog.

12.    Click Apply to attempt to connect to the sample database. If the connection has been successful, SampleMD will appear in the Databases field with a white background. If the background is yellow, the connection has failed.

13.    Click Save to apply and close the Application Options dialog.

Applix TM1
Import the sample database into Applix TM1:

1.    Extract the contents of SampleMD_TM1.zip into the server data directory of your TM1 installation.

2.    Restart your TM1 Admin Server.

Add the sample database to the Enterprise RTView Display Builder:

3.    Start the Display Builder.

By default, the Display Builder requires a login to support role based security. The default user name and password are:

•  User Name: admin
•  Password: admin

4.    Select Tools>Options to bring up the Application Options dialog.

5.    Select the OLAP tab and click Add Database.

6.    In the Add Database dialog, enter the following:
 

Name - SampleMD_TM1 Connection Type - Applix Java API User Name - the user name for your OLAP server Password - the password for your OLAP server TM1 Admin Host - the name of the host system for your TM1 Admin server TM1 Server Name - the name of your TM1 server

7.    Click OK to add the sample database and close the Add Database dialog.

8.    Click Apply to attempt to connect to the sample database. If the connection has been successful, SampleMD_TM1 will appear in the Databases field with a white background. If the background is yellow, the connection has failed.

9.    Click Save to apply and close the Application Options dialog.