Allow for multiple list items in user selective access when importing from a module into users

Allow for multiple list items in user selective access when importing from a module into users

We use imports to update our user list with selective access, but cannot do this when one user can have multiple access, e.g. access to multiple countries in a list, because the line item in the module has to be dimensionned by the list itself and in the list we can only select one item. Alternatively we may run the action once with country A, then change to country B and ruen the import again, but that is time consuming, manual and the module cannot be used for auditing access anymore.

4 Comments
Community Manager
 
Status changed to: Your support is needed
Certified Master Anaplanner

Hi @MagaliP,

 

We're running into the same issue. Were you able to come up with a workaround?

 

Thanks,

Charly

Certified Master Anaplanner

Thanks Charly. The four workarounds I can think of and we have used depending on our models:

1/ Manually add the second selective access (this works if you have a limited number of users facing this situation)

2/ Run the import from the module into the users twice, once mapping with a column which contains the first access and then a column containing the second access (but depending on your number of users, the import can take several minutes, blocking your model in the meantime)

3/ Not using selected access but DCA instead and then filters so they cannot see list items they should not have access to

4/ Potentially you may try and change your list hierarchy to group country A and B under for example division 1, and give selective access to division 1 instead of the two countries separately (may cause big impact on hierarchy and space though)

 

I hope that helps.

Community Boss

Hi,

 

this works pretty easily, we do it all the time.

The source module needs to have the user and the country dimension. Then make the selection a boolean, if true, write the code.

Prepare your view with users and countries as rows and filter it on only what they have access to. Save it and use that as the source.

It should be showing you one row for every country the user has access to. Access import is incremental, so every row will be imported successively and add to the access.

The max I've imported with this numbers in the tens of thousands and no problem.

If you want to reset the access, run a first import step with the role of "No Access" for that user.

 

Repeat this for every dimension you need in selective access (if composite list you can manage several levels of the list in the same source module)

Users Online
Currently online: 179 members 471 guests
Please welcome our newest community members: