To access the Application Options dialog, in the Display Builder select Tools>Options.

Options specified in the OLAP tab can be saved in an initialization file (OPTIONS.ini). On startup, the initialization file is read by the Display Builder, Display Viewer, Display Server, Data Server and Historian to set initial values. If no directory has been specified for your initialization files and OPTIONS.ini is not found in the directory where you started the application, then Enterprise RTView will search under lib in your installation directory. NOTE: When you start an Enterprise RTView application from the Windows Start menu, it runs from the demos directory.  

NOTE: Options specified using command line arguments will override values set in initialization files.

OLAP
This tab allows you to add or remove your OLAP databases and set the default database. See OLAP Database Connection Setup for information on how to set up your database.

When you add a database to the list it will be highlighted in yellow indicating that it is not connected. To attempt to connect to a database, click OK, Apply or Save. If the background remains yellow, then Enterprise RTView was unable make a connection to your database. Check your database connection and see OLAP Database Connection Setup for information on how to set up your driver correctly. 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. NOTE: Regardless of which tab you are currently working from in the Application Options dialog, each time you click OK, Apply, or Save Enterprise RTView will attempt to connect to all unconnected databases.
 

Default Database - Name of database used as the default for data attachments. Select from drop down menu to change default setting.

Add Database - Click to open the Add Database dialog. To edit, select a database from the Databases list and double-click. Databases that are updating objects in a current display cannot be renamed.
 

Database Name - The name to use when referencing the OLAP database connection in your data attachments. This does not need to match the actual name of the database. Connection Type - Select ODBO to make an ODBO connection to this database. This will enable writing MDX queries against your SQL Server Analysis Services or Applix TM1 database in the Attach to OLAP Data dialog. Select Applix Java API to use the Applix Java API to connect to this database. This will allow you to use aliases in your queries and to attach to views in your Applix TM1 database, but will not allow you to write MDX queries in the Attach to OLAP Data dialog. This option is not supported for SQL Server Analysis Services databases. Switching between these options may invalidate existing data attachments to this database. In this case, you will need to recreate your data attachments. User Name - The user name to pass into this database when making a connection. This parameter is optional. Password - The password to pass into this database when making a connection. This parameter is optional. Use Client Credentials - If selected, the user name and password from the Enterprise RTView login will be used instead of the User Name and Password entered in the Add Database dialog. Connections to this database will only be made when you are running with login enabled and a display is opened that accesses this database.  As a result, this connection will not be made when you click OK or Apply in the Application Options dialog and will remain yellow. If you will be using the Data Server or the Display Server with a database connection that has this option enabled, you must enable Use Client Credentials for Database Login in these applications.  TM1 Admin Host - The name of the host machine for the TM1 Admin Server. NOTE: Only available if the Connection Type is Applix Java API.  TM1 Server Name - The name of the TM1 server to connect to. NOTE: Only available if the Connection Type is Applix Java API. Connection String - The OLE DB connection string to use to connect to this database. NOTE: Only available if Connection Type is ODBO. The syntax for this string varies by provider. Consult your OLAP database documentation to determine the OLE DB connection string for your OLAP provider.      Example Microsoft SQL Server Analysis Services Connection String:     Provider=MSOLAP;Location=MyServer;Database=SampleMD      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.

Remove Database - Select a database from the list and click Remove Database to delete. Databases that are updating objects in a current display cannot be removed.

Suppress Query Errors - Select to suppress errors generated by queries. Connection errors will still be shown.

Sample Databases
You must set up two sample databases that are used in demo displays located in demos\dstutorial, One database is for use with Microsoft SQL Server Analysis Services and the other is for use with Applix TM1.