Designing Real-Time Cubes - Professional SQL Server Analysis Services 2005 with MDX - page 942

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 installa-
tion (%SystemDrive%$\Program Files\Microsoft SQL Server\90\
Tools\Samples\AdventureWorks Analysis Services Project\Enterprise). To un-
derstand 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