How to synch user on the page with items of list displayed on the page
Hello,
So I've been trying something I thought easy but encountered some problems, what I've been doing wrong, here is the situation :
=> User going on a page to enter some info about themselves in a board (grid).
They open the page. They have to select their user name, as "Name", because their name in the database is different from their "Anaplan Users" names.
Here is what I want to do :
=> User going on the page, the page is automatically synched with their "Name", based on their "Anaplan Users" name.
What I did :
=> Module, with "Users" as a dimension, displayed on the dashboard, while in backend I have a module based on their "Name" (why double-module ? well today lots of calculations depend on this "Name", I don't want to re-write all my formulas for a little change like this). User enter their info in the dashboard based on their "Anaplan User" name. Then I take this info in my backend module thanks to a formula.
(/!\ I don't want to have an import to make, users don't want to click on buttons).
What my problem is :
=> Every formula I tried gives me the error : "Invalid formula for INPUT_BACKEND_Employees.Value: Automatic sum of INPUT_DASHBOARD_Users.Value over Users hierarchy is not possible as Users does not have a built-in top level"
But the thing is, I have the same dimensions, I don't need to do any sum for my modules, I don't understand what's going on here. Did someone encountered the same error ? How to fix it ?
Camille.
Comments
-
Hello Nathan,
Thank you for your quick answer, I tried but I have a new error showing : "Invalid use of 'Users' list with function 'LOOKUP'"
After some research I came around this : https://community.anaplan.com/t5/Anaplan-Platform/Users-list-and-Lookup/td-p/36132 , does that mean that what I'm trying to achieve is impossible without imports ?Camille.
0
Categories
- All Categories
- 2.3K Anaplan Community
- Academy
- Anaplan Talent Builder
- Model Design Course
- The Anaplan Way
- Archive
- 2 Idea exchange
- 62 Enterprise Scale
- 1.1K Extensibility
- 21 Intelligence
- 1.6K Planning & Modeling
- 331 Security
- Community Connections
- Connections
- Experiences
- Groups
- Personas
- Employees
- CS Toolkit
- Customer Care Center
- Forums
- Academy & Training
- Community Feedback & Updates
- Japan
- Anaplan Community Japan
- Anaplan Community Japan Knowledge Base
- HyperCare Japan
- JP-Central
- Support-Japanese
- Partners
- Partner Leadership Council
- Partner Product Council
- 724 Platform
- Anapedia
- App Hub
- Centers Of Excellence
- Extensions
- Planual
- Platform Updates
- 724 User Experience
- Profile Builder
- Resources
- Anaplan Advocates
- Anaplan Live!
- Community
- Community Advancement
- Community Connections
- Partner Program
- The Official Master Anaplanner Program
- Videos
- Welcome to the Anaplan Community!
- Success Central
- Support
- Case Portal Link
- Common Support Questions
- HyperCare Redirect
- Known Issues and Workarounds
- Support test page
- SupportFAQ
- Survey
- 2 Training Day Takeaways