Export (0) Print
Expand All
Expand Minimize

Analysis Services Processing Task Dialog Box

SQL Server 2000

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.

Show:
© 2014 Microsoft