Dynamic module for list in a hierarchy

Highlighted
New Contributor

Dynamic module for list in a hierarchy

I need help creating a list for the market.  I was able to do this at the retailer level, but how do you do the same thing for the market.  I need to be able to do this so that I have the code for the market.  

7 REPLIES 7
Highlighted
Super Contributor

Re: Dynamic module for list in a hierarchy

Hi @Valeria,

 

Market Code should be Text Format

Try Removing Single Quotes within code(item(''))

or Try Code(Market (FSG))

 

 

Hope it Helps

 

Thanks,

Sorna Raja Prabhu

Sorna Raja Prabhu
Highlighted
New Contributor

Re: Dynamic module for list in a hierarchy

Hi Sorna, 

Neither of those worked

Highlighted
Super Contributor

Re: Dynamic module for list in a hierarchy

Hi @Valeria,



1. Can you send the screenshot of the error?

2. Can you send the Blueprint view of Dynamic List of Market?









Thanks,

Sorna Raja Prabhu
Sorna Raja Prabhu
Highlighted
New Contributor

Re: Dynamic module for list in a hierarchy

Here are all of my attempts and blueprint

Highlighted
Super Contributor

Re: Dynamic module for list in a hierarchy

Hi @Valeria 

 

It seems you are working on Data hub model, so as per the best practice don't create hierarchy lists in data hub. You should create a Flat list and system module for the mapping and then from this system module you can create your hierarchy lists in your spoke model.

If you want to do data validation then you can create hierarchy lists in data hub. for more details you can refer below link:

https://community.anaplan.com/t5/Best-Practices/Data-Hubs-Purpose-and-Peak-Performance/ta-p/48866

Example:

Screenshot_136.png

 

 

For your reference , I tried to replicate your list and formula what you want to achieve.

Screenshot_137.png

Blueprint:

Screenshot_138.png

 

** You are getting below error because in your formula as you have not given space between market and (FSG) but in your line item its having space.

 Screenshot_139.png

 

Hope this helps

 

Thanks

Akhtar

 

 

 

 

Highlighted
Super Contributor

Re: Dynamic module for list in a hierarchy

Hi @Valeria,

I have created a similar model.

 

1. Market (FSG) List is Created and Assigned parent (Parent of Market (FSG) List).

 

Capture14.JPG

 

 

2. Created a module with Market FSG as Dimension

The formula for Market Code is : CODE(ITEM('Market (FSG)'))

 

Try copying with this Formula.

 

Capture12.JPG

 

 

 

Capture13.JPG

 

To your note: When you write finditem function in Market (FSG) Line Item: it References Market Code Line item

That is Market (FSG) Line item is Dependent on Market Code Line item (Market (FSG) -> Market Code)

 

and if you write a formula in Market Code Line item as Code(Market (FSG))

Market Code Line item is dependent on Market (FSG) Line item ((Market Code -> Market (FSG)))

 

That's why you are getting circular reference error.

 

if you Write CODE(ITEM('Market (FSG)')) in Market Code Line item, it is dependent on the Dimension of the Module, so you shouldn't get any error.

 

Thanks,

Sorna Raja Prabhu

 

Sorna Raja Prabhu
Highlighted
New Contributor

Re: Dynamic module for list in a hierarchy

Thanks it worked!