Using Tabular Models - SQL Server Analysis Services 2012 Cube Development - page 348

3. Your next step is to change the definition of the partition. Before we go any
further, delete the partition you just created. Highlight the Internet Sales
partition,and click on the SQL button above the table in the Partition Man-
ager dialog as shown in the following screenshot:
You should now see a window with the following SQL statement:
SELECT [dbo].[FactInternetSales].* FROM
[dbo].[FactInternetSales]
4. We will use this as our starting point. Our first partition will be the historical
partition. It will be for all orders that were placed prior to 2008. Our SQL state-
ment will now look like the following:
SELECT [dbo].[FactInternetSales].* FROM
[dbo].[FactInternetSales] where
OrderDateKey < 20080101
Note
The data in our Internet Sales fact table only includes data from July
1, 2005 through July 31, 2008. Orders from 2008 will be used to build the
additional partitions.