question

Raj More avatar image
Raj More asked

Batch Separation in XMLA

The T-SQL batch separation keyword is GO

Is there a similar thing for XMLA?

I am scripting out many partitions and aggregations using XMLA scripts. Running them one at a time is time consuming so I'm wondering how I can separate them using something like GO and run the whole script at one time.

ssascubesxmla
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

1 Answer

·
sp_lock avatar image
sp_lock answered

Within your XML you can create a <batch transaction/> element that will then be used when executing.

http://technet.microsoft.com/en-us/library/ms186692.aspx

10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.