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

5. Next, we want to rename this partition Internet Sales - History . Click
on OK , and the partition definition will be applied to the table.
6. You will notice that the data has not been refreshed. Navigate to MODEL |
Process Table … to reprocess the data. The rows processed have been de-
creased to around 30,000 and only include orders prior to 2008.
7. You will now add the next two partitions: Internet Sales - 6 Months
and Internet Sales - Current . Open the Partition Manager dialog
again. Now, we will copy the partition using the Copy button. Click on that
twice and two new partitions will be created: Internet Sales - History
Copy and Internet Sales - History Copy - Copy .
8. Click on either one, and we will modify it to become our six-month partition
by renaming it to Internet Sales - 6 Months and changing the Where
clause in the SQL Statement to the following:
Where OrderDate between 20080101 and
20080630
This will create a partition to cover the first six months of 2008.
9. Click on the unmodified copy and change its name to Internet Sales -
Current , and set its Where clause to:
Where OrderDate > 20080630
This will create the final partition for you, and you will now have three parti-
tions you can use to manage processing or data reloads.
10. Click on OK and reprocess the table.
Note
The last-processed information does not come from your development
model; it comes from the deployed model. To see accurate processing in-
formation from your development model, you will need to use Microsoft
SQL Server Management Studio . Right-click on the Internet Sales
table and select Partitions . This will open the Partitions dialog from the