User based delete action

I want to give a functionality to the user where they can select a Boolean (say basis state) and delete the data in a transaction list that are mapped to that state ( in a line item in the system module). see table:

State	Check to delete
A
B	Y
C
D

Since the user has selected the boolean for B, only those transactions are to be deleted that have B mapped to them.

However, since different users take care different states and all of them will be in the system at the same time, I want their selection in the grid above to be user dependent and thus the delete action to only delete their state data.

The problem i am facing is if I add a user dimension to the selection grid, I would not be able to use it in the delete action LI. If I dont separate users, they will override each other and might delete someone else's data

Accepted answers

All comments

Misbah

@ankit_cheeni

You can have Users as a dimension and the using the action.

Also It is not the good practice to allow users to use that kind of action (even without user dimension) which does all sort of heavy lifting. I use this exercise mostly for optimization purpose only and I usually I ask admins to take care of that.

Have you thought about using selective access on the state list so that only the user who is supposed to override/delete the values should be able to do it. And for overriding you can create a line item (Formatted as NO DATA) and run the import action.

Hope that helps

Misbah

Yash1

Hi @ankit_cheeni ,

As you mentioned that different users take care different states , so can you not have selective access across the state list, that ways a user will only see there concerned states.

Thanks,

Yash

ankit_cheeni

Misbah,

The list we are deleting from isn't rolling up to State. State is mapped in a line item. So even though State has selective access, the list does not.

This is the structure:

Module 1: has no dimension but a LI formatted to state for state selection.

Module 2: (dimensioned by the list we are to delete from) has a state LI and a delete line item. This delete line item looks if the state is the same selected in the Module 1.

The delete action then deletes using this delete line item. The problem here is that as soon as another user selects some other state (even after Selective Access being on) the state changes to that and wrong set of data would get deleted.

If I use User dimension in Module 1, I will not be able to create a Delete Action for the concerned list as the delete action needs a two dimensional module, with the concerned list as one dimension and Delete LI as the other.

Let me know if this clarifies the requirement

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…