Professional Microsoft® SQL Server® Analysis Services 2008 with MDX

21.2. Proactive Caching at Work

To demonstrate how proactive caching works, this section uses the sample Adventure Works Analysis Services project that comes with the product. You need to download and install the SQL2008. Adventure Works DW BI v2008.x86.msi sample database from http://www.codeplex.com/MSFTDBProdSamples/Release/ProjectReleases.aspx?ReleaseId=16040. The sample should be installed in the directory within your SQL Server installation (%SystemDrive%$\Program Files\Microsoft SQL Server\100\Tools\Samples\AdventureWorks 2008 Analysis Services Project\Enterprise). To understand proactive caching functionality, do the following:

1. Open the enterprise version of the sample Adventure WorksDW 2008 Analysis Services project. This Analysis Services project contains a cube called Adventure Works that has several measure groups and dimensions. The measure group ResellerSales retrieves the data from the relational table FactResellerSales. The data from the FactResellerSales table has been partitioned within Analysis Services so that the ResellerSales measure group has four partitions, one for each year. You will see the behavior of proactive caching by adding rows to the last partition of the FactResellerSales measure group.

2. Click the Partitions tab of the Adventure Works cube and expand the ResellerSales measure group. You will see the four partitions of the ResellerSales measure group as shown in Figure 21-4. If you click in the Source column for year 2004, you will be able to see ...