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!
Solved! Go to Solution.
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|
|email@example.com||Paul||Ritner||Full Access||Org 1|
|firstname.lastname@example.org||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?