Business Intelligence Tutorial

Lesson 29. Exploring the rest of the Starter Kit

In this lesson, you will explore the OLAP Model, OLAP Metaoutline, and Administration Manager interfaces of the DB2 OLAP Integration Server.

Exploring the OLAP Model interface

In this exercise, you will open the TBC model in the OLAP model interface of the DB2 OLAP Integration Server.

1. Click File --> Open to display the Existing page of the Welcome window.
2. Select TBC Model in the field on the left side of the window, and click Open.
3. Answer the prompts for the Data Source, User Name, and Password. The Data Source is TBC.
4. The OLAP Model interface is displayed with the star schema shown on the right pane. Click View--> View all columns to expand the fact table and dimensions. You can move the rearrange the dimensions in the right pane with the mouse. The window looks something like this:
   
   
5. When you are finished, click File --> Close. Do not save changes.

Exploring the OLAP Metaoutline interface

In this exercise, you will open the TBC model in the OLAP Metaoutline interface of the DB2 OLAP Integration Server.

1. Click File --> Open to display the Existing page of the Welcome window.
2. Expand the tree view of TBC Model and select TBC Metaoutline. Click Open.
3. Answer the prompts for the Data Source, User Name, and Password. The Data Source is TBC.
4. The OLAP Metaoutline interface is displayed with the metaoutline shown on the right side of the window. The window looks something like this:
   
   
5. When you are finished, click File --> Close. Do not save changes.

Exploring the Administration Manager

In this exercise, you will examine the Administration Manager tool of the DB2 OLAP Integration Server.

1. Click Tools --> Administration Manager to display the Administration Manager.
2. Open the tree view in the left pane and click on Users. In this part of the Administration Manager, you can create new users and grant them access. The window looks something like this:
   
   
3. When you are finished, click File --> Close.
4. Click File --> Exit to exit the DB2 OLAP Integration Server.

What you just did

In this lesson, you explored the OLAP Model, OLAP Metaoutline, and Administration Manager interfaces of the DB2 OLAP Integration Server.