Process a SSAS cube's dimension by a T-SQL query

• Gangadhara MS

  Hall of Fame

  Points: 3377

  More actions

  July 25, 2011 at 8:47 pm

  #244850

  Hi All,

  HI,

  I need to process a SSAS 2005 cube's (full one cube at a time)by a T-SQL query, using a SQL agent job and need to schedule to run everyday on SQL server 2005 enter.edition.

  How can this be done.

• happycat59

  One Orange Chip

  Points: 29389

  More actions

  July 26, 2011 at 11:31 pm

  #1358959

  Using T-SQL it is not so easy.

  However, since you are planning to use SQL Agent, why not just use the step type of "SQL Server Analysis Services Command". You can get the XMLA script required from Management Studio - right click on a cube, select process and the pop-up box has a button that you can use to save the script that would be used. This can be used in the SQL Agent job.