How to create an action to assign parent to item in system module

Question

i have a flat list and want to create a system module having the flat item list and now i want to assign parent for that list item in the system module. How to create the action to assign parent.

prabhu · Answer

Hi @saurav4ss ,

You have List item which has already assigned parent.

You want to assign parent to your list item, by creating a List formatted line item.

What list are you going to use in this line item to assign parent?

Is there any parent hierarchy for your flat list?

or provide some screen shot for better understanding.

Thanks.

Misbah · Answer

Where is the parent of the flat list items. It has to be somewhere in the hierarchical modules or in hierarchy atleast.

Use FINDITEM formula in your system module to get the parent

For example in my flat list i have got

A

B

C

Somewhere in the model Anaplan knows what is the parent of these list items.

Create one line item in your System module - formatted as List ( this list has to be your hierarchical list which stores information about the parent)

Line item 1 = FINIDITEM(Name of the list, Name(ITEM(Flat List)))

Create another line item

Line item 2 = PARENT(Line Item 1)

You should be able to get the output as needed

saurav4ss · Answer

actually i have created a flat list but the list item is having parent and i am not assigning parent to the list  and want to create a system module having flat list as a dimension and a line item to assign parent.