Microsoft SQL Server 2014 Business Intelligence Development: Beginner’s Guide

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 ...