Microsoft® SQL Server 2012 Unleashed

Populating the Cube with Data

Now you can process actual data into your cube from the data source view. To do so, you right-click the Comp Sales cube entry in the Solution Explorer and choose the Process item or choose the Process icon for the cube in the cube designer (second icon from the left in the cube designer). A Process Cube dialog appears, with the object list of available cubes to process. You select the Comp Sales cube (by highlighting it) and then click the Run button to start the processing of data (see Figure 53.38). You can also see in Figure 53.38 that the Process Option defaults to Process Full. Other options here vary depending on what part of the cube needs to be reprocessed (such as when you have structure changes, data refreshes, ...