Working with partitions in tabular models

Partitions are a crucial part of designing both tabular models as well as multi-dimensional 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 FactInternetSales - Above 2005.

6. Add the following query to the partition:

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

   

7. Click on the OK button and process and deploy your model.

One of the benefits with the tabular model when it comes to partitions is the fact that you have...