DB2 OLAP Integration Server provides a sample application that consists of the following features:
Preparing the sample application consists of three tasks:
You can set up the standard sample application automatically using Integration Services Console (see Setting up the standard sample application automatically), or you can set up the standard sample application manually (Setting up the standard sample application manually. Using either method, setting up the standard sample application involves two main tasks:
When you finish setting up the standard sample application, the OLAP Metadata Catalog database (TBC_MD) will contain an OLAP model (TBC Model) and a metaoutline (TBC Metaoutline) based on data in the sample TBC relational data source.
You create the Hybrid Analysis sample application manually by completing the tasks in Setting up the Hybrid Analysis sample application. Upon completion of these tasks, the sample TBC relational data source will contain Hybrid Analysis data. The OLAP Metadata Catalog will contain an OLAP model and metaoutline enabled for Hybrid Analysis (HA TBC Model and HA TBC Metaoutline, respectively).
This chapter tells you what to consider before and after you set up the standard sample application, whether automatically or manually. For manual setup, the topics in this chapter detail which scripts and batch files you must run to create and load the TBC database and the TBC_MD OLAP Metadata Catalog.
The procedures in this chapter assume that you know how to create a database using a relational database management system (RDBMS). For manual setup, the procedures assume that you know how to create tables and load them with data running SQL scripts, batch files, and shell scripts. For information on these topics, see the documentation for the RDBMS that you are using.
This chapter contains the following topics: