Connection

Home Directory

The Home Directory is the root directory on the server where indexes will be stored. A new directory corresponding to the name of the Fact Table (on the Facts and Dimensions panel) will be created within the Home Directory, and each index will be created within that. This means the full path to an index is given by:
HomeDirectory/FactTable/IndexValue

Pool

The Connection Pool used to connect to the database. It is the pool that holds the information about the JDBC connection along with any user name and password information required to establish a connection. You can use the browse button next to the Pool field to select a pool from the available pools that already exist on the server.

Schema (Optional)

Some databases group tables into schemas. If your database has a lot of tables, loading them all to populate the user interface can be slow. If you know the schema where your tables are defined, you can specify it here in order to reduce the number of tables loaded and therefore provide a more responsive display. If your database doesn't have hundreds of tables, or doesn't support schemas, then you can leave this field empty.

Timeout

The timeout option controls how long results will be cached. Because cube facts change infrequently, perhaps only daily, then the timeout can often be left at the default - Session. This means that if the same cube data is used later in the same logon session, then a cached copy will be used in order to reduce the database load and provide a faster response. Perhaps during testing, data is changing more frequently and you want to avoid having to log out and log in again to see changes. If so you can set the number of seconds for which the cache is valid. Setting the timeout value to 0 seconds means the values will always be loaded from the database.

Test Connection

This button allows you to test the driver, url, user and password information. The server will attempt a connection to the database with the supplied information and will show "Succeeded" or an error message on completion.