Process a SQL Server Analysis Services Cube Using an XMLA Query

By: Ashish Kumar Mehta | Read Comments | Print Ashish has been contributing to the MSSQLTips.com community since 2009 with over 60 tips. Related Tips: More

Problem

One of the Junior DBAs in my company wanted to know how to process a cube using an XMLA Query. In this tip we will go through the steps a database administrator needs to follow to process an Analysis Services cube using an XMLA command.  

Solution

Let us go through the steps a database administrator needs to follow to process an Analysis Services cube using XMLA.

1. Connect to a SQL Server Analysis Services Instance using SQL Server Management Studio.

2. In the Object Explorer Pane, expand the Analysis Services Instance, expand Databases, expand Analysis Services database, and then right click the Analysis Services cube which you want to process and then choose New Query -> XMLA from the drop down menu to open a new XMLA Query window.

3. In the XMLA Query window copy and paste the below XML. You need to change the DatabaseID and CubeID appropriately as per your environment and then to do a Full Processing of the cube execute the XMLA Query.

4. You can also generate the XMLA Query to process the cube by selecting Script Action to New Query Window option under the Process Cube GUI as shown in the below snippet.  Refer to this tip for more information on how to get this this screen.

Note

When you run the XMLA query as shown in Step 3 this will process the cube with the default options. If you need to specify other options as shown in this tip,, you can select all of the options using the SSMS and then use the "Script Action to New Query Window" to see how all of these addtional options are configured in XML.

Next Steps

• Read Processing an Analysis Services Cube Using SQL Server Management Studio
• Read Configure Surface Area Configuration for SQL Server 2008 Analysis Services Using Policy Based Management
• Read How to Detach and Attach a SQL Server 2008 Analysis Services Database
• Review these other Analysis Services Tips

Related Tips: More | Become a paid author

Last Update: 1/20/2011

Share:

Share

Tweet

Connect with MSSQLTips.com Follow us on twitter... Let's connect on facebook! Join us on Google+

Comments and Feedback:

Post a Comment or Question

Keep it clean and stay on the subject or we may delete your comment.
Your email address is not published. Required fields are marked with an asterisk (*)

*Name

*Email

Notify for updates

Comments *** NOTE *** - If you want to include code from SQL Server Management Studio (SSMS) in your post, please copy the code from SSMS and paste the code into a text editor like NotePad before copying the code below to remove the SSMS formatting.
*Enter Code

 

Sponsor Information

Try the award winning SQL diagnostic manager as a free 14-day trial! It takes just 5 minutes to connect your SQL Databases to source control. Got 5 minutes? Get started now. Need SQL Server help and not sure where to turn? Reach out to the Edgewood consultants for a Health Check. Free Trial: Get Proactive Insight with Spotlight® for SQL Server Enterprise. Solving SQL Server problems for millions of DBAs and Devs since 2006. Join now. Free Learning - Introduction to SQL Azure Delivered by Herve Roggero on Wednesday, June 13 @ 3:00 PM EST