Effects of different combinations of Clear Values and Write Mode options

These examples show the effects of different combinations of Clear Values and Write Mode options on an import to a cube. The examples assume a cube that contains three products, one region, and their associated values. In each example, values for Product 1 and Product 2 are imported.

Cube definition

This table shows the structure of the cube and its existing values.

Product Region1
Product 1 100
Product 2 300
Product 3 500

Import values

This table shows the values to be imported in each example.

Product Region Value to import
Product 1 Region 1 10
Product 1 Region 1 5
Product 2 Region 1 60
Product 2 Region 1 12

Add, no clearing

This table shows the effect of the import when the write mode is Add and no area of the cube is cleared.

Product Region 1
Product 1 115
Product 2 372
Product 3 500

Overwrite, no clearing

This table shows the effect of the import when the write mode is Overwrite and no area of the cube is cleared.

Product Region 1
Product 1 5
Product 2 12
Product 3 500

Add, clear all

This table shows the effect of the import when the write mode is Add and the entire cube area is cleared.

Product Region 1
Product 1 15
Product 2 72
Product 3 0

Overwrite, clear all

This table shows the effect of the import when the write mode is Overwrite and the entire cube area is cleared.

Product Region 1
Product 1 5
Product 2 12
Product 3 0

Add, clear Product 2 for Region 1

This table shows the effect of the import when the write mode is Add and the area of the cube for Product 2 in Region 1 is cleared.

Product Region 1
Product 1 115
Product 2 72
Product 3 500

Overwrite, clear Product 2 for Region 1

This table shows the effect of the import when the write mode is Overwrite and the area of the cube for Product 2 in Region 1 is cleared.

Product Region 1
Product 1 5
Product 2 12
Product 3 500