Business Intelligence Tutorial

Promoting the rest of the steps in the star schema (optional)

To create the rest of the tables in the star schema, you must promote the steps that you created in Defining the rest of the tables for the star schema (optional). 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 10, Scheduling warehouse processes.

To promote the steps, open the process that contains the steps, and follow the procedure in step 1 through 5. You do not have to test the steps as well. However, you can test the steps if you want to test them.

Promote the following steps:
Tutorial Process Tutorial Step Warehouse Database Target Table
Build Tutorial Product Dimension Tutorial Select Product TUTWHS LOOKUP_PRODUCT
Build Tutorial Time Dimension Tutorial Select Time TUTWHS LOOKUP_TIME
Build Tutorial Scenario Dimension Tutorial Select Scenario TUTWHS LOOKUP_SCENARIO
Build Tutorial Fact Table Tutorial Fact Table Join TUTWHS FACT_TABLE


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