Drop-down list showing only Write-access list members
My client uses the Organization structure as the secured dimension in the model I am working in (Business Unit / Cost Pool / Cost Center) with Business Unit secured.
They have multiple modules (pre-existing model in which I am making major modifications) that contain these lists as line items but are NOT used as a dimension for the data.
There are dashboards where I have employed filters to only show records from these modules that contain the Business Unit selected.
The selectors for the filtering are contained in a basic filtering module, dimensionalized by Users with line items for the various filtering drivers.
Security – setup to Read access ALL Business Units with Write access limited to 1-5 members.
Problem – the filtering drop-downs include ALL Bus, not just the ones where the user has Write-access. This is an issue as it potentially allows someone to make changes in a dashboard to information associated with a BU for which they only have read-access.
Solution –
- Create a series of processes (based on user security) to build a list that is Write-access BU’s rolling to a pseudo User list for each user in the model. This is a mainly automated process but does require some intervention to account for users who have access to “total organization.”
- Build the filter for BU based on this new list (Dep DD list).
With a few minor modifications to tie this list to the original BU list this works.
My question – is there an easier and more straight-forward way to only list Write-access list members in a drop-down list? I tried to come up with a way to do this via Dynamic Cell Access but could not find a way to make it work.
Comments
-
Alenart Member, ALL USERS, GroupMember, Community Member, Certified Model Builder Posts: 5 ContributorI was able to come up with a suitable solution. I will post the specifics when time allows.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