-
Add list members to a selective access list
Hi, I am working on a solution where the User should only have access to write/edit the list members that they add from an Action on the frontend. This action adds another list member to a selective access list. The problem is, in order to run the action, you need access to the entire list, so you would see all list…
-
UX Filter
Hi ALL, I have a module where a line item (Assignments column) is formatted by a large ‘Projects’ list. Each record is assigned to a Project and this module is published to a UX page. When users apply a filter on the Assignments column, the filter dropdown displays the entire Projects list (since the column is…
-
How do i convert from a ragged hierarchy to a composite hierarchy?
I have my dataset attached below https://us.v-cdn.net/6037036/uploads/SAQ9CR8PDLSM/ragged-cost-dataset.xlsx
-
Dimensionality Issue
Hi ALL, In my model, I have Need stored at a 'D3' RS Group level. I need to use this Need in another module at the G5 Location level. I currently have a mapping module where each G5 Location maps to a D3 RS Group. This Module uses D2 Role as dimension. but the line item I've to find the RS Group (Find D3 RS Group = 'FIND…
-
Create a Mekko chart in Anaplan
Hello Anaplan Community, I’m interested in creating a Mekko chart within Anaplan, but I’m unsure if it’s possible. I’ve read several articles but haven’t found any examples or guidance. Has anyone here created something similar? Thank you!
-
Fiscal Year 2025 and 2026
I am trying to configure Week 52 for the year 2025 to span from December 20th to December 31st and Week 01 for the year 2026 to cover January 1st to January 9th. Despite my best efforts, I haven't been able to find any articles or resources that provide guidance on setting up a customized fiscal calendar in this manner. I…
-
Time filter settings
i have a time settings module dimensioned by time and version. I need to check for months and years in one line item. Is there a formula i can use that will only allow me to tick for months and year and exclude Quarter?
-
Native version Limitations
I have created a time settings filter with native version as a dimension. I am suppose to tick true for all the actual months. In Actual version the actual months will be until Aug 20 (because my current period in model calender is Aug 20). A switchover is applied for budget and forecast which is at Feb 20 and Sep 20.…
-
filter only one or more parent
Hi, I need help. I have a hierarchical Line Item Subset (LISS) in my model. Sometimes, I want to select a parent item directly in a filter, so that only the parent is displayed — not its children. The challenge is that on a LISS, I cannot tick a parent in a module (since Anaplan only allows selecting child items). I tried…
-
Convert anaplan date format
The default date format in Anaplan is mm/dd/yyyy. How do i change the date format as dd/mm/yyyy. For example, In my source file the date is 7/12/2020 which is dd/mm/yyyy. I would like to maintain this format in anaplan. If i reference the date 7/12/2020 in my period formula the output should be Dec-20 and not Jul-20.
-
SUM QUESTION
Dear all, I need some help to create a target module. Currently, I have the following modules: Source module with the following dimensions: products (list) and Time (Month). 1 line item : Quantity Mapping module with the following dimensions: products (list). There are 2 lines items : Site and Molecule I have created the…
-
I am getting error while submitting the assignment,please give me suggestion.
Please suggest why it is not taking submit.
-
Unable to use one page for multiple DEV models that are partially in sync
Hello, Our model builders are normally making changes to all structural changes in a DEV model. Because we are now in a Prod freeze and we don't want to move structural changes to PROD until end of year, we created a copy of the DEV model (standard mode) - 'DEV2' model, where we are only making changes to urgent issues…
-
How do I show only those line items which have non zero values for list and time dimension?
I want to see only those line items which are not equal to zero from a hierarchy list subset in a module dimensioned by time as well. I am looking forward to create a line item which I will apply as a filter to the module. I have 15+ line items but the filter should only show those line items from the list subset for every…
-
Anaplan for Microsoft 365
Using the excel addin for Microsoft 365 when I try to add a card to import data I get the message 'Cannot insert data from a custom view'. I am not using a custom view. Any ideas what I am missing here?
-
Total Figures for shop based on list item mapped to other lists
Hello I have a calc module (CALC1) structured around a dummy list 1-20, plus a series of dimensions such as Region (1-3) and Shop Type (A-C), plus a timeline. This dummy list lays out a series of revenue adjustments over time based on the dimension categories, such as [+5% revenue for region 1, shop type c across periods…
-
Data Split between Many to Many Relationship Mappings
Hello Anaplan Community, I am encountering an issue with one of my development work and would be greatly appreciated your assistance. There are 2 different modules involved in my model: 1) INP01 Percentage Input by Product (Applies To: P3 List) 2) REP01 Percentage Split by Department (Applies To: Departments List) The…
-
Hiring: FP&A Professional with Anaplan Level 2 or Master Anaplanner Certification – US-Remote
Hi Anaplan Community! We’re currently sourcing for a Manager Anaplan Financial Systems that blends deep financial planning & analysis (FP&A) experience with technical Anaplan model building. Ideal candidates will have: 10+ years of FP&A or finance analytics experience Proven success in strategic planning, budgeting, and…
-
ADO - Another Key Has Already Been Processed With This Key
Hi All, So I am getting an interesting set of errors when pushing to a hierarchy in a model from ADO: This is a 10 level hierarchy, and there are no errors for level 10. I have tried pushing data to a hierarchy with the first 9 levels only with no issues at all, so it seems to be an issue with the 10th level. I have…
-
Performace responsiveness In Polaris Engine
Hi Community, I have been exploring the Polaris Engine & trying to better understand its performance compared to the Classic Engine. Assuming I have a module with the same structure, same input data, and identical calculations in both engines: >Which engine is expected to perform better in terms of calculation speed and…