-
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…
-
Resetting Numbered List in Polaris Engine
Hi Community, I’ve been exploring the Polaris Engine and had a question related to how Polaris handles Numbered Lists, specifically in comparison to the Classic Engine. In the Classic Engine, we have the ability to reset a Numbered List , which clears the list and allows new items to start again from index 1. >Does Polaris…
-
Polaris Engine Suppress Zero Functionality
Hi Community, I'm exploring the Polaris Engine and came across the new "Suppress Zero" feature, which is not available in the Classic Engine. I understand that this feature helps to hide rows or columns where all values are zero, but I have a question specifically about how it behaves when the suppressed dimension is…
-
How to get input mapped to parent to pull through against child
Hello as context, I am creating an input module with no timeline that is effectively a dummy list 1-30, then a series of line items mapped to various lists such as Region (A-C), Shop Type (1-3), etc. Finally I have three line items - start date, end date & effect value. I can therefore say 'Adjustment 1 = +5% sales for…
-
Alternative of Rankcumulate
Is there an alternative to using RANKCUMULATE in Anaplan for cumulative ranking by group? The model's performance is impacted due to the use of rankcumulate. I'm looking for a more efficient approach or best practice to achieve cumulative ranking within groups without degrading performance.
-
'Delete task' Action on UX page
We have a 'Delete Task' action button on an UX page. The Action button is driven by a 'Run Action' line item which is TRUE if the Confirm Delete Boolean is checked. This setup works, but only if the user selects the full record (row) where Confirm Delete is TRUE. Currently, If a user checks Confirm Delete Boolean on the UX…
-
Stuck in Activity 2 of L1 exaam
Not able toidentify error. And what is this builtin. Kindly guide
-
Error reporting behavior for import using CSV file
We have a module applying list subset, and while trying to import list items that are not located within the subset using CSV, the system did not show any error message (ignore instead of failed), while another module was able to show item not located within the subset. I have checked the import action mapping, if the item…
-
Mapping from a module that is time dimensioned to a module that is not time dimensioned
I am trying to build a tool to manage my sprint. I have a module that is not time dimensioned I wanted to get the start and end date from a system module. The date comes correctly if I get it from a module that is time dimensioned as below But if I used a time dimensioned it does not come. The reason I wanted a time…