Considerations and Comments
For purposes of this
exercise, we will be working with the Warehouse cube, within the FoodMart
2000 MSAS database. The Warehouse cube, as most of us are aware, is
a member of a group of working samples that accompanies a typical installation
of Analysis Services. If the samples are not installed in, or have been
removed from, your environment, they can be obtained from the installation CD,
from the Analysis Services section of the Microsoft website, and perhaps
up the Analysis Services Processing Task within a DTS Package
Let's get started by setting
up the Analysis Services Processing task to process the Warehouse
cube. Once we have constructed the task, and then created a DTS package
to contain it, we will be ready to execute the task and to verify its
the Microsoft MSSQL Server Enterprise Manager shortcut in the Programs
group, as appropriate.
equivalent on my PC appears as shown in Illustration 1.
Manager from the menu.
Manager console opens.
Microsoft SQL Servers by clicking the "+" sign to its
immediate left, as required.
server upon which to create the DTS package that will house the Analysis Services Processing task. (I am choosing the Local server in my
Manager console appears similar to that depicted in Illustration 2.
Enterprise Manager (Compressed) View
the Data Transformation Services folder.
Package from the context menu that appears, as shown in Illustration 3.
Illustration 3: Select
New Package ...
Designer opens, presenting
a blank design sheet.
From the Task
toolbar, click / drag the Analysis Services Processing task onto the design sheet. The icon
appears circled in Illustration 4.
Illustration 4: Drag the
Analysis Services Processing Task Icon to the Design Sheet
drop the icon onto the design sheet, the Analysis Services Processing task dialog
appears, as partially depicted in Illustration 5.
Illustration 5: The
Analysis Services Processing Task Dialog Appears
Leaving the Name
box at default, replace the wording in the Description box of the Analysis Services Processing task with the following:
ANSYS035_Analysis Services Processing Task
Click the Local server checkbox
in the lower left corner of the dialog to "filter" the Select the
object to process pane to the local server only.
NOTE: If you chose a server other than
the Local server for this exercise, simply substitute the appropriate
server in the steps that follow.
other servers we saw, upon initial entry to the dialog, disappear, leaving the Select the object to process pane containing only the local
Click the "+"
sign to the left of the Local server to expand the server tree.
Services Processing task dialog appears, at this stage in our procedure, as
shown in Illustration 6.
Illustration 6: The Analysis
Services Processing Task Dialog, with Settings So Far ...
2000 Analysis Services database to highlight it.