Release Notes
To use the OLAP Starter Kit Desktop to create OLAP models and metaoutlines,
you must connect the client software to two server components: DB2 OLAP
Integration Server and DB2 OLAP Server. The login dialog prompts you
for the necessary information for the Desktop to connect to these two
servers. On the left side of the dialog, enter information about DB2
OLAP Integration Server. On the right side, enter information about DB2
OLAP Server.
To connect to DB2 OLAP Integration Server:
- Server: Enter the host name or IP address of your Integration
Server. If you have installed the Integration Server on the same
workstation as your desktop, then typical values are "localhost" or
"127.0.0.1".
- OLAP Metadata Catalog: When you connect to OLAP Integration Server
you must also specify a Metadata Catalog. OLAP Integration Server
stores information about the OLAP models and metaoutlines you create in a
relational database known as the Metadata Catalog. This relational
database must be registered for ODBC. The catalog database contains a
special set of relational tables that OLAP Integration Server
recognizes. On the login dialog, you can specify an Integration Server
and then expand the pull-down menu for the OLAP Metadata Catalog field to see
a list of the ODBC data source names known to the OLAP Integration
Server. Choose an ODBC database that contains the metadata catalog
tables.
- User Name and Password: OLAP Integration Server will connect to the
Metadata Catalog using the User name and password that you specify on this
panel. This is a login account that exists on the server (not the
client, unless the server and client are running on the same machine).
The user name must be the user who created the OLAP Metadata Catalog.
Otherwise, OLAP Integration Server will not find the relational tables in the
catalog database because the table schema names are different.
The DB2 OLAP Server information is optional, so the input fields on the
right side of the Login dialog may be left blank. However, some
operations in the Desktop and the Administration Manager require that you
connect to a DB2 OLAP Server. If you leave these fields blank, then the
Desktop will display the Login dialog again if the Integration Server needs to
connect to DB2 OLAP Server in order to complete an operation that you
requested. It is recommended that you always fill in the DB2 OLAP
Server fields on the Login dialog.
To connect to DB2 OLAP Server:
- Server: Enter the host name or IP address of your DB2 OLAP
Server. If you are running the OLAP Starter Kit, then your OLAP Server
and Integration Server are the same. If the Integration Server and OLAP
Server are installed on different hosts, then enter the host name or an IP
address that is defined on OLAP Integration Server.
- User Name and Password: OLAP Integration Server will connect to DB2
OLAP Server using the user name and password that you specify on this
panel. This user name and password must already be defined to the DB2
OLAP Server. OLAP Server manages its own user names and passwords
separately from the host operating system.
The following example assumes that you created the OLAP Sample, and you
selected db2admin as your administrator user ID, and
password as your administrator password during OLAP Starter Kit
installation.
- For OLAP Integration Server: Server is localhost, OLAP
Metadata Catalog is TBC_MD, User Name is db2admin,
Password is password
- For DB2 OLAP Server: Server is localhost, User Name is
db2admin
[ Top of Page | Previous Page | Next Page | Table of Contents | Index ]