Hierachy Import

Highlighted
Super Contributor

Hierachy Import

I have lists with 6 levels of hierarchy.

I want to pull data for level 3 from the highlighted module.

Is it possible not by using parent function but by simple import to pull the data.

What I was thinking, I pull the data for L1 and then use parent and item function.

In that case, friends suggest me, what will be the formula for it.

Please don't hesitate to ask me, if you find any difficulty in understanding.

 

Sravan_Kumar_1-1586369467346.png

Sravan_Kumar_2-1586369528368.png

 

 

 

10 REPLIES 10
Highlighted
Master Anaplanner/Community Boss

Re: Hierachy Import

Hi @Sravan_Kumar,

 

Use parent function, this is the best way to achieve the result instead of doing the import.

 

Parent L3 List = PARENT(PARENT(ITEM('List')))

Parent Value = Gross[lookup:Parent L3 List]

 

Do you have a particular reason for not using parent function? Let us know will find another option to get this result.

 

Regards,

Vignesh M

 

 

Highlighted
Certified Master Anaplanner

Re: Hierachy Import

Hi Sravan,

 

A couple of questions:

1. Are you using a composite list to define each level of the hierarchy? - If so, you can use the 'Select Levels to Show' functionality against your list to pull the required L3 List

2. If you are not using a composite list (i.e. the hierarchy all sits in one list) - try using the following example: https://community.anaplan.com/t5/Best-Practices/Calculating-Levels-in-a-Hierarchy-for-Dashboard-Filt... . The final output for them was the line item 'Level (or L4)' which depicts the level in the hierarchy, which you can use to filter the desired level in your hierarchy

Highlighted
Super Contributor

Re: Hierachy Import

Thanks @VIGNESH.M @wquan @Sorna Raja Prabhu for helping with the formula.

I tried with the parent one and it was imported without error. (Module Tests - Copy - Copy had numbered list).

 

Now I have to populate with the values of L3 A, L3 B,... resp.

 

Kindly guide me, how is it possible?

 

Sravan_Kumar_1-1586402405162.png

 

 

 

Highlighted
Super Contributor

Re: Hierachy Import

Hi @Sravan_Kumar,

 

You have 2 different module,

                            Source Module has Level 6 as Dimension, in which you need Level 3(L3 A, L3 G, ....) data.

                            Target Module has Different List(K3 A, K3 B, K3 C ....) as Dimension.

 

Question to you, is there any relation between two dimension?

 

For Eg:

       If the Code for 2 different list are same, a relation exists we can either use formula or import action.

 

 

Sorna Raja Prabhu
Highlighted
Super Contributor

Re: Hierachy Import

Hi @Sorna Raja Prabhu,

I created a Filter manually and saved it.

I exported the saved list (i.e. all L3 levels).

After that I was trying with Lookup, it didn't work.

 

Sravan_Kumar_0-1586406974905.png

Sravan_Kumar_1-1586407098480.png

 

 

 

Highlighted
Super Contributor

Re: Hierachy Import

@Sravan_Kumar - It seems you have changed a dimension in target module.

 

Assuming Mod List New as Target Module which has Level 3 as Dimension.

 

Your formula is correct, but replace Lookup with SUM[Module tests-copy-copy.prodt list].

Sorna Raja Prabhu
Highlighted
Super Contributor

Re: Hierachy Import

I am sorry @Sorna Raja Prabhu.

It didn't work with SUM either.

I even created Time Period as Line formatted, it failed too.

 

Can you please help.

 

Sravan_Kumar_0-1586411460141.png

 

Sravan_Kumar_1-1586411511265.png

 

Highlighted
Super Contributor

Re: Hierachy Import

@Sravan_Kumar - 

 

Scenario 1:

 

In your Source Module you have Time and Level 6 Dimension.

In your Target Module You have Time and Level 3 Dimension.

 

In This Case you don't want to use lookup or sum, you can simply hard code.

I am sorry for my previous post, i misunderstood.

 

Capture.JPGCapture1.JPG

 

 

 

Scenario 2:

 

In your Source Module you have Time and Level 6 Dimension.

In your Target Module You have Level 3 Dimension.

 

In this case you can use Time Sum Function.

 

Capture2.JPG

 

 

Hope this helps.

Sorna Raja Prabhu
Highlighted
Super Contributor

Re: Hierachy Import

I have deleted the K Module