Optimizing Microsoft SQL Server Analysis Services: Optimization Tools: Incremental Update Wizard
6. Right-click in an empty area of the table view, and select Paste, as shown in Figure 9.
Figure 9: Right-click an Empty Area and Select Paste
The Paste Table As dialog appears.
7. Type the following into the Table Name text box:
8. Select the radio button to the left of the middle option, Structure and Data, in the Paste Options section of the Paste Table As dialog box.
The Paste Table As dialog appears as shown in Figure 10.
Figure 10: The Paste Table As Dialog with Settings
9. Click OK.
The PostAdditions table appears in the table view.
We will simulate, on a very small scale, the addition of a “new” balance to our cube — in a manner that will make it easy to see the effect on a total once we incrementally update the cube.
10. Double-click the PostAdditions table to open it.
11. Select the exp_date column by clicking its header.
12. Click the Ascending Sort button, to sort exp_date, as shown in Figure 11.
Figure 11: Sorting the exp_date Column
13. Select the top row appearing in the table, by clicking to its left, as shown in Figure 12.
Figure 12: Select the Top Row in the Table
14. SHIFT + SCROLL to the next-to-last populated row in the table, clicking again on the left side of the next-to-last populated row (ignore the bottom “zeros row.”) This should highlight all rows in the table, except the last populated row (and the “zeros row”), as shown in Figure 13.
Figure 13: Select All Except Last Populated Row and Bottom Empty Row