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.
All of my DATA01 is cleared after 2019, is there any way I can fix this?
I am attempting to connect to an azure SQL database vis at the MSSQL connector in data orchestrator but am having issues and I believe it is due to hyphens in database name (which is a fairly standard naming convention I will note!) Example below (fake credentials) - has anyone else encountered similar and is there a way…
Hello folks, Does anyone know how to work around the Polaris limitation of using the Formula or Ratio summary method alongside the Closing Balance within the same line item? I have a Business Unit list where the total (All BUs) must display the Corporate (1 of 20 leaf items under All BUs total) number of Unique Customers.…
