Post reply

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

  • 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.

  • 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.

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply