Multiple Cost Center Access for one user

Hi Comunity, this is my frst ever post on this forum, and for sure it won't be the last. Before posting this, I had a look through previous questions but couldn't find quite what I needed. Here is my issue.

In the model I am working with, we have thousands of CC split between regions and Cost types and you can imagine it's a nightmare assigning multipleCC access to a single user since the drop down list does not have a search button. I tried manually inserting them separated by comma (the way export file is showing for simmilar users) but this didn't work. Is there a better way of doing this job? Finding 50 cost centers between the entire list will take hours of work. Thank you!

Accepted answers

PaulRitner

Hello,

Security can be set via bulk load processes. Rather than loading, say, a comma delimited list, you would load separate user rows for each item you are incrementally adding security-wise.

For example, in the table below, the result for "Departments L1 Write" is "Org 1, Org 2".... but its loaded as two rows/transactions.

	First Name	Last Name	Model Role	Departments L1 Write
pritner@accelytics.com	Paul	Ritner	Full Access	Org 1
pritner@accelytics.com	Paul	Ritner	Full Access	Org 2

I've seen a few models with security requests managed through workflows (in the model itself)... with the final approval including a bulk load process that sets the values in the User List.... but this could be done ad-hoc by loading a CSV for the target user(s).

Is this what you were looking for?

All comments

PaulRitner

Hello,

Security can be set via bulk load processes. Rather than loading, say, a comma delimited list, you would load separate user rows for each item you are incrementally adding security-wise.

For example, in the table below, the result for "Departments L1 Write" is "Org 1, Org 2".... but its loaded as two rows/transactions.

	First Name	Last Name	Model Role	Departments L1 Write
pritner@accelytics.com	Paul	Ritner	Full Access	Org 1
pritner@accelytics.com	Paul	Ritner	Full Access	Org 2

Is this what you were looking for?

Alexandru.Rosca

After a long struggle, I managed to set the security with an upload. Put the different CCs on separate loads and it worked just fine. Thank you!

Quick Links

Can you help?

Unanswered questions

Unable to use one page for multiple DEV models that are partially in sync
Hello, Our model builders are normally making changes to all structural changes in a DEV model. Because we are now in a Prod freeze and we don't want to move structural changes to PROD until end of year, we created a copy of the DEV model (standard mode) - 'DEV2' model, where we are only making changes to urgent issues…
Anaplan for Microsoft 365
Using the excel addin for Microsoft 365 when I try to add a card to import data I get the message 'Cannot insert data from a custom view'. I am not using a custom view. Any ideas what I am missing here?
Data Split between Many to Many Relationship Mappings
Hello Anaplan Community, I am encountering an issue with one of my development work and would be greatly appreciated your assistance. There are 2 different modules involved in my model: 1) INP01 Percentage Input by Product (Applies To: P3 List) 2) REP01 Percentage Split by Department (Applies To: Departments List) The…