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.


Feedback

#  SQL server 2008 Analysis services study Case

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]
10/22/2008 4:23 AM | Summer_j_yang@Yahoo.com

# re: SSAS: Scripting out a Process command

I'm not sure which particular advice you are talking about. I can't see how your question relates to this post. 10/22/2008 8:07 PM | Darren Gosbell

# re: SSAS: Scripting out a Process command

Nice post,

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

Anyway, thanks for the post 10/13/2009 9:25 PM | software development

Post a comment





 

 

News

About Me
I am a consultant, based in Melbourne Australia. I primarily work in the Business Intelligence area with SQL Server, although I also dabble in Content Management Server and .Net coding

Contact Me

MVP


Legal
Any and all code, software, examples, suggestions and anything else on this web site is available for you to use at your own risk. No warranty is expressed or implied.
Views and Opinions
The views and opinions expressed on this web site are not necessarily the views or opinions of my employer.

Subscribe in Bloglines Subscribe in NewsGator Online

Locations of visitors to this page

Twitter












Tag Cloud


Article Categories

Archives

Post Categories

.Net Blogs

Aussie Bloggers

BI Blogs

CMS Blogs

Syndication: