Selective Access

Hello,

My model consists of hierarchical lists, E1 Expense category, E2 Expenses. I created an input module with E2 expenses, time(months), Money spent (line item) as dimensions.

I have applied filters such that user shall select E1 expense category(in user filters module) and input module shows E2 expenses of selected E1 expense category only. Now, I would like to restrict user to read or write specific E2 expenses.
For example, under Fuel expense category, expenses are "Bike and Car". User1 shall only write "Bike" and not read Car. User2 shall only write "Car" and not read Bike.

But both of them shall able to select "Fuel" from the expense category dropdown. How to achieve it?

Thanks in advance

Accepted answers

All comments

MarkWarren

Take a look at dynamic cell access to drive this functionality in your model.
Dynamic cell access - Anaplan Technical Documentation
Dynamic Cell Access - Anaplan Community

[Deleted User]

Thanks Mark.

I would like to add an additional point too.

As I mentioned earlier, User1 shall write "Bike" and not read "car". When I apply DCA, User1 can't read data of "car" but can view the list item "car".

Here my requirement is, user shall only able to see the list items, to which he has access and input the data by choosing its parent level item(from dropdown).

In this case, User1 shall able to choose E1 expense category(Fuel) and module shows list item(car) to which he has access only.

Thanks in advance

Quick Links

Can you help?

Unanswered questions

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…
Looking for Anaplan End-Users to take a short survey!
We are looking for Anaplan end-users to provide feedback on their experiences with the Excel add-in. Interested individuals will respond to this 5-minute survey to help us understand personal needs and behavior when using the add-in. The feedback provided by survey takers is essential to the roadmap of Anaplan's products.…