Clever Geek Handbook

Automatic cube processing every 1 hour?

I am using Microsoft SQL 2008. In Microsoft Visual Studio I have created a cube. I want to schedule this cube to be processed every 1 hour. Can someone tell me how to achieve this?

Thank.

+3


source to share


1 answer


In the same solution with your SSAS project create a new SSIS project

  • In SSIS packages open the dtsx file
  • Go to Control Flow and select the Analysis Services processing task from the SSIS toolbar.
  • Add task to control flow
  • In Connection Manager, add a new Analysis Services connection and point it to the database cube.
  • Edit the SSAS processing task and go to process settings
  • Add the objects you want to execute.

I usually put two tasks for Analysis Services analysis - one for all dimensions and another for the whole cube -



Now connect to Intergration services in MSsQL management studio and add your project to packages.

Follow this link to see how you can schedule through the MsSQL agent an SSIS package.

And you're done!

+4


source






More articles:


All Articles