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.
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.
Sorna Raja Prabhu0
Neither of those worked0
Here are all of my attempts and blueprint0
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:
For your reference , I tried to replicate your list and formula what you want to achieve.
** 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 it worked!0