Before you run DB2 OLAP Integration Server, you must create an OLAP Metadata Catalog to store the OLAP models that you create and the metaoutlines that you build from the OLAP models.
If you intend to use the sample application to learn DB2 OLAP Integration Server, skip to Chapter 10, Setting up the sample applications. The sample application has its own relational data source, OLAP Metadata Catalog, OLAP model, and metaoutline. Return to this chapter when you are ready to use a relational data source to build OLAP models and metaoutlines.
This chapter tells you what to consider before you create an OLAP Metadata Catalog in a relational database, either automatically, through the use of Essbase Integration Services Console, or manually. For manual creation of an OLAP Metadata Catalog, this chapter lists the SQL scripts you must run to create tables for the catalog. The procedures in this chapter assume that you know how to create a database using a relational database management system (RDBMS) and how to create tables by running SQL scripts.