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!
Best Answer
-
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?
1
Answers
-
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!1