Import write access to List

hyudolee
Occasional Contributor

Import write access to List

Hi, I want to import write access  to Lists.

 

I have this type of table. 

UsersCustomer
axxx1,xxx2
bxxx2,xxx3

 

But the List item is shown by #1,#2 in User setting.

How can I import to List?

 

And I want to set the write access to combination List.

Now if I set this write access.

UsersCustomerProduct
axxx1,xxx2yyy1
bxxx2yyy2,yyy3

 

I want to set write access to combination list automaticaly.

UsersCustomer-Product
axxx1-yyy1,xxx2-yyy1
bxxx2-yyy2,xxx2-yyy3

 

Do you have any idea?

1 REPLY 1
s.jansenidw
Certified Master Anaplanner

Re: Import write access to List

Hi Hyudolee,

 

To be able to import read and write access into your user security of a model your import module should contain at least 2 dimensions: the user list and the list you're setting up security for. 

 

Using a boolean formatted line item you can filter out the valid combinations on the intersections of those 2 lists. By filtering on that boolean line item you can create an import view. 

The import view can be imported into the user settings part of the module, make sure you don't map the line item but map the list to the corresponding columns. The line item doesn't even have to be included in the view, it is only needed for filtering out the valid combinations. 

 

Let me know if this helps, 

Kind regards,
Stef Jansen in de Wal
Finext Performance Management