Dynamic read access

Hello, wondering if anyone has a solution to this problem?

I have a business with 3 sites: A, B and C. This is captured in a 'Site' list in Anaplan, which contains 'Site A', 'Site B' and 'Site C'.

I've set up 3 user accounts for each of the 3 site managers, such that site manager A can only see Site A in the 'Site' list, site manager B can only see Site B and so on.

If I have a module where the dimensions are 'row list' (a list containing numbers 1 to 10), a line item formatted to site and other text formatted line items, is it possible to restrict access so that the Site A manager can only see 'row list' list items for which the 'site' formatted line item is set to 'Site A'?

If effect, if Site A manager were to access this module, input data against row 1 and then select Site List = Site A, is it possible to then make row 1 hidden from Site manager B and C?

I couldn't see that it was possible to do this with a read/wite access drivers

Accepted answers

Tom_H

Thanks both, much appreciated

All comments

rob_marshall

@Tom_H

In short, no as the read/write drivers (DCA) is at the cell level, not the dimension level.

Could you possibly change this up and create a composite list with 10 rows under each site? If you do that, then you can take advantage of Selective Access.

TristanS

@Tom_H To hide the actual rows you would need to use a filter. But there is a way to hide the contents of the rows via Dynamic Read access in case your users have access to the filters and remove the filters. Below are the ways you can

Create a access driver module to the sites (as per below)
Select the sites each of the users should have access to

3. In your row list module have the following line items and formulas. Note: there a DCA on the site line item.

4. Add a filter to the module

Final result is as follows:

Without filter applied you get this

If I remove the read access driver on the site line item I get this

Tom_H

Thanks both, much appreciated

Quick Links

Can you help?

Unanswered questions

Different Subsets of Parent Lists in Input & Output Modules
I have 2 lists used in modelling, In Input module I'm using subset of territories from Country List and subset of Regions from Flat list. But in Output module,Its reversed, I'm using subset of regions from Country list and subset of territories from flat list.How to derive the numbers from input to output module. I do have…
Is there a way to turn off the Show Comments Summary panel in UX pages with Comments?
This shows all comments across all data to all users with access to the UX page. This is not appropriate for any UX which might contain security access sensitive data. Comments on grids and cards ARE security dependent. That works fine. But anyone with access to the page can open this Summary Panel and see ALL comments…
Are there any plans to support actions to rename or delete native Versions?
If anyone is aware of idea exchange ideas that are currently being evaluated by the product team, if you don't mind linking them here, would love to give them an upvote. Thanks!