Business Intelligence Tutorial

Lesson 17. Summary

Congratulations! You now have completed the Data warehousing part of the tutorial. In this tutorial, you defined a warehouse that contained dimension tables and a fact table for a star schema, as follows:

• You defined a warehouse database to contain the star schema.
• You viewed the source data that is supplied with the sample.
• You defined Data Warehouse Center security by defining a warehouse user and a warehouse group.
• You defined one of the dimension tables in the star schema, LOOKUP_MARKET, by defining warehouse sources for a source table and a source file, and then defining steps that moved the source data into the warehouse and that joined the tables.
• You copied the rest of the dimension tables and the fact table from the sample.
• You promoted the steps, tested them, and scheduled them.
• You defined primary and foreign keys on the tables in the star schema.
• You performed maintenance on the warehouse database to improve performance.
• You authorized users to the warehouse database.
• You published metadata to the information catalog, and enhanced the information catalog by associating a program with one of the objects.
• You defined the star schema to the Data Warehouse Center, and exported the star schema to OLAP Integration Server.

If you have the OLAP Starter Kit installed, your next step is to perform the Multidimensional data analysis part of this tutorial.