Optimizing Microsoft SQL Server Analysis Services: Optimization Tools: Incremental Update Wizard
11. Click Finish to complete the steps of the Incremental Update Wizard.
Processing begins, and runs rapidly, as evidenced by the Process viewer’s presentation of processing log events in real time (just as we see for Full Process operations). Processing ends rather quickly, and the success of the evolution is indicated by the appearance of the Incremental update completed successfully message (in green letters) at the bottom of the viewer, as shown in Figure 23.
Figure 23: The Incremental Update Completes Successfully
12. Click Close.
The Process Viewer closes, and we arrive at Analysis Manager once again.
Verify the Operation of the Incremental Update
In drawing our exercise to a close, let’s verify the results of our Incremental Update. This should be easy to do, in light of the fact that we know we only applied an added month, the final month (12) of the 1998 operating year, to a single account that we can also easily locate (Account 4400, the Lease Expense account in the chart of accounts used in the Budget cube, from which we cloned the IncrUpdate cube.)
Conveniently enough, we have a copy of our cube just before its Incremental Update — the Budget cube itself — which we can browse for a total Lease expense for the period (12-1998) under examination. We can then compare the balance we obtain there to the balance for Lease expense, for period 12 of 1998, for the IncrUpdate cube, and see that the difference between the two is the amount of the incremental addition we have performed.
Let’s perform a couple of quick browses at this point, to prove our understanding of the Incremental Update process.
1. Right-click the Budget sample cube.
2. Select Browse Data from the context menu that appears, as shown in Figure 24.
Figure 24: Select Browse Data from the Context Menu
The Cube Browser indicates that data is being retrieved, then populates the default view.
3. Click the Level02 heading for the row axis, and drag it into the dimension area above it to remove it from the grid, and to swap the Time dimension into the column axis.
4. Click the down arrow in the Account selector box.
The Account hierarchy appears under the selector box, allowing us to drill down on the hierarchy.
5. Expand All Account by clicking the “+” sign to its left.
6. Expand the Net Income level underneath All Account.
7. Expand the Total Expense level underneath Net Income.
The Account hierarchy in the expanded selector, with our ultimate target of the Lease member at the bottom, appears as depicted in Figure 25.
Figure 25: The Expanded Account Hierarchy
8. Click the Lease expense member (which equals Account 4400 in the Budget cube — and therefore in its clone, IncrUpdate) to select it in the selector.
The Cube Browser, with our changes reflected, appears as depicted in Figure 26.
Figure 26: The Cube Browser with Our Settings
9. Double-click 1998 in the row axis to drill down to Quarters.
The Quarters appear to the right of 1998.
10. Double-click Q4 to drill down to its constituent months.
We see the value of $ 20,117.95, for Month 12, 1998, appear, as shown in Figure 27.
Figure 27: The Balance for 12-1998 Lease Expense – Before Incremental Update.