Analysis Services Parallel Processing Utility

This utility processes cubes, partitions, and dimensions in Analysis Services databases on local or remote servers. It includes two executable files, ParallelProcess.exe and ProcessPartition.exe. ParallelProcess.exe is a Microsoft® Windows® program that enables a user to specify and Process multiple cubes, partitions, and dimensions on a server. Unlike Microsoft SQL Server™ 2000 Analysis Manager, this program executes its requests in parallel. ParallelProcess.exe calls the auxiliary executable file, ProcessPartition.exe, to do the actual processing of cubes, partitions, and dimensions. You can also run ProcessPartition.exe from a command prompt or in a Batch file to specify and process a cube, Partition, or dimension. The processing performed by ProcessPartition.exe is recorded in log files.

The Parallel Process Utility requires SQL Server 2000 Analysis Services and Microsoft Visual Basic® 6.0 (optional, to work with the source code).