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!
Hi all, The Client ID and Client Secret are available, intended for uploading and downloading files. Could anyone advise how to use these credentials DIRECTLY to make API requests? Thank you!
I have A6 as the parent list and two sibling lists: A6.5 and A7. The A7 list includes an attribute that maps to A6.5. In the UX, the user will select A6.5 using a content selector, and the grid (dimensioned by A7) should display only the A7 items associated with that selected A6.5. Since the selector is a page context and…
A quick reminder of the Bulk Copy functionality. Bulk Copy allows you copy large volumes of data from one slice of a model to another in a single, optimised operation, instead of using formulas or imports. Use case: copy a version (RF1) into a prior year version (PY RF1) using a versions list to allow for year-on-year…
