Database Reference
In-Depth Information
Scheduling processing
Most processing in production environments will be executed as scheduled jobs.
This can either be done through scheduling a
SQL Server Integration Service
(
SSIS
) package that contains an Analysis Services Processing Task, or it can be
done through scheduling a processing task through PowerShell.
Tip
More information about the tools available for processing can be found in the
Choose a Tool or Approach for Processing Analysis Services Objects article
available at
http://msdn.microsoft.com/en-us/library/aa337509.aspx
.
Building a SSIS package to control processing
To schedule processing of a cube, follow these steps:
1. Open
SQL Server Data Tools
.
2. Click on the
File
menu, choose
New Project
.
3. Click on the
Integration Services
template and choose
Integration Ser-
vices Project
.
4. Type
ProcessFirstCube
in
Name:
.
5. Under
Solution:
, choose
Add to solution
and click on
OK
.
Search WWH ::
Custom Search