Filtering by Users when Imporing

hyudolee

Hi, I want build a system several End Users can make the master data at the same time.

The point is EndUsers do it at the same time.

So I made a module which has Users as Applies To.

And EndUsers have to import this module to List.

But I could not filter by Users.

So data which another User made was imported at the same time.

How can I avoid this problem?

Accepted answers

Ingilavicus

Hi @hyudolee ,

If you build your user interface in NUX, you can simply use form to add list items and their properties, the only limit is that the users would have to add it 1 by 1.

I agree with @rob_marshall that you should be careful allowing users to add master data, as depending on the process you can introduce errors of all sorts.

But the simple way of giving the current user in exports is this:

In blueprint view under User List property select "Show All Users Off". This will limit the grid view to only current user, this will hold true when you use this module as your source for imports.

Andris

All comments

hyudolee

I could avoid this problem by making a filtering Lineitem.

Before Importing to List, end users will set own Users Item and filter the original module.

Another solution is making a temporary module.

- Module A ⇒ Module temp ⇒ List A

I can select the Users when importing between modules.

How do you avoid this?

rob_marshall

@hyudolee

Why are end users creating list members and why are these list members not coming from a Data Hub or a trusted source system? When you have users creating these list members, you are losing the audit trail, data governance, as well as creating an action for the users to run which can lead to concurrency issues.

So, before we start trying to figure out a solution for you, what are trying to accomplish and why?

Hope this helps,

Rob

ankit_cheeni

Hi @hyudolee

This might be a longer solution than you anticipate and has one additional step. I will try to mention it stepwise:

INTENT:

By default identify who is running the import and isolate one import action from another

STEPS:

Create a fake user list with all the mail ids present
Create a new module (M1) dimensioned by native User list and create 4 line items - import?, User List (formatted to fake user list), Write Access and Flush. This module will isolate users basis a boolean that they select before running the action. You will add a write access on Import? basis the write access line item. Attaching the blueprint here:
Create an action that imports the flush line item into the import? line item. we call this 'Action 2'
Create the module (M2) you are using to do the import and dimension it by the fake user list. We will filter this module basis the selection made by the end user in step 2. Attaching the blueprint here:
Create a saved view in the module created in step 3 by filtering basis the Filter line item
Create one action to import into the list with the saved view as source. we call this 'Action 1'
Create a process with Action 1 and 2
Create a new DB and publish 3 items - M2 with the required line items and users in the page, M1 with only import? line item and users in the page and the process
The step to import would then be
1. add your items to the grid with code and name (M1 view)
2. Check the import boolean. This basically makes the boolean inactive for other users till the action in the next step is run
3. Run the action. The second action removes any selection done in Import? line item thus the boolean is again active for all users.

hyudolee

Why does Write Access Lineitem exists?

If Write access Lineitem has Fake Users as Applies to,

I can not restrtict the Write access.

I think this Lineitem should have Users List.

Then I can restrict the access.

Are you going to do this?

Ingilavicus

Hi @hyudolee ,

If you build your user interface in NUX, you can simply use form to add list items and their properties, the only limit is that the users would have to add it 1 by 1.

I agree with @rob_marshall that you should be careful allowing users to add master data, as depending on the process you can introduce errors of all sorts.

But the simple way of giving the current user in exports is this:

In blueprint view under User List property select "Show All Users Off". This will limit the grid view to only current user, this will hold true when you use this module as your source for imports.

Andris

hyudolee

Hi, @Ingilavicus.

>>In blueprint view under User List property select "Show All Users Off".

I understand this.

We cannot avoid the concurrently issues?

@ankit_cheeni says we can avoid this issues by identifying the user who is running action.

hyudolee

Hi, @ankit_cheeni.

I made a module as you told.

But Write Access does not work.

I think this Write Access Lineitem has Fake Users as Applies to.

ankit_cheeni

Hi!

Yes you are right. the write access LI needs to have the fake user list as its dimension. My bad I used the name "User List" for fake list. I see that's what is causing the confusion here.

ALKA

Hi @ankit_cheeni ,

I think you misread her reply. I also tried this solution and write access LI when applied as write driver for Import? LI doesn't work.
Can you please review as it is not giving the desired result.

Thanks!

Quick Links

Can you help?

Unanswered questions

Best way to Architect Financial Statements in Anaplan for Scalability
I have seen two methods used to build financial statements and I am wondering what others have experienced in scalability/maintenance between the two or if there is a better approach. Assume that we have a flat data source for our general ledger within Anaplan. Our line item we are focused on within the source data is the…
Curious Comparison: Forecast Modeling for Unusual Products
I've been experimenting with some forecast modeling techniques in Anaplan recently and decided to test them on a few quirky, offbeat product categories just for fun. One of the categories I played around with was love dolls—yes, you read that right. It actually turned out to be more interesting than expected. Unlike…
OData Rest API for
Hi, Does anyone know how to get an outbound OData Rest API, (OAuth2) to establish a connection between SAP and Anaplan. Thanks Khaled