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.
Expand the Foodmart
2000 Analysis Services database.
underlying Cubes, Dimensions, and Mining Models folders
Click the Dimensions
folder to highlight it.
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.
Expand the Cubes
underlying Cubes for the FoodMart 2000 database appear.
Click the Warehouse
cube to highlight it.
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.
Illustration 8: The Cube
Settings Button Appears
Click 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.
Processing Settings dialog includes
the setting options detailed in Table
Table 3: Selection Options within the Cube Processing Settings Dialog
Use This Setting to:
- After all aggregations are
(Default) Make data available for browsing
only after all aggregations have been accomplished.
- Immediately after data is loaded
available for browsing after it has been loaded, but before all aggregations
have been accomplished. (New data is available sooner for querying; a potential
cost is lessened responsiveness to query execution from the Analysis
Missing Dimension Key
- Stop processing after
encountering missing dimension key errors
processing if dimension key errors are encountered.
will stop after [Number]
can specify the number of errors after which processing is to stop.
- Ignore all missing
dimension key errors
regardless of dimension key errors.
Log dimension key errors
to a file
means of specifying a path to a text file.
Specify where file will reside, along with its name
navigate to a local or network location, for easy selection of a home for the
NOTE: Best practices dictate that the
path observe the Universal Naming Convention (UNC), as is the case in
Processing Settings dialog appears (with default settings) as depicted in Illustration
Illustration 9: The Cube
Processing Settings Dialog, with Defaults
to close the Cube Processing Settings dialog, without making any changes.
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.
on the Analysis Services Processing
task dialog, to finish creating the new DTS task.
Services Processing task dialog closes.
--> Save on the Package menu, as
shown in Illustration 10.
Illustration 10: Saving
the New Package, Containing Our Analysis Services Processing Task
DTS package dialog appears.
following into the Package name box of the Save DTS package dialog:
other settings in the dialog at default, input the correct authentication
information for your local environment.
DTS package dialog appears, using my own local settings as an example,
similar to those depicted in Illustration 11.
Illustration 11: Save
DTS Package Dialog, with My Local Settings
to save the package and to close the Save DTS package dialog.
returned to the design sheet.
under the "hammer and table" icon, as shown in Illustration 12.
Illustration 12: Select
Close to leave the DTS Design Environment
returned to Enterprise Manager. From this point, we will execute the DTS
package that contains our new Analysis Services Processing task.