After you have completed the Integration Services installation process, you can choose to install either or both the OLAP Metadata Catalog and the standard sample application. The system first displays the OLAP Metadata Catalog Setup dialog box to enable automatic setup of the catalog (see Creating or upgrading the OLAP Metadata Catalog automatically). Whether or not you choose to create the OLAP Metadata Catalog automatically, you can choose to create the standard sample application automatically, after you finish creating the OLAP Metadata Catalog. You can create the standard sample application quickly and easily using the automatic feature. You are encouraged to use this convenient feature, but if you choose manual setup, see Setting up the standard sample application manually for detailed procedures.
Hybrid Analysis: If you plan to set up the sample application for Hybrid Analysis, you must follow the procedures in Setting up the Hybrid Analysis sample application.
To set up the standard sample application automatically:
Oracle OCI: If you are using Oracle OCI direct connection, be sure to prefix the Net Service Name or the Schema Name with "Oracle" by typing Oracle: and then the data source name.
The User Name text box displays the name, TBC (lowercase tbc for Informix). You must use this name to create the TBC standard sample application database.
DB2 OLAP Integration Server creates the necessary tables, loads the TBC sample data into the tables, and loads the sample OLAP model and metaoutline data into the OLAP Metadata Catalog.
If DB2 OLAP Integration Server detects that you are not currently connected to the OLAP Metadata Catalog in which to load the sample OLAP model and metaoutline data, the Login dialog box is displayed so that you can enter the information necessary to connect. After you close the Login dialog box and are returned to the Sample Application Setup dialog box, click Create again to initiate setup of the standard sample application.
If, after clicking Create, DB2 OLAP Integration Server detects either an existing sample data source or an existing sample OLAP model and metaoutline in the OLAP Metadata Catalog, you are prompted with the message that tables already exist in the database. Click OK to return to the Sample Application Setup dialog box to reenter information, or click Delete to delete the existing standard sample application data. If you click Delete, your existing OLAP Metadata Catalog sample OLAP models and metaoutlines will be deleted and replaced with the sample OLAP model and metaoutline for the current release.
After you have completed creation of the standard sample application, you are ready to begin working with Integration Services Console to create your own sample OLAP models and metaoutlines (see Starting Integration Services Console).