Business Intelligence Tutorial

Exporting the star schema

In this exercise, you will export the star schema for use in OLAP Integration Server.
Before you begin:Before you begin this section, you must have installed the OLAP Starter Kit, or the full DB2 OLAP Server product.

To export the star schema:

  1. From the Data Warehouse Center window, right-click the Warehouse icon.
  2. Click Export Metadata --> OLAP Integration Server.

    The Export Warehouse Schema notebook opens.

  3. From the Available warehouse schemas list, select Tutorial Schema.
  4. Click >.

    The Tutorial Schema moves to the Selected warehouse schemas list.

  5. Click the Integration Server tab.
  6. In the Catalog name field, type the name of the catalog for the Multidimensional analysis part of the tutorial:
    OLAPCATD
    
  7. In the Catalog table schema name field, type the schema name associated with the OM_INFO table.

    To find the name of the schema associated with the OM_INFO table:

    1. From the DB2 Control Center, expand the tree until you see the OLAPCATD database under Databases.
    2. Click on Tables and find the OM_INFO table in the Name column on the right. The schema associated with the OM_INFO table is visible in the Schema column.
    3. Return to the Export Warehouse Schema notebook and enter the schema name.
  8. In the Time dimension table field, select the LOOKUP_TIME table.

    You cannot change the dimension type after the schema is stored in the OLAP Integration Server catalog.

  9. In the User ID field, type the user ID under which you created the TBC_MD sample database. This is the user ID for the sample OLAP Integration Server catalog.
  10. In the Password field, type the password for the user ID. This is the password for the sample OLAP Integration Server catalog.
  11. In the Verify password field, type the password again.


    The GEOGRAPHIES SELECT statement on the SQL Statement page.

  12. Select Overwrite the existing model.
  13. Click OK to export the selected warehouse schemas to the OLAP Integration Server catalog.

    The notebook closes, and a progress indicator is displayed until the export is complete. When all the specified warehouse schemas are exported, the Export Information window opens, displaying success information or failure information about the export. Click Close to close this window.


[ Top of Page | Previous Page | Next Page | Table of Contents ]