Advanced Cube Design - Professional SQL Server Analysis Services 2005 with MDX - page 458

Figure 9-61
8. Click the Specify a Query to Restrict Rows check box. Delete the de-
fault query that shows up in the query window and paste in the query
you previously saved. Edit the WHERE clause to limit partition data
to rows with OrderDateKey >= '1099' AND OrderDateKey <= '1280'.
9. Click Finish (you're storing your partition to the default location). In
the Name box, type Internet_Sales_2004b, click the Design Aggreg-
ations Later radio button, and then click Finish.
Naturally, you would want to design aggregations for your new partition, and
deploy and process it. In this case, you have learned how to use the partition
wizard for creating a new partition without duplicating data in the process.
Again, data duplication must be guarded against because it leads directly to
wrong results. The next section takes on the formidable and powerful remote
partition.
Building a Remote Partition
The basic architecture of the remote partition keeps data definitions
(metadata) in the cube on the master (or parent) machine and off-loads the