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:
Click on the FactInternetSales table.
Click on the Partitions button in the designer:
In the Partition Manager dialog, change the name of the first partition to
FactInternetSales 2005 and Below.Click on the SQL button and change the query to the following:
SELECT [dbo].[FactInternetSales].* FROM [dbo].[FactInternetSales] WHERE [dbo].[FactInternetSales].[OrderDateKey] <='20051231'
Click on the New button and add a new partition named
FactInternetSales - Above 2005.Add the following query to the partition:
SELECT [dbo].[FactInternetSales].* FROM [dbo].[FactInternetSales] WHERE [dbo].[FactInternetSales].[OrderDateKey] >'20051231'
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...