O'Reilly logo

Smart Business Intelligence Solutions with Microsoft® SQL Server® 2008 by Kevin S. Goff Lynn Langit Davide Mauri, Sahil Malik, and John C. Welch

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required