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)|
Case Of M1
Case of M2 What I am getting is:
But i want is:
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.
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 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.
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.