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