Selective access @ list items is not displaying parent of the selected list items

Hi Experts,

Encountered an issue with selective access of list items. Our requirement is to provide selective access to Zone and in the dashboard users see information for their specific Zone rolled up @ Region. When selective access is provided to the Zone list items, the Region list is not displayed for the users (neither the rolled up data is not displayed for them for their specific zones)

In the model, we have 2 list, list1 is "Region" and list2 is "Zone". List1 is the parent of list2 and the hierarchy is built using this relationship (Region is the parent of Zone)

Region List Zone List

A A (Zone1, Zone2, Zone3) where zone1..3 are list items and its parent is A

B B (Zone4, Zone5, Zone6) where zone4..6 are list items and its parent is B

C C (Zone7, Zone8) where zone7&8 are list items and its parent is C

Provided selective access to user to Zone5 & Zone6 and this user need to see information of these 2 Zones at all pages. Region B need to show information of Zone5 & Zone6 and not all.

Problem statement: if NO selective access is provided for Region list then i could not bring a dashboard for the users to display data @ region level

if selective access is provided to "Region" list then all zones (including Zone4 data is displayed) at region level

Kindly guide us what access to be granted to the user to overcome these scenarios

Regards,

Siva

Accepted answers

All comments

MathisG

Hello Sivasankar,

It is actually not possible to manage this just with selective acces, simply because the summary "Region B" can not have one value for a user and another for another one.

If you really really need to do that, you can dimension new line items with the same dimensions + the user list and create a rule "if user has access then value else 0". Each user will see the correct totals, but this will greatly increase the size of your model and the complexity.

Regards

Sivasankar

@MathisG thanks for the prompt response. But being this is a key feature of an OLAP design say analysis of data using slice and dice of the dimensions, i thought it could be easily achievable.

yes can think about using your workaround if the size is in control. thanks a lot

Regards,

Siva

rob_marshall

@Sivasankar

Have you thought about using DCA (Dynamic Cell Access) instead of selective access for this requirement? And since the Users list does not have a built-in Top Level, you may need to use a Custom Users list (in my case Fake Users).

Data Module

Rob

Quick Links

Can you help?

Unanswered questions

Unable to use one page for multiple DEV models that are partially in sync
Hello, Our model builders are normally making changes to all structural changes in a DEV model. Because we are now in a Prod freeze and we don't want to move structural changes to PROD until end of year, we created a copy of the DEV model (standard mode) - 'DEV2' model, where we are only making changes to urgent issues…
Anaplan for Microsoft 365
Using the excel addin for Microsoft 365 when I try to add a card to import data I get the message 'Cannot insert data from a custom view'. I am not using a custom view. Any ideas what I am missing here?
Data Split between Many to Many Relationship Mappings
Hello Anaplan Community, I am encountering an issue with one of my development work and would be greatly appreciated your assistance. There are 2 different modules involved in my model: 1) INP01 Percentage Input by Product (Applies To: P3 List) 2) REP01 Percentage Split by Department (Applies To: Departments List) The…