Examples

This example shows a point consolidation for a unit called Operations. In this case, the seven leaf units roll up directly to Operations, skipping the intermediate units Canada, US, and North America. Data is written back to only eight units.

Members of Total Company
	Total Company 
		Head Office
		Operations
			North America
				US
					New York
					Los Angeles
					US Eliminations
				Canada
					Toronto
					Vancouver
					Canadian Eliminations
				NA America Eliminations

Similarly, a point consolidation for this example rolls up the three leaf members directly to All Products skipping the intermediate member Stereo. Data is written back to only four products.

Members of All Products
	No Product
	All Products
		Stereo
			BW250
			BW1200 CD
			BW550 Portable

Combining the two examples, a consolidation with PointConsolidation set to 1 and SuppressLeafWriteBack set to 0 for Operations and All Products writes data back to 22 member combinations ([7 leaf units * 3 leaf products] + [1 point unit * 1 point product]). Data is written to point-only member combinations and leaf-only member combinations. No data is written to point-leaf member combinations or to intermediate members in any combination.


Unit	All Products (point)	BW250 (leaf)	BW1200 CD (leaf)	BW550 Portable (leaf)
Operations (point)	X
New York (leaf)		X	X	X
Los Angeles (leaf)		X	X	X
US Eliminations (leaf)		X	X	X
Toronto (leaf)		X	X	X
Vancouver (leaf)		X	X	X
Canadian Eliminations (leaf)		X	X	X
NA America Eliminations (leaf)		X	X	X
North America, US, Canada

Continuing with the same example, a consolidation with PointConsolidation set to 1 and SuppressLeafWriteBack set to 1 for Operations and All Products writes data back to only one member combination (1 point unit * 1 point product). Data is written only to the point-only member combination. No data is written to any other combination, as shown in this table:


Unit	All Products (point)	BW250 (leaf)	BW1200 CD (leaf)	BW550 Portable (leaf)	Stereo
Operations (point)	X
All other members