Avoid drill down to sensitive data

Hi folks,

I have a challenge in a Workforce Planning model I am building.

I have a organisational hierarchy going från A1→A6, where A6 being individual employees, and A4 being Cost Center. The selective access for the model is on Cost Centers (A4), which then gives access to Teams (A5) within the cost center and all Employees (A6) in the teams.

The problem with this set up is that I want the users to be able to see summaries of other Cost Centers (A4) but also higher up in the hierarchy (A1→A3). However, I do not want them to be able to see data below A4 level (A5 or A6).

My idea was to set up a parallell hierarchy with only A1→A4, call it B1→B4, and then sum over some properties with the new hierarchy on A4 level, but since any user can use drill down, they will always be able to go down to the actual individuals making up a specific figure, which is something I need to avoid.

The only solution I see, which I do not like, is to create an action to copy the data from A4 level to another module with the parallell hierachy, but that would require an actions, hence the data wouldn't be 100% live as it would with formulas.

I hope this makes sense, happy to elaborate if not, and any help is highly appreciated! Would really like to avoid the action…

Accepted answers

All comments

andrewtye

Hi @fredrickstraube

It's a bit fiddly but you could use DCA to disable the unowned Cost Centres employee details. So a module that's user and cost centre with boolean for the owned ones and then attached to your core modules.

Then should be able to use your alternative hierarchy module or set the DCA so that it's true for all the parents. Think then on an unowned CC it won't show the values but might show the people

fredrickstraube

Hey!

I would really like to not have to add the user dimension to all the modules containing sensitive data, that would make my model **** up in terms of size…

Otherwise that would be a possible solution!

josephwood

You shouldn't need to add user to all the modules, just the DCA ones so it shouldn't too much size.

Quick Links

Can you help?

Unanswered questions

Create a Filter to show all the elements of that level based on selection in hierarchy
Hello Community members, Requirement Details: I have 5 levels of composite hierarchy list (A1, A2, A3, A4, A5). I have published a module in UX, Now the requirement is If user select a list member from A4 level in the context selector or Custom Filter I have to display all the list members under that A4 level. How can I…
import monthly data with months in columns
is there a way to import data with months in columns (usual excel table view)? I have to transform the data so there are rows to cover each period in the upload data form, but I am wondering if there is a better way to just import the data as is with the months in the columns. please let me know what you think. thank you,
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…