Learn more about SQL Server tools

mssqltips logo
 

Tutorials          DBA          Dev          BI          Career          Categories          Webcasts          Scripts          Today's Tip          Join

Tutorials      DBA      Dev      BI      Categories      Webcasts

DBA    Dev    BI    Categories

 

Processing an Analysis Services Cube Using SQL Server Management Studio


By:   |   Last Updated: 2011-01-07   |   Comments (3)   |   Related Tips: > Analysis Services Administration

Problem

One of the Junior DBA in my company who is new to SQL Server Analysis Services approached me yesterday with a dilemma. He wanted to know how to process a cube Using SQL Server Management Studio. In this tip we will go through the steps which a database administrator needs to follow to process an Analysis Services cube using SQL Server Management Studio.

Solution

Let us go through the steps which a database administrator needs to follow to process an Analysis Services cube using SQL Server Management Studio.

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

2. In the Object Explorer Pane, expand the Analysis Services Instance, expand Databases and then expand the Analysis Services database that contains the cube which needs to be processed.

3. Right click the cube to be processed and then click the Process option from the drop down list as shown in the snippet below.

the steps which a database administrator needs to follow to process an Analysis Services cube using SQL Server Management Studio.

4. In the Process Cube dialog box, in the Process Options column under Object list, verify that the Process Full option is selected for the column as highlighted in the below snippet. If it is not selected, then under Process Options click the option and then select Process Full from the drop down list as shown in the below snippet.

5. To verify settings for the processing batch you need to click the Change Settings button in the Process Cube dialog box as shown in the snippet below. The settings you specify in the Change Settings dialog box will override the default settings inherited from the Analysis Services database for all the objects listed in the Process dialog box.

the settings you specify in the Change Settings dialog box will override the default settings inherited from the Analysis Services database for all the objects listed in the Process dialog box

In the Processing Options tab, shown below, there are different processing options available:

  • Parallel: - Use this option to process all the objects in a single transaction.
  • Sequential: - Use this option to process the objects sequentially.
  • Writeback Table Option: - Choose the option which can be used to manage a Writeback table. There are three options available Create, Create always and Use existing
  • Affected Objects: - Processing affected objects will process all the objects that have a dependency on the selected objects.

processing options available

6. In the Dimension Key Errors tab under change settings you will be able to use either a default error configuration or a custom error configuration. Click OK to save the changes and to return to the Process Cube dialog box.

these settings apply to the entire processing batch

7. Finally to Process the Cube click OK in the Process Cube dialog box. Once the Cube Processing has completed successfully click the Close button in Process Progress dialog box to complete the cube processing.

process the cube

Next Steps


Last Updated: 2011-01-07


get scripts

next tip button



About the author
MSSQLTips author Ashish Kumar Mehta Ashish Kumar Mehta has been contributing to the MSSQLTips.com community since 2009 with over 60 tips.

View all my tips




Post a comment or let the author know this tip helped.

All comments are reviewed, so stay on subject or we may delete your comment. Note: your email address is not published. Required fields are marked with an asterisk (*).

*Name    *Email    Email me updates 


Signup for our newsletter
 I agree by submitting my data to receive communications, account updates and/or special offers about SQL Server from MSSQLTips and/or its Sponsors. I have read the privacy statement and understand I may unsubscribe at any time.



    



Monday, September 21, 2015 - 6:55:56 PM - dvp r Back To Top

How to setup a cube processing job with ignore all errors ?

the XMLA code I get by clicking on the script , whn i put it in sql agnet job it fails after 2 seonds.


Tuesday, December 06, 2011 - 8:20:56 AM - surya Back To Top

i create a report in ssrs. which taking data from analysis service.but when cube under process and user try to view report error shoud be display in report viewer of ssrs. please help me.


Friday, January 07, 2011 - 5:23:24 AM - Wilfred van Dijk Back To Top

You said "Parallel: - Use this option to process all the objects in a single transaction" but to my opinion this is not the correct explanation. If you enable this flag, processing is done in parallel instead of sequential. The total processing time will be shorter, at a cost of high CPU utilization during the process.  Check Task manager and the directory where SSAS stores its tempfiles!


Learn more about SQL Server tools