Deploying and Processing Cubes - Getting Started with SQL Server 2012 Cube Development - page 105

--Query 4.4
WHERE
[dbo].[FactInternetSales].[OrderDateKey]
BETWEEN '20060101' AND '20061231'

12. Click on Next and then on Next again.
13. Name the partition as FactInternetSales2006 and click on Design ag-
gregations later and then click on Finish .
14. Perform the steps again for the following partitions:

The WHERE clause

Partition Name

FactInternetSales2007 WHERE

[dbo].[FactInternetSales].[OrderDateKey]
BETWEEN '20070101' AND '20071231'

FactInternetSales2008 WHERE

[dbo].[FactInternetSales].[OrderDateKey]
BETWEEN '20080101' AND '20081231'

FactInternetSales2009andAbove WHERE
[dbo].[FactInternetSales].[OrderDateKey]
>= '20090101'

15. Right-click on the FirstCube database and process the database.