Business Intelligence Tutorial

Starting the Model Assistant

The first step in creating an OLAP model is to decide whether to use the OLAP Model interface, which offers full function, or the Model Assistant, which offers a simpler, guided approach. In this lesson, you will use the OLAP Model Assistant.

  1. Double-click the OLAP Model Assistant icon.
  2. You will be prompted to log on to the TBC database, which contains the source data. The Data Source window is displayed.
    Data Source screen
    Type the following values:

    Data Source
    The name of the DB2 database in which your business data is stored. This tutorial uses one of the sample databases shipped with DB2 Universal Database, which is called TBC.

    User Name
    The user ID you will use to access DB2 UDB. In the examples in this tutorial, the user ID is tbc.

    Password
    The password for the user ID entered in Username.
    Click OK, and the Select Fact Table page of the OLAP Model Assistant is displayed.


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