In-memory, the Future - Getting Started with SQL Server 2012 Cube Development - page 285

Working with partitions in tabular

models

Partitions are a crucial part of designing both tabular models as well as multi-dimen-
sional cubes. You can add partitions to your fact table by performing the following
steps:

1. Click on the FactInternetSales table.
2. Click on the Partitions button in the designer:

3. In the Partition Manager dialog, change the name of the first partition to
FactInternetSales 2005 and Below .
4. Click on the SQL button and change the query to the following:

SELECT [dbo].[FactInternetSales].* FROM
[dbo].[FactInternetSales]
WHERE
[dbo].[FactInternetSales].[OrderDateKey]
<='20051231'

5. Click on the New button and add a new partition named FactInter-
netSales - Above 2005 .
6. Add the following query to the partition:

SELECT [dbo].[FactInternetSales].* FROM
[dbo].[FactInternetSales]
WHERE
[dbo].[FactInternetSales].[OrderDateKey]
>'20051231'