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

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.