15.7. Writeback Query Performance
As you learned in Chapter 12, with Analysis Services 2008 you can obtain improved writeback performance by enabling the MOLAP storage option when you enable writeback. When you perform cell writeback, Analysis Services writes data back to the relational table specified. In addition, the MOLAP partition associated with the writeback partition is reprocessed automatically. Because of this, all queries using the writeback partition will retrieve the data from the MOLAP storage rather than fetching the data from the relational table and then aggregating the data. Thus, using MOLAP storage for the writeback partition helps improve query performance. We recommend that you set MOLAP storage mode for the writeback partition when you enable the cube for cell writeback.
Get Professional Microsoft® SQL Server® Analysis Services 2008 with MDX now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
