I would like to filter a module which uses a list of users (either actual User list or a regular list which is a copy) by the Model Role each user has been assigned. Cannot seem to figure out how to import the model role into a module. Ideas?
@BrentOrr
Great question.
You won't be able to filter directly on the users for role but what you can do is export the user list (which contains the role) then import it into a system module where you can build your filters.
Others have asked the same question
https://community.anaplan.com/t5/Anaplan-Platform-Discussions/Creating-a-formula-to-directly-change-a-User-s-quot-Model-Role/m-p/35290#M1526
Some good responses in case you want read about it.
Thanks for the response Jared but if it can't be done directly then it would be easier to add a manual workaround within the model vs export/import.
@BrentOrr @JaredDolich
There is no way we can do it in Anaplan as of now.
By the way I was thinking What if we had attributes tagged to the Inbuilt Users list. All we had to do is click and refer
Amazing, wouldn't that be?
Misbah
How about thinking about it from the opposite.
Create a module to maintain user properties and roles, and import data from the module to the user list.
I have not done this experiment, though...
Hi @BrentOrr ,
An alternative approach:
1. If an API can be written to export the User information to a file at a fixed location.
2. This export can be loaded to a module.
Let me know if this sounds feasible.
Thanks,
Yash
Hi,
1. You can build a module with the users list and then publish it to dashboard.
2. Then create 2 actions,
a. Where the user can be added as an entry into the module and
b. Use this module to import the users into the user list by using a process and attach an import action to it.
The import action will basically import the user data from the module to the "Users" list.
This way it'll be automated also.
Hope this helps.
Thanks
Neel
Good reply Jared.
Hi, I am working on a solution where the User should only have access to write/edit the list members that they add from an Action on the frontend. This action adds another list member to a selective access list. The problem is, in order to run the action, you need access to the entire list, so you would see all list…
Hi ALL, In my model, I have Need stored at a 'D3' RS Group level. I need to use this Need in another module at the G5 Location level. I currently have a mapping module where each G5 Location maps to a D3 RS Group. This Module uses D2 Role as dimension. but the line item I've to find the RS Group (Find D3 RS Group = 'FIND…
I couldn't find any formula to do this, but I want a way to put on the page/grid the connection details. This is so I know what connection I'm in rather than going into Connections details to see it. Is there an XL3 formula to return this value?