MSAS - Processing Dimensions and Cubes Page - 4

Process a cube

In the Analysis Manager tree pane, under the database that contains the cube, expand the Cubes folder.

Right-click the cube, and then click Process.

In the Process a Cube dialog box, click Full Process, and then click OK.

In the Process dialog box, wait for the cube to finish processing, or click Stop to halt and cancel processing.

After processing completes, the SQL statement used to process the cube can be viewed..

To view an SQL statement

In the Process dialog box, click a line beginning with the SQL icon.

Click View Details.

The time taken for the processing will depend on the size of the cube and the number of dimensions it has. Also, the storage required for temporary files during processing can be substantially larger than the final size of the cube. If during processing the free space of the disk containing the temporary file folder is exhausted, the user can specify a folder on another disk with more free space.

To change the temporary file folder used by Analysis Services

1. In the Analysis Manager tree pane, right-click the Analysis server for which you want to change the temporary file folder, and then click Properties.
2. Beside the Temporary file folder box, click Browse, select a new folder, and then click OK.

3. In the Properties dialog box, click OK.
4. The MSSQLServerOLAPService service must be stopped and restarted after this change..

Cube Properties for Processing

Some properties of a cube are used to control its processing. You can set these properties in the properties pane of Cube Editor or in the Cube Processing Settings dialog box, which is displayed when you click Settings in the Process a Cube dialog box. The following table describes these properties.

Processing Optimization Mode

Selection of ‘Regular’ in Cube Editor or ‘After all aggregations are calculated’ in the Cube Processing Settings dialog box, new cube data is not available until processing completes. These values are the defaults. If Lazy Aggregations is selected in Cube Editor or Immediately after data is loaded in the Cube Processing Settings dialog box, new cube data is available before processing completes; however, because the optimizations are not complete when the new data becomes available, query performance is reduced until the optimizations complete.

Stop Processing on Key Errors : Stop processing after encountering missing dimension key errors or Ignore all missing dimension key errors

If Yes is selected in Cube Editor or Stop processing after encountering missing dimension key errors in the Cube Processing Settings dialog box, processing is halted and canceled when the specified limit for the number of dimension key errors is exceeded. (See Key Error Limit.) A dimension key error occurs when a fact table row is encountered that contains a foreign key value not present in the joined primary key column of a dimension table. If No is selected in Cube Editor or Ignore all missing dimension key errors in the Cube Processing Settings dialog box, dimension key errors never halt and cancel cube processing regardless of the number of errors encountered. If one or more dimension key errors are encountered, the cube's data does not reflect the entire fact table.

Key Error Limit : Processing will stop after

This is the limit for the number of dimension key errors. Cube processing is halted and canceled when the limit is exceeded. The default is 0. If a higher number is selected and processing completes, the cube's data does not reflect the entire fact table. This property is ignored if No is selected for the Stop Processing on Key Errors property in Cube Editor, or Ignore all missing dimension key errors in the Cube Processing Settings dialog box is selected.

Key Error Log File : File path and name