OLAP Metadata Catalog

OLAP Metadata Catalog contains a collection of related tables. The tables provide a place for you to store OLAP models and metaoutlines. When you load members or data into an Essbase database, Integration Services retrieves the information stored in OLAP Metadata Catalog to determine:

What data to retrieve from the data source
What operations to perform on the data
How to load the data into the Essbase database

Regularly back up the database that contains OLAP Metadata Catalog so that you can restore OLAP Metadata Catalog from backups if it becomes corrupted. Use one of the procedures in Table 2, depending on what OLAP Metadata Catalog component you want to restore.

Caution!

It is strongly recommended that you do not alter the table names or data in OLAP Metadata Catalog with tools other than Integration Services.

Table 2. OLAP Metadata Catalog Restore Procedures

Component To Restore	Procedure
OLAP Metadata Catalog as you installed it, without any OLAP models or metaoutlines that you might have created	Run a script to create the database tables. See Creating, Upgrading, and Deleting OLAP Metadata Catalogs.
OLAP Metadata Catalog, including the OLAP models and metaoutlines that you have created	Restore the database that contains OLAP Metadata Catalog from backups. See the documentation for the data source.