nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Using Model Role to filter

BrentOrr

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?

Accepted answers

All comments

JaredDolich

@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.

BrentOrr

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.

Misbah

@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

Amaya

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...

Amaya

If we want to do this, we may have to prepare a dummy role instead of "No Access". And we can't set the dummy role as a default, can we?

Yash1

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

CommunityMember125037

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

ariachris56

Good reply Jared.

Quick Links

Can you help?

Unanswered questions

Anaplan ⇄ Google Sheets pivot tool — feedback welcome
We've been building a tool called aplan4sheets and we'd genuinely like input from this community — both on what we've built so far and on what we should prioritize next. The problem we set out to solve: Anaplan's Excel add-in is Windows-centric, and there's no real native way to pivot Anaplan data in Google Sheets. We…
An Update on Anaplan Audit Log Reporting: A No-Code Approach
A while back, I shared a pattern for extracting and reporting on Anaplan audit data using a Python project hosted on GitHub. I wrote that during my time on the Operational Excellence Group (OEG) at Anaplan. The Python solution still works, and plenty of teams are running it today. The problem it solves hasn't changed:…
Looking for Anaplan End-Users to take a short survey!
We are looking for Anaplan end-users to provide feedback on their experiences with the Excel add-in. Interested individuals will respond to this 5-minute survey to help us understand personal needs and behavior when using the add-in. The feedback provided by survey takers is essential to the roadmap of Anaplan's products.…