Hierachy Import

Sravan_Kumar

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.

Accepted answers

VIGNESH.M

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

prabhu

Hi @Sravan_Kumar ,

I have some doubts,

1.You want to get L3 G data = 103 and L3 item values...

2.without using parent function, you are looking for some other way.

3. I am assuming that, the screen shot which u have provided should be the source model, what is your target model and what are all the dimensions in your target model..?

wquan

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-Filtering/ta-p/33567 . 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

All comments

VIGNESH.M

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

prabhu

Hi @Sravan_Kumar ,

I have some doubts,

1.You want to get L3 G data = 103 and L3 item values...

2.without using parent function, you are looking for some other way.

3. I am assuming that, the screen shot which u have provided should be the source model, what is your target model and what are all the dimensions in your target model..?

wquan

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

Sravan_Kumar

Thanks @VIGNESH.M @wquan @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?

prabhu

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.

Sravan_Kumar

Hi @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

I have deleted the K Module

prabhu

@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].

Sravan_Kumar

I am sorry @prabhu.

It didn't work with SUM either.

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

Can you please help.

prabhu

@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.

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.

Hope this helps.

Quick Links

Can you help?

Unanswered questions

Unable to use one page for multiple DEV models that are partially in sync
Hello, Our model builders are normally making changes to all structural changes in a DEV model. Because we are now in a Prod freeze and we don't want to move structural changes to PROD until end of year, we created a copy of the DEV model (standard mode) - 'DEV2' model, where we are only making changes to urgent issues…
Anaplan for Microsoft 365
Using the excel addin for Microsoft 365 when I try to add a card to import data I get the message 'Cannot insert data from a custom view'. I am not using a custom view. Any ideas what I am missing here?
Data Split between Many to Many Relationship Mappings
Hello Anaplan Community, I am encountering an issue with one of my development work and would be greatly appreciated your assistance. There are 2 different modules involved in my model: 1) INP01 Percentage Input by Product (Applies To: P3 List) 2) REP01 Percentage Split by Department (Applies To: Departments List) The…