Analysis Services Processing Task Dialog Box
Use this dialog box to add a Data Transformation Services (DTS) task that performs processing of one or more objects defined in Microsoft® SQL Server™ 2000 Analysis Services. For more information about using DTS tasks to automate processing, see Processing Objects Using Data Transformation Services.
This dialog box is displayed when you perform either of the following actions in DTS Designer:
- Drag the icon for the Analysis Services Processing task from the Task toolbar to the design sheet.
- Right-click an Analysis Services Processing task, and then click Properties.
Options
Name
View the task name.
Description
Specify a description for the task (optional).
Select the object to process
Select an object or folder to process.
Note If Analysis Manager is not installed on the system, you will be prompted to enter the name of an Analysis server. This is the name of the server, not its IP address.
| Object | Object icon | Processing includes |
|---|---|---|
| Database |  |
All cubes, partitions, virtual cubes, and dimensions in the database. |
| Cubes folder | All cubes and virtual cubes in the folder. | |
| Cube |  |
The selected cube. |
| Partition |  |
The selected partition. |
| Remote partition |  |
The selected remote partition. |
| Linked cube |  |
The selected linked cube. |
| Virtual cube |  |
The selected virtual cube. |
| Dimensions folder | All dimensions in the folder. | |
| Shared dimension |  |
The selected shared dimension. |
| Virtual dimension |  |
The selected virtual dimension. |
| Relational mining model |  |
The selected relational mining model. |
| OLAP mining model |  |
The selected OLAP mining model. |
Local server
Select this option to:
- Limit the objects in the Select the object to process box to those on the local Analysis server.
- Specify that the task processes an object or objects on the server computer where the package is stored.
If you select this option, you can later migrate the package to another instance of SQL Server and execute it to process an object or objects on that instance of SQL Server. This processing requires that the other instance of SQL Server stores the meta data for the processed objects and has access to their data sources. Meta data can be copied easily from one server to another by copying and pasting.
Select a processing option
Select a processing option for the object or folder you selected. The available options change according to the object type or folder you select.
Some objects and folders have only one available option. For more information about those with multiple options, see Processing Cubes, Incremental Updates and Partitions, and Dimension Processing.
Data source
View the data source for an incremental update of a cube or partition. You can change the data source by clicking the edit (...) button beside the Fact table box and using the Choose a Fact Table dialog box.
This option is displayed only when you select a single-partition cube or partition and Incremental update.
Fact table
View the fact table for an incremental update of a cube or partition. You can change the fact table by clicking the edit (...) button beside the Fact table box and using the Choose a Fact Table dialog box.
This option is displayed only if you select a single-partition cube or partition and Incremental update.
Filter
View the filter for an incremental update of a cube or partition. A filter limits the fact table records used in the incremental update. You can add or change a filter by clicking the edit (...) button beside the Filter box and using the Filter Expression dialog box.
This option is displayed only if you select a single-partition cube or partition and Incremental update.
Note You must specify a filter if you selected a single-partition cube or partition, Incremental update, and the default fact table. Otherwise, the cube or partition will contain duplicate and therefore inaccurate data.
OK
Click to add the task with the values you selected to the package and close the dialog box. (To save the task, you must save the package in DTS Designer.)
Cancel
Click to add the task with default values to the package and close the dialog box.