Loading OLAP Cubes

If you’ve been reading this book sequentially, you’ll remember that we strongly advised in the section on SSAS OLAP cube design that you create an empty destination star schema structure for each OLAP cube. We further recommended that you base this star schema on grain statements that are directly traceable to business requirements. We assume that you’ve followed these recommended practices and we base our recommendations for initial ETL around this modeling core. That said, the first consideration for initial load is appropriate assessment of source data quality. We cannot overemphasize the importance of this task. Too often we’ve been called in to fix failed or stalled BI projects, and one root cause of these situations is ...

Get Smart Business Intelligence Solutions with Microsoft® SQL Server® 2008 now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.