Time for action – processing the data

Deployment will load metadata from an existing Analysis Services project into the SSAS Server, but it won't load data. To load data, another step is required, which is called processing. As there are different requirements to load data, there are multiple types of processing. Sometimes, you just need to populate the changes, but in some cases, such as populating dimensions, you want to populate everything again. In this example, we will go through the processing options by performing the following steps:

1. Open SQL Server Management Studio and connect to the Analysis Services instance.

2. Expand the Chapter 02 SSAS Multidimensional database, and then expand the dimensions.

3. Right-click on the Product dimension and click on Process.

4. In the Process window, you can change the process options to Clear. Click on the Clear option to process and then view the product dimension in the browser; you will see an error message that states that the dimension doesn't contain...