Importing User Data For Selective Access with multiple Items

Hello,

I'm trying to design a process to update my user access by importing user data from a module. It works for the most part, except when one user needs access to multiple items in a selective access list. I've tried importing the list items as "Property 1, Property 2", but I get an error "Item not located in Property List". Is there a different way to give a user access to two or more items in a selective access list?

Thanks!

Nicole

Accepted answers

rob_marshall

@nhardgrove ,

Please take a look at this following post, hopefully this helps you solve your issue.

https://community.anaplan.com/t5/Anaplan-Platform-Discussions/Selective-access-for-lists-from-dashboards/m-p/45982#M5633

Thanks,

Rob

All comments

rob_marshall

@nhardgrove ,

Please take a look at this following post, hopefully this helps you solve your issue.

https://community.anaplan.com/t5/Anaplan-Platform-Discussions/Selective-access-for-lists-from-dashboards/m-p/45982#M5633

Thanks,

Rob

nhardgrove

Thanks Rob, That post did help.

I changed my user access module to have User and my selective access list as the dimensions and set the line item as a boolean to indicate if the user should have access to a particular list item. I was able to import to user access with this change.

rob_marshall

@nhardgrove ,

Good deal, glad I could help.

Rob

paolovm

Bit of an old thread, but i was facing similar issue and found something which might be a simpler solution

if you're using the TEXTLIST to summarise items that are on another list you could actually just import directly from the source model into USERS tab.

Ex. If you have a source view in this format

Fake User 1	Product A
Fake User 2	Product A
Fake User 2	Product B

When you import fake user 2 into the USER tab the result will be PRODUCT A, PRODUCT B which is what we want in this case.

rob_marshall

@paolovm

Using TEXTLIST is really bad for performance reasons, so it is best to stay from that function if possible.

Rob

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…
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…
Exports with anaplan using informatica connector
I'm trying to execute an Action to export data with the use of a Mapping in Informatica. But it gives us null rows .If we export directly from Anaplan , the export file has all the rows filled. Both exports have same number of rows but in the informatica export the values appear as blank. This issue is with only some…