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.
Hello, I’m running into a recurring issue when importing CSV files into Anaplan, specifically with dates in February for the years 2028, 2029, and beyond. Here’s what’s happening: In Excel, the date format is set to Custom (e.g., 2/26/2025). When imported into Anaplan, the date is interpreted as 26-Feb, where: Month = Feb…
I have an issue where I am getting the expected result from RANKCUMULATE when using one dimension, but when I add an additional scenario dimension to the module, it doesn't calculate the way I'd expect. Here are some screenshots to explain the case: Module 1 - calculates cumulative total for list items in list "Age"…
Hey everyone, I wanted to share the Anaplan Python SDK with you. It's a Python Library that wraps all Anaplan APIs and makes it easier to interact with Anaplan programmatically. It is mostly designed with Data Integration Scenarios in mind, but it does support all APIs including ALM, SCIM, Audit, and Cloud Works. Please…
