Selective access based on property

Hi all,

I have a list of customers belonging to a region . Every customer is linked to a unique account manager. I have a SYS- Customers module, with the customer list as a dimension and the account manager as a list-formatted line item and the region as a list-formatted line item. The lists of account managers and regions are flat list, they are not part of the customer hierarchy since I need to aggregate customers into other parent lists.

I want to set up selective access on the region,so that each account manager only sees the regions in which his customers are located.

How can I make the link between account manager and region?

Kind regards

Accepted answers

ArunManickam

Saved view

Import Mapping

Result

Note: It is only incremental/additive, when there is a removal of access it does not work. For that case, you need one more step to clear all selective access and then import from the SYS module saved view. The admin who runs this process must have access to all and should not be an account manager himself/herself.

Hope it helps.

Thanks

Arun

All comments

ArunManickam

Hello @LouiseBourgonjon ,

Are the inputs made on Customer dimension or Region dimension? -- Assuming it is on Customer dimension.

Providing selective access at region level (since it not part of the customer hierarchy), it may restrict the region but it is going to show all customers to the account manager for the selected regions. You may rethink to provide the selective access by customer & region.

From your SYS module, you can create an import action which imports into the User setup. This can be automated and scheduled. Once you setup the SYS module, it can create necessary selective access on Region & Customer.

Thanks

Arun

LouiseBourgonjon

Hi Arun,

Thanks for your reply.

Indeed the inputs are made on customer dimension.

Yes, I will indeed need to set up access rights both on region and on customer level.

For the customer level, I managed, since a customer is directly linked to an account manager (which are linked to a user in Anaplan).

But for the regions, there is no direct link between a region and an account manager. I created a module with dimensions Region & Account Manager, in which I want to map the regions of an account manager. From there I would create a saved view and import into users selective access. But I don't manage to find a formula to show which regions belong to an account manager. Any idea?

user_access_60935.PNG

ArunManickam

Saved view

Import Mapping

Result

Hope it helps.

Thanks

Arun

LouiseBourgonjon

Great! Thanks a lot for your help!

ckryan

Hi Guys,

I wanted to follow up on this. We are running into a scenario where we want to remove selective access enabled list member from a user. For example, we would want to remove REG#2 from Nathan Rudman below. Is there a way to remove access via an action? We have tried importing a systems module using a line item with a formula of BLANK.

Looking forward to your responses!

Thanks!

ArunManickam

Hello @ckryan

You need to import the values into the "NONE" field of the respective selective access level.

Usually I import all values into the NONE (for eg P1 Department NONE) , so it clears everything and then run the second action which sets up the value into P1 Department Read/Write.

Thanks

Arun

ckryan

Thanks, Arun!

Quick Links

Can you help?

Unanswered questions

Introducing Anaplan API Python SDK
Hey everyone, I wanted to share the Anaplan Python SDK with you. It's a Python Library that wraps all Anaplan APIs and makes it easier to interact with Anaplan programmatically. It is mostly designed with Data Integration Scenarios in mind, but it does support all APIs including ALM, SCIM, Audit, and Cloud Works. Please…
Batch Script
Hello team, I am logging into Anaplan through SSO. I would like to create a batch script to import a file into Anaplan. For the Spoke model, I would like to run an process via a batch script to import data from the Data Hub. Can anyone provide me script for both the condition.
Cloudworks Big Query Integration Fail
Hello, I am receiving an 'Anaplan Upload Failed' Status Description when testing my integration with a Big Query dataset. The integration imports data from BQ to our Anaplan model. No other details given in the error log. I suspect that Cloudworks is not even picking up the file but am not sure what we did wrong on the set…