How to create an Analysis Services Processing task

To create an Analysis Services Processing task

1. Open DTS Designer:
   1. On your desktop click Start, point to Programs, point to Microsoft SQL Server, and then click Enterprise Manager.
      
      
   2. In the console tree, expand the server on which you want to create the Data Transformation Services (DTS) package that will contain the Analysis Services Processing task.
      
      
   3. Right-click the Data Transformation Services folder, and then click New Package.
2. In DTS Designer, from the Task toolbar, drag the icon for the Analysis Services Processing task onto the design sheet. This icon appears here.

   

3. (Optional.) In the Analysis Services Processing Task dialog box, in the Description box, type a task description.
   
   
4. (Optional.) To limit the tree to objects on the local Analysis server and set the task to process an object or objects on the server computer where the package is stored, select Local server. If you select this option, you can later migrate the package to another server computer and execute it to process an object or objects on that server computer. This processing requires that the other server computer stores the processed objects' meta data and has access to their data sources. Meta data can be copied easily from one server to another by using the Copy and Paste commands in the Analysis Manager tree pane.
   
   
5. In the Analysis Services Processing Task dialog box, expand the server tree, and then select the object or folder to process.
   
   
6. Select a processing option. Selecting an option determines the value of the ProcessOption property, which is used in Microsoft® ActiveX® Script tasks to modify processing options in Analysis Services Processing tasks.

   For more information about processing options, see Processing Cubes and Dimension Processing. For more information about valid values of the ProcessOption property, see Changing Properties of an Analysis Services Processing Task.

7. If you selected the Incremental update option for a partition or single-partition cube, you can:
   • Change the data source and fact table used for the incremental update. Click the edit (...) button beside the Fact table box and use the Choose a Fact Table dialog box.
     
     
   • Specify a filter to limit the fact table records used in the incremental update. Click the edit (...) button beside the Filter box and use the Filter Expression dialog box.

   Note  You must specify a filter if you select the default fact table. Otherwise, the cube or partition will contain duplicate, and therefore inaccurate, data.

   If you change the fact table, the new fact table must have the same structure and columns as the default fact table. You must also merge the new fact table with the default fact table after the incremental update is complete. For more information, see Fact Table Considerations When Merging Partitions.

8. Click OK to finish creating the task. To save the task in a DTS package in DTS Designer, on the Package menu, click Save. For information about the different ways you can save your package, see Saving a DTS Package.

See Also

ActiveX Script Task

Creating a Package with DTS Designer

Creating an Analysis Services Processing Task

Save DTS Package