Contributor

## FINDITEM A PARENTCh

Dear all,

assuming i have these lists:

List 1: flat file

List 2: Parent of List 3

List 3: Child of List 2

I created Module 1 with List 1 as dimension, of which i mapped List 2 as its parent in the module.

is there a way i can FINDITEM the parent of List 3 in Module 1, using the text code of List 2 identified in Module 1?

I needed this so i can pull some data that is using List 3 to List 1 with their common denominator, which is List 2.

Thanks,

Elaine

1 ACCEPTED SOLUTION

Accepted Solutions
Moderator

## Re: FINDITEM A PARENTCh

Yes you are right. If you have one to many mappings in Flat list you can't flip the mapping. So LOOKUPs cant be used here. However SUM can be used if you are dealing with the numbers but if you just want mapping just ignore the below part-

This is what we know -You have L3 as a dimension in Module 3, Module 1 has a mapping between List 1 and List 2

So instead of LOOKUP use SUM because ultimately you are Summing the values based on L3 mapping of which comes from Flat L1 Module

Step 1 - Create a List 2 Formatted Line item and use FINDITEM('List 2', Text List 2 Line Item)

Step 2 - Create a Parent Line item in Module 1 and use PArent (Line item 1 in step 1)

Step 3 - In Module 3 - Use SUM to aggregate the values and the formula should be

Amount[SUM:Module 1.Parent in Step 2)

10 REPLIES 10
Frequent Contributor

## Re: FINDITEM A PARENTCh

you can create system module with flat list which is child list and create line items. like below.

In the below Module, I have formatted Country Line Item as Child List not Flat List.

Thanks,

Contributor

## Re: FINDITEM A PARENTCh

it wasn't like that. List 1 is flat file, of which, i mapped List 2 as its parent in a module..

List 2 is the parent of List 3..the only common denominator is List 3 and List 1 is List 2..

What I actually need is to be able to sum up List 1 in a module, which dimension is list 3, using its common List 2 as parent to List 3 in a hierarchy..and mapped parent in L1 in a module.

I hope I clarified my requirement.

Thanks again,

Elaine

Frequent Contributor

## Re: FINDITEM A PARENTCh

As per Requirement,  you have to create one more line tem formatted as List 3 in Module 1 which is dimensioned by List 1 Flat list.

In other module 2 Which is dimensioned by List 3. you have to sum up data for List 1 which is in Module 1.

See if it looks good according to your requirement or Please share the screenshots.

Thanks,

Contributor

## Re: FINDITEM A PARENTCh

It cannot be as well.. L3 is multiple..

Contributor

## wiRe: FINDITEM A PARENTCh

just check whether My understanding is correct .

Assuming, List 3 is lineitem formatted as List 3

create one more lineitem List 2 format as List 2 and write parent(List 3 lineitem).

now, Finditem(List 1, Name(List 2 lineitem).

Thanks

Regular Contributor

## Re: FINDITEM A PARENTCh

Need few clarifications based on your question,

Let me assume, you have a flat list named L1 which is mapped to list L2 in a module say module_1 as list formatted line item.

Similarly, you have list L3 which has a parent as List L2

Now you need to identify the parent L2 of L3 list in module_1 which is dimensioned by list L1.

do we have any line item in module_1 as an L3 list or L3 list as text format? if so, you can get an L3 parent in Module_1 else no.

It would be great if you share some of the mockup screens of what you trying to achieve.

Thanks,

Sandeep

Moderator

## Re: FINDITEM A PARENTCh

There is a lot of ambiguity in your statements - Kindly put your requirements clean and clarify below statements

1. "I created Module 1 with List 1 as dimension, of which i mapped List 2 as its parent in the module" - How are you making List 2 as a parent in the module? Do you mean to say that you created a mapping between List 1 and List 2? And If yes, Is that mapping in text format or List Format

2. "Is there a way i can FINDITEM the parent of List 3 in Module 1, using the text code of List 2 identified in Module 1?" - What is List 3 doing in Module 1, why the need to bring List 3 here? Do you mean to say that you want to find out what is the parent of Text formatted List 2 line item which you mapped in Step 1.

Contributor

## Re: FINDITEM A PARENTCh

Hi Misbah..

How are you making List 2 as a parent in the module? Do you mean to say that you created a mapping between List 1 and List 2? And If yes, Is that mapping in text format or List Format - In List 1, a line item was created to map it to List 2. so not parent per se but some sort of parenting but not as hierarchy but as mapping.

What is List 3 doing in Module 1, why the need to bring List 3 here? Do you mean to say that you want to find out what is the parent of Text formatted List 2 line item which you mapped in Step 1. - List 3 is actually my problem module..they are different list.

Since L1 is multiple. I think there is no way to look up L1 in L3 using L2 as common factor. The requirement would have been to look up L1 in the L3 module using L2. but i think this will only work if L2 and L1 is 1 is to 1 list.

Thanks, Elaine

Moderator

## Re: FINDITEM A PARENTCh

Yes you are right. If you have one to many mappings in Flat list you can't flip the mapping. So LOOKUPs cant be used here. However SUM can be used if you are dealing with the numbers but if you just want mapping just ignore the below part-

This is what we know -You have L3 as a dimension in Module 3, Module 1 has a mapping between List 1 and List 2

So instead of LOOKUP use SUM because ultimately you are Summing the values based on L3 mapping of which comes from Flat L1 Module

Step 1 - Create a List 2 Formatted Line item and use FINDITEM('List 2', Text List 2 Line Item)

Step 2 - Create a Parent Line item in Module 1 and use PArent (Line item 1 in step 1)

Step 3 - In Module 3 - Use SUM to aggregate the values and the formula should be

Amount[SUM:Module 1.Parent in Step 2)