Mapping values from one module to another.

Ni363646

Hi,

 

I have 2 module where I want to map a line item from module M1 To M2. M1 module contain a list of level6, Time, version, while M2 is consist of a list of level7, Time, verion. The problem is that Value of line item is easily mapped to The Child of Level6 in M2.

 

Example: Let hierarchy be

Level 6 (Parent)	Level7(Child)
P1	P10
P1	P11
P1	P12
P2	P20
P2	P21
P2	P22

 

Case Of M1

Line item1	Actual
	17-Jan	17-Feb
P1	100	150
P2	200	100
P3	150	50

Case of M2 What I am getting is:

Line item1	Actual
	17-Jan	17-Feb
P1	300	450
p10	100	150
p11	100	150
P12	100	150
P2	600	300
P20	200	100
P21	200	100
P22	200	100
P3	450	150
P30	150	50
P31	150	50
P32	150	50

But i want is:

Line item1	Actual
	17-Jan	17-Feb
P1	100	150
p10	0	0
p11	0	0
P12	0	0
P2	200	100
P20	0	0
P21	0	0
P22	0	0
P3	150	50
P30	0	0
P31	0	0
P32	0	0

 I have tried changing the lineitem summary level to average but it is not giving me desired results.

 

What I can not change is the hierrachiy level in any case. Please, help If the solution is possible.

 

Regards,

Nitika

Ni363646

Hi Usman,

 

Thanks fro the response!!

 

The situation here can be as Top to bottom approach. But I do not want to divide values to child level I just want the value to enter on the same level and childs to show (0).

Please let me know if the concept is clear.

 

 

Regards,

Nitika