Introduction to MSSQL Server Analysis Services: Process Analysis Services Cubes with DTS - Page 3

May 9, 2005

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 elsewhere.

Hands-On Procedure

Setting 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 operation.

1.  Click Start.

2.  Navigate to the Microsoft MSSQL Server Enterprise Manager shortcut in the Programs group, as appropriate.

The equivalent on my PC appears as shown in Illustration 1.

Click for larger image

Illustration 1: Navigating to the Enterprise Manager

3.  Select Enterprise Manager from the menu.

The Enterprise Manager console opens.

4.  Expand Microsoft SQL Servers by clicking the "+" sign to its immediate left, as required.

5.  Expand SQL Server Group.

6.  Expand the server upon which to create the DTS package that will house the Analysis Services Processing task. (I am choosing the Local server in my example.)

The Enterprise Manager console appears similar to that depicted in Illustration 2.

Illustration 2: Enterprise Manager (Compressed) View

7.  Right-click the Data Transformation Services folder.

8.  Select New Package from the context menu that appears, as shown in Illustration 3.

Illustration 3: Select New Package ...

DTS Designer opens, presenting a blank design sheet.

9.  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

When we 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

10.  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

11.  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.

Any other servers we saw, upon initial entry to the dialog, disappear, leaving the Select the object to process pane containing only the local server.

12.  Click the "+" sign to the left of the Local server to expand the server tree.

The Analysis 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 ...

13.  Click Foodmart 2000 Analysis Services database to highlight it.