Automatically prosessing Analyses Services cube with SQL Server 2012

All Replies

• Sunday, February 03, 2013 5:29 AM

   

   
  

  0

  have you thought about creating a job in sql server agent then set a schedule for that ?.. if no this is an easy option, the following is a link that contains the steps to do so:

  http://sqlserverdiary.blogspot.com/2013/02/process-cube-using-sql-server-agent-job.html

  but in summary, you have to generate a script to process your cube then past that script in a job in sql server agent .. again the link contains step by step how to do it + screenshots.
  after you follow the steps in the URL, add schedule to the job ... hopefully you know how to do that, if not, please let us know  

  • Proposed As Answer by Elvis LongMicrosoft Contingent Staff, Moderator Monday, February 04, 2013 3:01 AM
  • Marked As Answer by Elvis LongMicrosoft Contingent Staff, Moderator Tuesday, February 12, 2013 3:20 PM
  •  
  • Reply
  • Quote

   
• Monday, February 04, 2013 3:01 AM

  Moderator

   

   
  

  0

  Hi Kenny,

  We have two options to process our cubes automatically:
  •SQL Server Agent
  SQL Server Agent is a Windows service that runs scheduled administrative tasks, or jobs. For example, you can create a job that processes a cube and then performs a backup of the cube. For more information, see Automating Administrative Tasks (SQL Server Agent).

  •SQL Server Integration Services
  SQL Server Integration Services is a platform that is used to build enterprise-level data integration and data transformation solutions. You can use an Integration Services package to automatically process cubes. The package that you create should include at least two Analysis Services Processing tasks. The first task should process the dimensions, and the second task should process the cubes. For more information, see the Analysis Services Processing Task topic and the Cube Processing discussion.

  For more information, please see:
  http://businessintelligenceheroes.blogspot.com/2010/01/how-to-automatic-process-ssas-cubes.html

  If you have any feedback on our support, please click here.

  Regards,

  ---

  Elvis Long
  TechNet Community Support

  

  • Marked As Answer by Elvis LongMicrosoft Contingent Staff, Moderator Tuesday, February 12, 2013 3:20 PM
  •  
  • Reply
  • Quote