Mapping Example

For a hierarchy, the structure before transformation should be the same as the structure after transformation. The source structure and target structure should be the following:

NODENAME PARENT HIER_NAME ORDER IOBJNM VERSION

The following is the import format of an external hierarchy defined in an InfoObject:

NODENAME	Parent	HIER_NAME	Order
M1		ParentH1	0
M11	M1	ParentH1	2
M12	M1	ParentH1	2
M111	M11	ParentH1	3
M2		ParentH2	0
M21	M2	ParentH2	1
M211	M21	ParentH2	2
M3	M1	ParentH1	4
M3	M2	parentH2	4

After the transformation, the structure should be the same as the following structure. While writing the hierarchy in the above example to Planning and Consolidation, the resulting dimension is the following:

Member ID	ParentH1	Order1	ParentH2	Order2
M1		0
M11	M1	1
M12	M1	2
M111	M11	3
M2				0
M21			M2	1
M211			M21	2
M3	M1	4	M2	3