Business Intelligence Tutorial

Defining the rest of the tables for the star schema (optional)

The table that you created in the previous section, LOOKUP_MARKET, is one of the dimension tables in the example in Tutorial business problem. This section covers the steps for building the rest of the dimension tables and the fact table in the star schema.

This section is optional, but if you do not complete the steps in this section, you will not be able to do the following lessons:

If you want to skip this section, go to Lesson 9, Testing warehouse steps.

When you define each table, you must define a new process for the table. Instead of defining your own step for the process, however, you will copy the step that is defined in the sample. The definition of the step is in the Data Warehouse Center that you are using. When you copy the step, the Data Warehouse Center copies the sources that the step uses and generates a target table.

To define the Product dimension table:

  1. Define a new process by following the steps in Defining a process. Name the process Build Tutorial Product Dimension.
  2. Under the Subject Areas folder in the Data Warehouse Center window, expand the TBC Sample tree until you see the Build Sample Product Dimension process.
  3. Right-click the Build Sample Product Dimension process.
  4. Click Open.

    The Process Model window opens.

  5. Right-click the Select Product step.
  6. Click Copy.

    The Copy Step window opens.

  7. In the Name field, type the name for the copy of the step:
    Tutorial Select Product
    
  8. In the New process field, select the name of the process to which you want to copy the step:
    Build Tutorial Product Dimension
    
  9. Verify that the Copy Target Table check box is selected.
  10. In the Warehouse target field, select the Tutorial Targets warehouse target from the list. The warehouse target will be the same for the fact table and each dimension table you define in this tutorial.
    The GEOGRAPHIES SELECT statement on the SQL Statement page.
  11. Click OK.

    The step and its sources are copied to the Build Tutorial Product Dimension process. The Data Warehouse Center generates the corresponding target table.

  12. Close the Process Model window.
  13. Open the Build Tutorial Product Dimension process by following the steps in Opening the process. If it is already open, close it, then open it again.
  14. Verify that the process includes the following objects:
  15. Rename the "SelectProd_T" target table to LOOKUP_PRODUCT.

    To rename the target table:

    1. In the Process Model window, right-click on the "SelectProd_T" target table.
    2. Click Properties.

      The table Properties window opens.

    3. In the Table name field, type:

      LOOKUP_PRODUCT
      
    4. Verify that the Part of an OLAP schema check box and Dimension table radio button are selected.
    5. Click OK to save your changes and close the table Properties window.

Repeat this procedure for the Time and Scenario dimension tables substituting the values in the following table where appropriate.
Dimension Tutorial Process Sample Process Sample Step to copy New Tutorial Step Name Source tables Target Table New Target Table Name
Time Build Tutorial Time Dimension Build Sample Time Dimension Select Time Tutorial Select Time TIME
"SelectTime
_T"


LOOKUP_
TIME

Scenario Build Tutorial Scenario Dimension Build Sample Scenario Dimension Select Scenario Tutorial Select Scenario SCENARIO
"SelectScen
_T"


LOOKUP_
SCENARIO

In the previous section, you defined the dimension tables in the star schema. In this section, you will define the fact table in the star schema.

To define the fact table:

  1. Define a new process by following the steps in Defining a process. Name the process Build Tutorial Fact Table.
  2. Under the Subject Areas folder in the Data Warehouse Center window, expand the TBC Sample tree until you see the Build Sample Fact Table process.
  3. Right-click the Build Sample Fact Table process.
  4. Click Open.

    The Process Model window opens.

  5. Right-click the Fact Table Join step.
  6. Click Copy.

    The Copy Step window opens.

  7. In the Name field, type the name for the copy of the step:
    Tutorial Fact Table Join
    
  8. In the New process field, select the name of the process to which you want to copy the step:
    Build Tutorial Fact Table
    
  9. Verify that the Copy Target Table check box is selected.
  10. In the Warehouse target field, select the Tutorial Targets warehouse target from the list.
  11. Click OK.

    The step and its sources are copied to the Build Tutorial Fact Table process. The Data Warehouse Center generates the corresponding target table.

  12. Close the Process Model window.
  13. Open the Build Tutorial Fact Table process by following the steps in Opening the process. If it is already open, close it, then open it again.
  14. Verify that the process includes the following objects:
  15. Rename the "FactTable_T" target table to FACT_TABLE.

    To rename the target table:

    1. In the Process Model window, right-click on the "FactTable_T" target table.
    2. Click Properties.

      The table Properties window opens.

    3. In the Table name field, type:

      FACT_TABLE
      
    4. Verify that Part of an OLAP schema check box and the Fact table radio button are selected.
    5. Click OK to save your changes and close the table Properties window.


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