
Chapter 10. Historical reporting 381
Figure 10-2 TMTP Version 5.2 warehouse data model
After the central data warehouse ETL processes are complete, the data mart
ETL processes load data from the central data warehouse database into the data
mart database. In the data mart database, fact tables, dimension tables, and
helper tables are created in the BWM schema. Data from the central data
warehouse database are filled into these dimension and fact tables in the data
mart database. You can then use the hourly, daily, weekly, and monthly star
schemes of the dimension and fact tables to generate reports in the TEDW
report interface.
In addition, the ...