SSAS: Scripting out a Process command

image I had a comment recently on one of my older posts (which was about processing a cube with XMLA) asking how I scripted out the process command from SQL Server Management Studio. It is much easier to explain this with pictures than with words alone, hence this post.

If you right click on an object in the object browser in management studio and click on the process option you will get a dialog box like the one below.

 

 

image

This dialog has a "Script" button at the top, like many of the dialogs in Management Studio.

image

Clicking on the button itself will script the action to a new query window or you can click on the drop down arrow next to this button to get a list of other possible places to send the script to.

Print | posted on Sunday, July 27, 2008 9:49 PM

Comments on this post

# SQL server 2008 Analysis services study Case

Requesting Gravatar...
how many Customer buy category A product and also buy Category B product

following your advice but stilll not work for Analysis services Browser
Please help.

SELECT

{[Product].[Products].[Category]} on COLUMNS,
{[Product].[Category]} on ROWS

FROM [MyCube]

WHERE

[Measures].[Distinct Customers]
Left by Summer_j_yang@Yahoo.com on Oct 22, 2008 4:23 AM

# re: SSAS: Scripting out a Process command

Requesting Gravatar...
I'm not sure which particular advice you are talking about. I can't see how your question relates to this post.
Left by Darren Gosbell on Oct 22, 2008 8:07 PM

# re: SSAS: Scripting out a Process command

Requesting Gravatar...
Nice post,

thanks for explaining using pictures, this is so helpful...

Anyway, thanks for the post
Left by software development on Oct 13, 2009 9:25 PM

Your comment:

 (will show your gravatar)