Report off the Warehouse

In this section, we discuss reports which query the data warehouse database. In Should the Report Query a Table or a View? and Something is Missing from the Table or View we cover some challenges. In Create a Data Warehouse Version and Extend the Warehouse with a Table to Extend the Fact, we describe the creation of a report and data warehouse extension to report using a query which is similar to our OLTP version. In Create Another Data Warehouse Version and Extend the Data Warehouse with New Tables and Views, we describe a more tailored extension and report.