使用SQL Server Agent 定时Process Dimension and Cube

所向无敌

　　Using SQL Server Agent to Process Dimension and Cube
　　
　　There are several ways to process Dimension and Cube; I will introduce how to use SQL Server Agent to process it.
　　1.       Create an Agent Job

　　2.       Give it a friendly name and turn to “ Steps” tab and Click new to create a new job

　　3.       Select Type as “SQL Server Analysis Command”  and input your SQL Server IP in right space

　　4.       Paste the XMLA command in the Command Area or open a xmla file.
　　5.       I will show you how to get XMLA command (File), Connect the SQL server analysis server then select the dimension you want to process, Right click process.

　　In the process box click the Script button.
　　6.       You will find the XMLAQuery Command, Copy it or Save it as a XMLA file

　　Paste the commands or import the XMLA file then click OK; you can use the same way to create another job (Process Cube)

　　7.       Now we need create a schedule to execute the job

　　8.       That’s all