topic Dynamic Cell Access by Role in Anaplan Platform https://community.anaplan.com/t5/Anaplan-Platform/Dynamic-Cell-Access-by-Role/m-p/41574#M4362

I am looking for suggestions / alternative approaches for managing DCA by the user's assigned Role. Ideally, there would be an easy way to maintain this going forward.

 

1) I have heard a rumor that there is a trick wherein you somehow create a filtering module, then use the normal Roles>>Modules access assignments. Access to the filtering module somehow controls access to the line item.  If this approach works, it would minimize maintenance and simplifiy the overall process.  Unfortunately, I have been unable to make this work.  Does anyone have a trick up their sleeve?  

 

2) Another alternative might go something like this: Create (and maintain) a List of Roles, build a module by Users and Roles, export / import the Roles tab in order to maintain the mapping of Users to Roles, then use booliean logic like "If user has Role and Role is allowed read access then true" as filters for DCA.  Is there a practical how-to set of steps for this?  

 

 

Thu, 21 Feb 2019 11:55:29 GMT hendersonmj 2019-02-21T11:55:29Z Dynamic Cell Access by Role https://community.anaplan.com/t5/Anaplan-Platform/Dynamic-Cell-Access-by-Role/m-p/41574#M4362

I am looking for suggestions / alternative approaches for managing DCA by the user's assigned Role. Ideally, there would be an easy way to maintain this going forward.

 

1) I have heard a rumor that there is a trick wherein you somehow create a filtering module, then use the normal Roles>>Modules access assignments. Access to the filtering module somehow controls access to the line item.  If this approach works, it would minimize maintenance and simplifiy the overall process.  Unfortunately, I have been unable to make this work.  Does anyone have a trick up their sleeve?  

 

2) Another alternative might go something like this: Create (and maintain) a List of Roles, build a module by Users and Roles, export / import the Roles tab in order to maintain the mapping of Users to Roles, then use booliean logic like "If user has Role and Role is allowed read access then true" as filters for DCA.  Is there a practical how-to set of steps for this?  

 

 

Thu, 21 Feb 2019 11:55:29 GMT https://community.anaplan.com/t5/Anaplan-Platform/Dynamic-Cell-Access-by-Role/m-p/41574#M4362 hendersonmj 2019-02-21T11:55:29Z
Re: Dynamic Cell Access by Role https://community.anaplan.com/t5/Anaplan-Platform/Dynamic-Cell-Access-by-Role/m-p/41578#M4363 < P > < a href = " https://community.anaplan.com/t5/user/viewprofilepage/user-id/7973">@hendersonmj 

The best approach is 2.

 

1. Create a list of roles and map the access to the roles (in my example, products)2019-02-21_12-08-31.png

 

2. Map the users to the roles2019-02-21_12-26-39.png

3. Map the access by role to a module by user and product2019-02-21_12-34-16.png

Hope that helps

David

 

 

Thu, 21 Feb 2019 12:39:01 GMT https://community.anaplan.com/t5/Anaplan-Platform/Dynamic-Cell-Access-by-Role/m-p/41578#M4363 DavidSmith 2019-02-21T12:39:01Z
Re: Dynamic Cell Access by Role https://community.anaplan.com/t5/Anaplan-Platform/Dynamic-Cell-Access-by-Role/m-p/41592#M4369

and with David's solution for 2, you can actually solve 1 as you can use your mapping to maintain the actual user role:you can import from the module into the user settings, avoiding "maintenance" and managing user rights from a dashboard which is more user friendly.

Fri, 22 Feb 2019 00:43:03 GMT https://community.anaplan.com/t5/Anaplan-Platform/Dynamic-Cell-Access-by-Role/m-p/41592#M4369 nathan_rudman 2019-02-22T00:43:03Z
Re: Dynamic Cell Access by Role https://community.anaplan.com/t5/Anaplan-Platform/Dynamic-Cell-Access-by-Role/m-p/41611#M4372 < P >,如果需要,你可以有一个差异erent set of roles for DCA purposes and map user to mulitple roles.  You just have to amend the logic to check for each role line item

 

2019-02-22_09-06-41.png

 

2019-02-22_09-08-25.png

 

 

Fri, 22 Feb 2019 09:10:59 GMT https://community.anaplan.com/t5/Anaplan-Platform/Dynamic-Cell-Access-by-Role/m-p/41611#M4372 DavidSmith 2019-02-22T09:10:59Z
Re: Dynamic Cell Access by Role https://community.anaplan.com/t5/Anaplan-Platform/Dynamic-Cell-Access-by-Role/m-p/41757#M4399

I have a customer who's trying to do this as well, but their user base and list of roles is large, changing often.  Any creative ways on how user to role mapping can be automated?  Only thing I can think of is an export of user role and an import to the mapping module.

Tue, 26 Feb 2019 18:45:03 GMT https://community.anaplan.com/t5/Anaplan-Platform/Dynamic-Cell-Access-by-Role/m-p/41757#M4399 matt.brady 2019-02-26T18:45:03Z
Re: Dynamic Cell Access by Role https://community.anaplan.com/t5/Anaplan-Platform/Dynamic-Cell-Access-by-Role/m-p/41866#M4421

Yep, unfortunately that is the only practical option, but you could schedule it to run overnight or 2x per day

If you were going to run it during the day, you could also use an additional line item to only import the changes

 

They will need to be wary of changing the use role whilst the users are in the model.  Imagine you are in the middle of entering data, the import runs, and now you can't edit/see what you could before!!!

 

Hope that helps

David

Thu, 28 Feb 2019 19:45:16 GMT https://community.anaplan.com/t5/Anaplan-Platform/Dynamic-Cell-Access-by-Role/m-p/41866#M4421 DavidSmith 2019-02-28T19:45:16Z
Re: Dynamic Cell Access by Role https://community.anaplan.com/t5/Anaplan-Platform/Dynamic-Cell-Access-by-Role/m-p/73016#M14694

Indeed for models with large volumes of users this is still an hassle, would be easier if the role could be the basis for the DCA automatically.

 

How we solved it now is that the user access is updated based on the module where the role is specified. Instead of setting the access in the User Access section, Access is maintained in a module and from the module imported into the User Access. This also allows a direct connection with the user access maintenance system outside Anaplan.

Sun, 07 Jun 2020 13:31:18 GMT https://community.anaplan.com/t5/Anaplan-Platform/Dynamic-Cell-Access-by-Role/m-p/73016#M14694 maud_vermeulen 2020-06-07T13:31:18Z
Re: Dynamic Cell Access by Role https://community.anaplan.com/t5/Anaplan-Platform/Dynamic-Cell-Access-by-Role/m-p/73070#M14716 < P > < a href = " https://community.anaplan.com/t5/user/viewprofilepage/user-id/145">@maud_vermeulen 

I am going to be looking at enhancements to the users list and roles, including the possibility of a system generated roles list, so that will hopefully make this a lot easier

Don't hold me to dates at this point - I'm asking the requirements to be investigated - But watch this space!

David

Mon, 08 Jun 2020 09:07:09 GMT https://community.anaplan.com/t5/Anaplan-Platform/Dynamic-Cell-Access-by-Role/m-p/73070#M14716 DavidSmith 2020-06-08T09:07:09Z
Re: Dynamic Cell Access by Role https://community.anaplan.com/t5/Anaplan-Platform/Dynamic-Cell-Access-by-Role/m-p/133229#M34470 < P > < a href = " https://community.anaplan.com/t5/user/viewprofilepage/user-id/157">@DavidSmith Any luck on this requirement?

Wed, 02 Mar 2022 05:49:02 GMT https://community.anaplan.com/t5/Anaplan-Platform/Dynamic-Cell-Access-by-Role/m-p/133229#M34470 PratikGoenka 2022-03-02T05:49:02Z