Mapping values from one module to another.

New Contributor

Mapping values from one module to another.

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)
P1P10
P1P11
P1P12
P2P20
P2P21
P2P22

 

Case Of M1

Line item1Actual 
 17-Jan17-Feb
P1100150
P2200100
P315050

Case of M2 What I am getting is:

Line item1Actual 
 17-Jan17-Feb
P1300450
p10100150
p11100150
P12100150
P2600300
P20200100
P21200100
P22200100
P3450150
P3015050
P3115050
P3215050

But i want is:

Line item1Actual 
 17-Jan17-Feb
P1100150
p1000
p1100
P1200
P2200100
P2000
P2100
P2200
P315050
P3000
P3100
P3200

 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

Message 1 of 4
3 REPLIES 3
Community Boss

Re: Mapping values from one module to another.

Hi Nikita, 

 

Does the Value come bottom up from Level 7 to Level 6 or does the value come top down from Level 6 to Level 7.

Because you can map top down with a one to many relationship but mapping many to one bottom up that isn't a sum of the values isn't really possible for the case you're trying to achieve, unless it is actually an average. 

 

I look forward to your response. 

 

Thanks,

 

Usman

Message 2 of 4
New Contributor

Re: Mapping values from one module to another.

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

Message 3 of 4
Community Boss

Re: Mapping values from one module to another.

Hi Nitika, 

 

Yes it is possible to do this but the child item will show the top level value not 0 but then in the module dimensioned by the child level the top level will be able to show as the same value as the child value. 

 

To do this create a module dimensioned by the top level list. Then create a line item and enter the values (blue for input data no calculations). Then create a module dimensioned by the child level list with a line item that looks up the parent such as parentlookup and format this by the list of the top level and the formula will be PARENT(ITEM( 'The name of the child level list goes here')) Then create another line item to bring in the value from the top level dimensioned module. The formula for this line item will then point to the value input from the top level module and lookup the parent lookup line item. Such as Value[Lookup: Parentlookup]. Then make the summary of this line item 'Min' and this will give you the same value for top level and child level without summing them up.

 

I hope this helps and if you have anymore questions please do let me know.

 

Thanks,

 

Usman

Message 4 of 4