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.
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
Market Code should be Text Format
Try Removing Single Quotes within code(item(''))
or Try Code(Market (FSG))
Hope it Helps
Hi Sorna,
Neither of those worked
Here are all of my attempts and blueprint
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
Thanks it worked!
Can someone help me i am unable to login anaplan portal using my credentials
Dear Hive Mind, Do we have a way to get the history of a particular List Item, from its creation into a model up until its removal ? I am trying to chase when / how an item has been added into a model and how / when it would have been deleted and then recreated with the same code. Is there a pattern (manual or API) to get…
I have an action in a process which is getting failed since 2 days when run via CloudWorks with below error . No issues when run manually . Same error occurs when run manually but as a warning "Import complete but with failures" This action is running since almost a year without any issue . No change has been made to…
