Introduction to MSSQL Server Analysis Services: Process Analysis Services Cubes with DTS - Page 4
May 9, 2005
We note that the radio buttons appearing within the Select a processing option section (to the right of the Select the object to process pane) change to reflect the Full process option only (the others are disabled). In like manner, the options change depending upon our selections, in a context-sensitive way.
14. Expand the Foodmart 2000 Analysis Services database.
The underlying Cubes, Dimensions, and Mining Models folders appear.
15. Click the Dimensions folder to highlight it.
The processing options again change, to reflect those that are available for the cube dimensions as a group. Our options now include Rebuild the dimension structure and Incremental update, as we noted in the tables above, and as is depicted in Illustration 7.
Click for larger image
16. Expand the Cubes folder.
The underlying Cubes for the FoodMart 2000 database appear.
17. Click the Warehouse cube to highlight it.
In addition to the corresponding change in the possible options (Full process, Refresh data, and Incrementally update dimensions) within the Select a processing option section, we note the appearance of a new object: the Cube Settings button appears as shown in Illustration 8.
18. Click the Cube Settings button.
The Cube Processing Settings dialog opens, revealing several options whereby we can establish recurring settings for cube processing. Our settings will be enforced anytime we process the cube or its partition(s). In effect, this is the same set of settings that we encounter from the Settings button in the standard Process a Cube dialog box, when we are manually processing a cube, as we have done in many articles of the Introduction to MSSQL Server Analysis Services series. Note that any settings we make here are stored, and override any previous processing settings made elsewhere.
The Cube Processing Settings dialog includes the setting options detailed in Table 3.
Table 3: Selection Options within the Cube Processing Settings Dialog
The Cube Processing Settings dialog appears (with default settings) as depicted in Illustration 9.
19. Click OK to close the Cube Processing Settings dialog, without making any changes.
We return to the Analysis Services Processing task dialog. We will leave the settings at default, which means Full process, among other default settings.
NOTE: Had we chosen Incremental update for a given partition of the Warehouse cube (it is a two-partition cube, as we have discussed in other articles of the series), we would have been able to change the data source and fact table under consideration. We would also have been offered an opportunity to establish a filter limiting fact table records to be included in the incremental update.
For an introduction to partitions within Analysis Services cubes, see my Database Journal article Partitioning a Cube in Analysis Services - An Introduction. For more information regarding incremental updates, see my article Performing Incremental Cube Updates - An Introduction.
20. Click OK on the Analysis Services Processing task dialog, to finish creating the new DTS task.
The Analysis Services Processing task dialog closes.
21. Select Package --> Save on the Package menu, as shown in Illustration 10.
The Save DTS package dialog appears.
22. Type the following into the Package name box of the Save DTS package dialog:
23. Leaving the other settings in the dialog at default, input the correct authentication information for your local environment.
The Save DTS package dialog appears, using my own local settings as an example, similar to those depicted in Illustration 11.
24. Click OK to save the package and to close the Save DTS package dialog.
We are returned to the design sheet.
25. Select Close, under the "hammer and table" icon, as shown in Illustration 12.
We are returned to Enterprise Manager. From this point, we will execute the DTS package that contains our new Analysis Services Processing task.