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

Updates

Remember the definition of ETL for OLAP cubes: For cubes (fact tables) adding new facts (rows to the fact table) is considered an update, and the cube will remain online and available for end-user queries while the new rows and aggregations (if any have been defined on the cube partition) are being added to the cube. If cube data (fact table row values) needs to be changed or deleted, that is a different type of operation.

As we saw in Chapter 6, SSIS includes a control flow task, the Analysis Services Processing task. This task incorporates all possible types of cube (measure group or even individual partition) and dimension update options. Figure 17-12 shows the task’s main configuration dialog box.

Figure 17-12. SSIS supports all types ...

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