0

What is the way in TSQL to run the XMLA code to process a cube

XMLA:

<Process xmlns="http://schemas.microsoft.com/analysisservices/2003/engine">
  <Object>
    <DatabaseID>Adventure Works DW</DatabaseID>
  </Object>
  <Type>ProcessFull</Type>
  <WriteBackTableCreation>UseExisting</WriteBackTableCreation>
</Process>
ob213
  • 494
  • 1
  • 8
  • 19

1 Answers1

0

I use this way:

  1. Create a new Job in SQL and put the XMLA statement in a SQL Server Analisys Services Command
  2. Execute this job from your sp with:

exec msdb.dbo.sp_start_job 'Job Name'

Luka Milani
  • 1,541
  • 14
  • 21