How automatically process a Cube periodically

How automatically process a Cube periodically

• Discodave

  In BI Development Studio, create a new SSIS task. In the Control Flow tab, first add a connection manager for your Analysis Services database (bottom tab, right-click), then drag an Analysis Services Processing Task from the toolbar on the left (the tab may be minimized). In the task, set which objects you want processed.
  
  Save locally, and then go to the file menu and do a Save a copy of... And save it to your SQL Server database that Analysis Services is sitting on.
  
  Go to Management studio and connect to the database (not Analysis Services). Go to the SQL Server Agent and right-click on jobs. Add a new job. In the job type, select SSIS job, select the SSIS package that you just created, and voila! You have a job on the database that you can now set to occur periodically.
  
  It's a little confusing at first, but once it gets going, it's pretty simple. After your first one, you'll probably want to go back and add logging, too...
  
  -Doug
  
  

• FishBlub

  Many options are available. Two immediately come to mind. Both involve scripting. When you have the processing dialog box open (just before you process) you will notice a box at the top that says "Script". It will take whatever you are about to do for processing and create an XMLA script a background window.

  Once you have the script then:

  1) Create a SQL Agent job and a step within it. There is a new option in the step that allows it to run an Analysis Services Command -- this is the XMLA script that you created above. Simply paste it into the step and then schedule the SQL Agent job as needed.

  2) Create an SSIS package and select an Analysis Services Execute DDL task. Insert the XMLA script into it and it will execute it as a step in the SSIS package.

  Alternatively, you could create an SSIS package and use the Analsyis Services Processing task and specify what object you wish to process. That works well also.

  Finally, coming in WR2 of the Samples MSI in April will be a new utility called ascmd (which is patterened after sqlcmd) that allows you to execute XMLA scripts (and MDX queries) from the command line. If you are interested in getting a pre-release version of it, contact me (dwickert@microsoft.com) and I will point you to the right folks.

  Hope that helps.

  _-_-_ Dave

  
  
  

• Garethvdl

  Hi.

  Thanks, DWBI_Doug! Worked perfectly!

  Regards

  Kjetil

  
  

• Siebe

  I success in the creation of the SSIS task, but when i go to Sql Server, I can't find my file an I can't had or browse to find it, could you help me

  Thanks

  
  

• Ken H

  You can use SQL Server Integration Services (search for Processing Objects Using Integration Services in BOL), or you could also Analysis Managment Objects (AMO).
  
  
  

• ray fitzh

  Titou wrote:

  I see this in another article, but I don't found Analysis Services Processing Task. Is it install with sql server 2005 or not Do you have an example that I can see, please or some indications Thanks,

  I forgot to note that i work with sql server and analysis services 2005

  
  

• DaveC426913

  Thank You DWBI_Doug, You saved my day. i ow you one.

  
  

• Microogle

  I see this in another article, but I don't found Analysis Services Processing Task.

  Is it install with sql server 2005 or not

  Do you have an example that I can see, please or some indications

   

  Thanks,

   

  
  
• How automatically process a Cube periodically