Professional SQL Server™ Analysis Services 2005 with MDX

18.2. Proactive Caching at Work

In order to demonstrate how proactive caching works, this section also uses the sample Adventure Works Analysis Services project that comes with the product. The sample is located in the directory within your SQL Server installation (%SystemDrive%$\Program Files\Microsoft SQL Server\90\ Tools\Samples\AdventureWorks Analysis Services Project\Enterprise). To understand proactive caching functionality, do the following:

1. Open the sample "Adventure Works" 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 18-4. If you click in the Source column for year 2004, you will be able to see the SQL query that restricts the data for that year (OrderDateKey > 915 and OrderDateKey < 1280).

   Figure 18.4. Figure 18-4

   From here, we'll delete some rows from the ResellerSales table and do a bulk insert of these rows ...