Dynamic module for list in a hierarchy

Valeria

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.  

prabhu

Hi @Valeria,

I have created a similar model.

 

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

 

 

 

2. Created a module with Market FSG as Dimension

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

 

Try copying with this Formula.

 

 

 

 

 

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

 

prabhu

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

Valeria

Hi Sorna, 

Neither of those worked

prabhu

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

Valeria

Here are all of my attempts and blueprint

Akhtar.shahbaz

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:

 

 

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

Blueprint:

 

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

 

 

Hope this helps

 

Thanks

Akhtar

 

 

 

 

Valeria

Thanks it worked!