Business Intelligence Tutorial

Lesson 23. Previewing and saving the OLAP Model

In this lesson, you will finish your OLAP model. You will look at a preview of the star schema you created and save the model in the database.

  1. The final window of the Model Assistant looks like this:
    Save Model page
  2. Click the Star Schema button to view the star schema. This shows how the fact table is joined with all the dimension tables.
    Preview Star Schema
  3. Click OK.
  4. Do not check the Launch the Metaoutline Assistant after Saving box. In the rest of this tutorial, you will create a metaoutline based on the sample OLAP model supplied with DB2 Universal Database, not the model you just created, because the sample model provides more detail. In the next lesson, you will launch the Metaoutline Assistant manually.
  5. Click Finish and then click Yes on the Save message. On the Save New OLAP Model page, you are prompted for a name for your model. Type My tutorial model and click OK.
    Save Model
    Your OLAP model is saved in the TBC database and the Integration Server desktop is displayed.


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