Selective Access - SUM

Hi team,

I have an #Employees list with Selective Access enabled.

The Source module has the #Employees list with properties such as Department etc as line items. My target module has Department as a Dimension and I wish to SUM on Department but it is returning the value of all the List items with that Department, not just the items this User has access to

Should the value returned not only be the SUM of items that match the formula criteria for which the User has access to?

Many thanks

Mark

Accepted answers

nathan_rudman

In Anaplan, unless you have the user as a dimension of the line item, calculation executes independently from user access.

If you give access to a module that has aggregated information, the user will see them, regardless of their access at a more granular level.

All comments

Misbah

@MarkTurkenburg

If the selective access is enabled on Employee list then it won't work when you are SUMming on Departments. You have to apply selective access on Departments in order for that to work

Hope that helps

Misbah

nathan_rudman

In Anaplan, unless you have the user as a dimension of the line item, calculation executes independently from user access.

If you give access to a module that has aggregated information, the user will see them, regardless of their access at a more granular level.

MarkTurkenburg_*8288

Thanks @nathan_rudman that makes sense

So Selective Access does not change any formulas or rollups within Anaplan, merely hides list items from view. If you reference a list without a common dimension it will return the top level, even if the User only has access to certain child items (This is also true of Lookups, Select & SUM functions)

To adjust the rollups to attain the aggregated/top level view for the User you need to create line items that are dimensionalsed by User & the value is only returned if the User has access (determined by a Boolean). This will create a line item with only the values for which they have access and the Top level will be the aggregation of these values

nathan_rudman

correct.

that's why we often try to create a level in hierarchies that match user groups, so it simplifies this

MarkTurkenburg_*8288

ok yes that makes sense

Do you have a link to any articles about this? Would be helpful

I'm rolling out Connected Planning and the most difficult aspect if creating dashboards which the correct data per User for totals etc

Quick Links

Can you help?

Unanswered questions

Request for Workflow Design: End-User Report Finalization & Stakeholder Notification with Version Co
Hi everyone, I'm looking to design a workflow and would appreciate your input or guidance on how to set this up effectively in Anaplan. So, the goal is: Once end users complete their data input, they should be able to trigger a process that: Notifies stakeholders via email with a link to a report. The report includes: A…
Generating Failure Dump - even though no warnings/error in Actions
I've few actions in our Supply model which when run takes some time on the "generating failure dump" step at the end of the action even though the import is a full success without warning or errors. This is just a few seconds when run for a single action, however we have a process with 120 actions, and most of these…
OAUTH 2.0 vs Google Sheets Extension
Hi, My org is looking to explore leveraging Google Apps script to extract data out of Anaplan and update already built templates in Google Sheets. We use the Anaplan Extension currently but find it crashes often with the amount of tabs, data, etc. Has anyone used both Anaplan OAUTH 2.0 API and Goolge Apps Script to write…