Upgrading Tables in the OLAP Metadata Catalog

To upgrade an OLAP Metadata Catalog manually, you upgrade the tables of the OLAP Metadata Catalog database.

  To upgrade tables for the OLAP Metadata Catalog database:

  1. Start the utility program.

  2. Connect to the database that you created for the OLAP Metadata Catalog as the user who created the original OLAP Metadata Catalog tables.

  3. Open the appropriate SQL script file in the ocscript directory.

    See SQL Scripts Used to Create and Upgrade Tables.

  4. Run the SQL script (or scripts, if applicable) to upgrade the tables.

    See Proper Order of SQL Scripts.

    On Microsoft SQL Server, you receive a message that you did not create data or rows. This message is normal because you created only tables and columns.

  5. Verify that the new tables have been added to the existing OLAP Metadata Catalog.

    You can verify this by entering a command, for example:

    SELECT * FROM OM_DESCRIPTION

    or, you can start the applicable RDBMS utility program and verify that the OLAP Metadata Catalog has the new tables.

  6. Close the utility program.