Formula for Role of user

Ana22

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!

Accepted answers

All comments

pyrypeura

Hi @Ana22

Unfortunately it's not possible to get user roles from User settings with a formula.

Best regards,

Pyry

M.Kierepka

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.

Quick Links

Can you help?

Unanswered questions

How can i export accuracy metrics from Anaplan Forecaster to Model.
There was an error rendering this rich post.
A reminder of Bulk Copy - Current year to Prior year version for YoY analysis
A quick reminder of the Bulk Copy functionality. Bulk Copy allows you copy large volumes of data from one slice of a model to another in a single, optimised operation, instead of using formulas or imports. Use case: copy a version (RF1) into a prior year version (PY RF1) using a versions list to allow for year-on-year…
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.…