Skip Headers
Previous
Previous
 
Next
Next

Build: Processing Options

The data processing options enable you to control dimension and cube maintenance.

Atomic Refresh: Controls whether the refreshed dimensions and cubes are committed to the database together in a single transaction or in individual transactions. Atomic refresh commits the changes in a single transaction so that either all of the objects are refreshed or none of them are. Select this option when you want to present a consistent view of the data to users during the refresh period, or when you want to roll back the entire refresh if an error occurs. When Atomic Refresh is deselected, each object that is refreshed successfully is immediately committed. An error later in the maintenance task does not affect these objects.

Refresh After Errors: Controls whether processing can continue after an error occurs. Deselect Atomic Refresh when selecting this option, so that each object is refreshed in a separate transaction. Otherwise, maintenance will continue after an error, but eventually the entire transaction is rolled back.

When Refresh After Errors is selected, an error causes the current transaction to roll back so that the object retains its old data. Objects that have already been refreshed are unaffected, and the refresh continues for any additional objects. For example, suppose the Global analytic workspace is being refreshed. The dimensions are refreshed first, then the Units Cube, and then the Price Cube. If an error occurs when refreshing the Units Cube, then only the Units Cube retains the old data. The maintenance task can continue and refresh the Price Cube.

When Refresh After Errors is deselected, an error causes the current transaction to roll back and halts the maintenance task so that no more objects are refreshed. In the previous example, the dimensions are refreshed, but both the Units Cube and the Price Cube retain the old data.