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.