Hi,
I am trying to create a module with the ff details :
Dimension :
List : Users
Line item : Roles ( format is list - roles)
Is there a way to create a formula for the Line item so it will pick up the role in the User setting?
Thanks!
Hi @Ana22
Unfortunately it's not possible to get user roles from User settings with a formula.
Best regards,
Pyry
Hi @Ana22,
Unfortunately, there is currently no way to do that automatically (there is a proposal to implement it: https://community.anaplan.com/t5/Idea-Exchange/Create-a-Formula-to-Reference-a-User-s-Model-Role/idi-p/80678). As a workaround you can export Users settings table and reimport it into some module, create list of roles based on that etc. However, then you need to be careful to update it any time users' access changes - that's why probably it's a task for data integration/automation.
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:…
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.…
Estimated Level of Effort:4-8 Hours of Model Building Level of Difficulty: Beginner Recommended Training: L2 Model Builder Training Persona: Casual Model Builder Potential ROI: Decreased planning time Increased accuracy of targets/spreads You Might Also Like: * Historical Snapshotting Top-Down Allocations Whether it's…
