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

Accepted answers

All comments

Manuela_Apostol

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

a.dilieto

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

ethancomstock@gmail.com

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

a.dilieto

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

ethancomstock@gmail.com

How about FINDITEM?

a.dilieto

Also FINDITEM works fine with Production List as you search a correspondence of a text in a list (again, no reference to a specif list item).

rob_marshall

@a.dilieto ,

I think I understand why you are setting all lists for Production Data at creation (so no hardcoding or select statements can be used), but this can be very dangerous especially in a Deployed model. If you remove the the production data boolean (making it a regular list) and then sync to production, then all data in the production environment tied to that list will be deleted. The reason for this is during the sync, the list in Production will be wiped cleaned (deleted) and the members in Dev will be inserted. Even if the the members with the exact same codes are used in Dev as well as in Production, the system doesn't understand that and simply wipes the list out.

So, instead of making every list a Production Data list, it is best to understand what the list will be used for (does it need to be updated in a Production environment) or is a static list (Active vs. InActive)?. If the list will be updated via actions or user involvement, then it will need to be a Production Data list. If it is static, it should be a regular list.

Hope this helps,

Rob

rob_marshall

ethancomstock@gmail.com ,

Another good article to read is this:

https://community.anaplan.com/t5/Best-Practices/Production-lists-and-ragged-hierarchies-logic/ta-p/33591

Thanks,

Rob

a.dilieto

Hi Rob,

Indeed, I was not clear but I meant setting to Production the lists that should be Production (not all).

Regards,
Antonio

DavidSmith

ethancomstock@gmail.com

Just to clarify on "Formula protection"

What is it?

Hard coded references to a list member
SELECT, IF ITEM(xx)=, P1 Product.Cars
Top Level Item is OK as that is structural (you cannot change the Top Level in a Deployed model)
You can have CODE(ITEM(P1 Products))=, or NAME(ITEM(P1 Products)) because that is not referring directly to a list element. Still not good practice though!!

Why?

In standard mode, you will generate a rollback if you delete/amend the list member
Anaplan doesn’t not allow end users to generate a rollback
In Deployed mode, a "Production" list allows end users to delete/amend the list, so Anaplan “protects” the list against this

Good Practice

It is bad practice to have hard coded references

I hope that helps clarify things

David

YuliaL

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?

DavidSmith

@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/37713

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

YuliaL

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:).

DavidSmith

@YuliaL

Good to hear

Quick Links

Can you help?

Unanswered questions

L2 Import DEM01
Hi all, i'm trying to import the file DEM01 csv but i don't know how to do it How do i select th evalue of DEM01 if the time value is on column? thanks a lot Andrea
ADO File Upload - Semicolon Delimiter
Hi, Based on the regional settings, my default delimiter/separator for CSV files is a Semicolon. In the classic way of uploading a csv file, I was able to select the delimiter. When using ADO, I don't have the option to select a delimiter. Uploading a Semicolon delimited file returns an error, or an upload with only one…
Request for Workflow Design: End-User Report Finalization & Stakeholder Notification with Version Co
Hi everyone, I'm looking to design a workflow and would appreciate your input or guidance on how to set this up effectively in Anaplan. So, the goal is: Once end users complete their data input, they should be able to trigger a process that: Notifies stakeholders via email with a link to a report. The report includes: A…