Unique ID Number

Is there a way to have my Anaplan model assign a unique identifier number to line items in a budget? I plan to load a budget into my model and would love for the system generate a unique identifier number for each item in order to reduce risk of human error. Currently in my Excel budget file, the unique identifiers are created manually which gives to a risk of duplication.

Accepted answers

PrevContributor

In order to identify each item uniquely a NUMBERED LIST will serve this request.
A unique number gets generates for each item when the data is entered/imported in to the list.

Reference Link : https://community.anaplan.com/anapedia/model-building/lists-and-roll-ups/numbered-lists/working-with-numbered-lists/

All comments

PrevContributor

peter_mcanena

Alternatively, you could use a formula like this:

RANK(Sort Value, ASCENDING, SEQUENTIAL)

where Sort Value is any line item in the module (as long as that line item has all the relevant dimensions).

Quick Links

Can you help?

Unanswered questions

ANAPLAN XL View
Hi, I need help in pulling a specific view in Anaplan XL. The first grid should display attributes of various projects, while the second grid should present the monthly financial data for these projects. Thanks in advance.
Add list members to a selective access list
Hi, I am working on a solution where the User should only have access to write/edit the list members that they add from an Action on the frontend. This action adds another list member to a selective access list. The problem is, in order to run the action, you need access to the entire list, so you would see all list…
Dimensionality Issue
Hi ALL, In my model, I have Need stored at a 'D3' RS Group level. I need to use this Need in another module at the G5 Location level. I currently have a mapping module where each G5 Location maps to a D3 RS Group. This Module uses D2 Role as dimension. but the line item I've to find the RS Group (Find D3 RS Group = 'FIND…