Modeling

When not to use Numbered Lists?
Given how flexible numbered lists are, is there a reason why I should not make all lists in a model 'numbered'?
Does reseting the index limit affects the list or list items in any way ?
I have came across a issue in which because of exceed in index limit the import is failing.So I looked into the Anapedia for this concern and got to know that I can reset the index of list if the following conditions are fulfilled :- If your list is empty and the Next item index is between 899,999,999 and 999,999,999, you…
Maximum Limit on Adding Hierarchy lists.
Hello, I need to understand what is the maximum limit on adding the hierarchies? I have tried adding upto 50 lists and the parent of List 50 was List 49. I am not sure if it has any limit or we can add without any limit. Can any one could help me?
Quarterly Account Sales Revenue Targets
Hello, I'm in the process of building the module for user story 1.11 and I am struggling to get the correct formula. I need to convert yearly data to quarterly data using the SYS99 Time Settings module (only line item dimension). My formula currently pulls the yearly total for each quarter which is incorrect. Any guidance…
Demystify non-linear optimization: Episode 1
Prologue The Anaplan community has been facing more and more interesting optimization problem statements every day while they solve complex business problems. Business challenges often involve finding optimal assignments such as sales reps to customers, demand to production capacity, or workers to shifts – all while…
Hide zero rows in Boards (modeler setting)
I want to be able to setup such a feature which will automatically hide zero lines from a Board if it is turned on. Problem: Filters set by model builders on modules are easily get cancelled if an end user pivots this modules. It may sometimes reveal the data you don't want them to see. My example is when I setup a filter…
Quarterly Account Sales Revenue Targets
Hi @JaredDolich @Misbah , How are you? I completed the User Story 1.11. But I have a question. When I select All Account, the % of Account Sales Target aggregate automatically. Any help would be appreciated. I am looking forward to hearing from you soon. Best regards. Wei
Level 1 Model Building Exam - Activity 6
I am trying to calculate the phone costs for a department in December 2020 and medical costs for a department in December 2020. The formulas I am using in REP04 are producing numbers, but they are incorrect. Here is REP04: It draws from SYS08: I keep getting the wrong number whether I use EMP02 or EMP03 in the formula.…
Supplied by line item SYS08
Hello, in Level 2 print 3, for the country summary report there is a reference to a line item Supplied by which is supposed to be in Sys08. Maybe did I missed something in my previous sprints but it was not part of SKU upload file and if it is suppoed to be a formula I don't know how to build it (where should the data come…
Calculating line item based on diffferent values in the list
Hi Anaplanners, I have a module dimensioned with 2 lists, loc1 and sample. Sample has two line items Sample 1 and Sample 2. There is a line item called Transportation. I want to add another line item called Transportation Sample1 vs Transportation Sample2 which should be Transportation for Sample 1 - Transportation for…
Turn off suggested list/line item names in new modeling experiance
Is there any way to turn off this feature? I often just want add a simple correction to a formula, hit enter and move on. Instead of just the minor edit when I hit enter to close the formula editing it grabs the first suggested line item or list name. For example I just need to add an apostrophe and want be able to just…
How to Find Combination of List
I want to Find combination of List. I have relationship of Customer-Product and Product-Supplier. Then I want to find combination of Customer-Supplier. Now I don't want to make Lineitem which has "Customer*Product*Supplier" as Applies To because of memories. What kind of formula should I set?
Option to display code not name
As a model builder, I would like the option to choose whether a list formatted line item displays the code or the name of the list item. Depending on the purpose of the module, the audience and the number of columns being displayed it is sometimes more appropriate to allow a user to view and select the code of a list…
Formula Help (Condition Statement)
Hi, I need help on creating a condition where if one LI is lesser than another LI, then my intra-month growth amount must be less than my write off amount. Not sure how I can make this condition happen in Anaplan. Please advise. Thank you
Export - Data Source
Hi Community, I am thinking that would be very beneficial for model builders to have the possibility to view Data Sources for Export Definitions. For the large models with lots of external integrations and different export actions is pretty difficult to follow the source of a particular export if you can have dozens of…
Applications of Newly introduced process/action timestamp .?
Hi Anaplanners, Anaplan is has recently introduced start date and time update w.r.t each process/actions run which has been very helpful. Is there a way through which this timestamp can be published on DB or used in model building..? Thanks in Advance. ~ABhi
NMX rollout - 20th Feb 2023!
After a change to the initial NMX rollout date - keep your eyes peeled for it becoming the Anaplan default this month! Here in UKI the date that this will become default is slated for 20th Feb - check out this article and video for answers to FAQs and some insight into what NMX has to offer.
Hierarchy Filters
Hi, I have a requirement where in if user selects a Boolean(Show Ending Balances) then it should show only ending balances (which is a top level for L1 description types of list) along with Ending Balance line item. Currently I have built the logic but when I apply the summary as formulas it throws an error. But previously…
Make Versions a Production List
Enabling Versions as a production list would allow business users (not developers) to add flexibility and enable business users better management of versions. Consider the scenario where there is a variable amount of Forecasts that could happen in a year, or if a Forecast becomes current/next.
A+ for Anaplan (Model Builder Edition)
A+ for Anaplan (Model Builder Edition) is an add-on for Chrome that has quite a few nice features: Link Unfortunately due to the sensitivity of the data that I and other companies/users work with, I am unable to utilize this add-on due to the required permissions. I would love to see these features brought in-house, if…
Dark theme/Night mode
As an Anaplan user/model builder, I find the white can be a little too much some times and not too easy on the eyes. It would be great is there was a night mode or dark theme that swapped the colour palette for something not as bright. This may also help with accessibility Thanks!
Production Lists and Ragged Hierarchies Logic
Assume the following Non-Composite list, ragged hierarchy, needs to be set to Production Data. We need to refer to the ultimate parent to define the logic calculation. In the example, we have assumed that children of Parent 1 and Parent 3 need to return the 'logic 1' value from the constants module below, and those under…
Community perspective: Smart Data Storage
We’ve all been faced with that question: to version or not to version. The requirements you face, together with your previous experience, will be taken into consideration to make that decision for each new model. But whatever route you decide to take, I think we can all agree that versions shouldn’t be used as storage.…
Copy/Paste & Copy Across/Down in NUX
Hey All, One of our cards in the NUX will now allow copy/paste or copy across/down. The model is deployed, and that particular line item has a dependent list format. The odd part is this works find in the dev version both with and without dependency in the list format. My only guess is that it's a numbered list, and we're…
Page Selectors Best Practices?
Hi, Is there some common techniques when publishing page selectors to a page verses publishing to a module?
Anaplan script is failing while executing remotely
Hi, I am trying to execute Anaplan script remotely but its failing with below error. Absolute path to JAVA 8 executable not provided. Will attempt to figure out path from JAVA_HOME or Windows registry... JAVA_HOME is not defined, will attempt to fetch value from registry... Checking Windows Registry for Java Version...…
Dynamic Sum based on Multi-Select in Context Selectors
This is an extension of already requested options to select multiple items in a UX context selector (for reference, see that Idea here and here). I wanted to call out the specific request that it be possible to have dynamic sum based user-selected context items. The point has been mentioned in these Ideas here above but…
Color Differentiate the "Write", "Read", "None" access levels for Roles--> Modules etc.
On larger models, the list of modules, dashboards, actions etc. can become very difficult to sift through. When setting user role access for these lists in Roles-->Modules, Roles-->Actions etc. it is difficult to notice issues because the whole list becomes just a sea of blue words, all of similar lengths. It would be…
Dependent dropdown
How Can I add filter by country and filter by segment in this: Accounts are dependent dropdown set up on country. Thanks -Pooja
Load monthly data into weekly time setting model
Dear Anaplanners I have a dump question whereby I cannot get it over yet. I have a model whose time setting is designed as weekly (for later stage replenishment planning) While the demand forecast is still by month, so I have an import module to load monthly history sales dimensioned as below: My source csv file looks like…

Modeling

Discussion List