We are in the final stages of an implementation and are running into issues related to marking lists as production data. The problem is that over the course of development many list items have been referenced in line item formulas, so the system prevents these lists from becoming production data. The workarounds suggested in other community posts, such as using LOOKUP instead of SELECT, have not worked. If anyone has any experience with this problem or suggestions I would greatly appreciate any help.
The workaround would be to make those selections dynamic.
To identify where those items are referenced (you can go to general lists, select the list you want to check and look at "Reference in formulas"). Then, create a module (no dimensions) and Line items - list dimensioned - and pick up the element from the list you refer to. Therefore, instead of referencing the list item directly in the formula you lookup that specific Line Item which was created in a module.
In this way, you remove every direct reference to your list elements
Hi! I am using this extra module with list-dimensioned Line item to reference a Production list. But I need to reference the item on Level 1, and the list is hierarchical with no Top Level Item. Like for example, we have Germany (level 0) and France (level 0) but I need to reference Europe (level 1). The formula works but gives 0 as a result. Do you have any ideas how to deal with such a case?