Production list item protection

Highlighted
Occasional Contributor

Production list item protection

Hello,

 

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.

 

Thank you,

Ethan

14 REPLIES 14
Highlighted
Master Anaplanner/Community Boss

Re: Production list item protection

HI, 

 

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 

 

 

 

 

Highlighted
Occasional Contributor

Re: Production list item protection

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?

Highlighted
Master Anaplanner/Community Boss

Re: Production list item protection

@YuliaL 

Is the list in question a non-composite list, as in are levels 0, levels 1, etc. all part of the same list?

 

Is suspect it is because of your point about returning zero (a know issue for LOOKUP on non-composite parents)

 

An alternative would be to create a composite lists and the LOOKUP will then work, but if that is not feasible, then this article might help

 

https://community.anaplan.com/t5/Best-Practices/Production-Lists-and-Ragged-Hierarchies-Logic/tac-p/...

 

It is a little involved, but does get around the issue of production list formula protection for non composite lists

 

As an aside, I am working with engineering to resolve the issue above, so that the formula will return the value

David

Highlighted
Occasional Contributor

Re: Production list item protection

Thanks David, after your comment I've realised that we have exactly this module to build flat hierarchy for other things. So I used that hierarchy instead and it worked fine:).

Highlighted
Master Anaplanner/Community Boss

Re: Production list item protection

@YuliaL 

Good to hear

Highlighted
Certified Master Anaplanner

Re: Production list item protection

Hi,

 

I think this can help: https://community.anaplan.com/t5/Best-Practices/Setting-production-lists/ta-p/19284

To make it easier for the next implementations, you should set up the lists as production as soon you create them.

 

Regards,

Antonio

Highlighted
Occasional Contributor

Re: Production list item protection

Thank you for the feedback.  Do you know if using the PARENT function on a list will prevent marking it as production data?

Highlighted
Certified Master Anaplanner

Re: Production list item protection

No, the PARENT function will not prevent marking a list as production as you are not referring to a specific item (that is the case of the SELECT instead).

 

Regards,

Antonio

Highlighted
Occasional Contributor

Re: Production list item protection

How about FINDITEM?