Learning about basic dimension processing
You can process dimensions using SSMS processing dialog or XMLA script. Alternatively, you could use the ascmd.exe command line utility to schedule a dimension processing. While developing the solution, you could also process dimensions using SSDT.
Getting ready
Launch SSMS and connect to the existing AdventureWorks_Sample database, which has been previously deployed on your instance of Analysis Services. Expand the Dimensions folder within the current database.
How to do it...
To process a dimension, perform the following steps:
Right-click on any dimension and choose Process; doing so opens the Process Dimension dialog.
Choose any of the dimension processing options except
ProcessAdd. This option is not available in the dialog.Click on the Script button in the top-left corner of the dialog and choose Script Action to New Query Editor Window. The sample XMLA command for processing the Geography dimension is as follows:
<Batch xmlns = "http://schemas...
