Modeling

How to vary the calculation used for each version for a single line item?
I have a large model that is used to generate a business forecast. Each time we need to generate a new forecast or scenario, a new version is added so that the inputs can be changed and the outputs then compared to previous versions. However, sometimes the calculations themselves need to change to reflect our evolving…
Production Data - Top level Can be Changed?
I have a scenario as follows: I have a List named "Product L1" which has been marked as production data. While I understand that structural changes can still be made to a list that has been marked as production data, I have noticed that the top level, which cannot be changed if the list has been marked as production data,…
Rank Formula Work Around
Hi! I have a module dimensionalized by a list of unique identifiers that is the child of a Location list. I'm trying to rank survey dates (a date formatted line item) in descending order based off of how recent they are BUT there are multiple UID's with the same survey date. The problem is, with the "RANK" formula, the…
Hold and Release functionality
It would be great to have "Hold and Release" functionality extended to NUX as well. Break back seems to be working fine with NUX but sad to see missing hold and release functionality. Hope this feature will be added soon. Thanks, Sandeep
level 3 4.6.3 Data Hub Model: SYS14 module
In the Data Hub model, create a SYS14 Create Account>Product system module * Dimensions: Account Flat, Product Flat Add lines items and functionality: * Data?(Boolean) filter to determine if ANY data for product SKU under the product * If you are using the Level 2 Data Hub model: reference the SYS12 SKU Details and SYS13…
NUX, Subsets, and Context Filters
Hello! I've got another unusual NUX issue I need some help with. I've tried to include relevant snips below, but as always happy to answer any questions and provide more info as needed! It has not been an issue until now, so we suspect recent Anaplan updates are the cause but have no way to verify beyond it being a new…
Module not showing all list items
Hello, I have a 4 tiered list hierarchy. On the lowest level I have thousands of items that do not have a parent and need to be deleted. I would like to create an action to delete these list items and add the action to an existing process to maintain good model hygiene. My challenge is that any module where the list is…
3.3.12 Activity: Create Product Replenishment UX Page
Hello, I am stuck with 3.3.12 Activity: Create Product Replenishment UX Page. I have saved all required views and trying to create a board based on SYS00 and INV01 modules. When I link SYSS00, it shows data in not editble view. can you please advise why its so?
Handling Forecast Outliers
Greetings Anaplan Community, We are currently using the Anaplan statistical forecasting model for our demand planning, and a question has come up around how we can better handle outliers that can drastically skew our forecasts when there are periods of zero demand. We have a process for manually backfilling demand in these…
Sort Workspaces in Model>Model Import View
When setting up an import and selecting the "Connect to Anaplan Model" option, if you need to navigate to a different Workspace, you may be in for a bit of a maze. The workspaces are randomly sorted today, when nearly every other view (manage models from home page, new breadcrumb navigation in updated modeling experience)…
Model building checklist
Author: Nicole Johnson, Senior Anaplan Model Builder at Autodesk. I love a good checklist. Naturally, that passion comes through when I plan and build enhancements for an Anaplan model. I've created a model building checklist that I use to think through and document changes I need to make to a model, and I'm sharing my…
Issue while accessing 90 days free trial
I got the error while I was building a model. URL Path: * https://us1a.app.anaplan.com/a/modeling/customers/8a81b00e7122e5db01715001231c1f6c/workspaces/8a81b00e721f39240172397f56a47aed/models/A98B6141757B4170A4BD5B4CCB9E9ED8 * Client session id: Rzl22sFEp Please advise.
Lag Function without Time Demensions
Hi Anaplanners, I am trying to model a queue building up in Anaplan and I am wondering if there is any way I can use the Lag function to return the adjacent value without time dimensions. The principle is to add the queue from the previous segment and add to the current segment, however the model does not have any time…
January 2023 releases and February sneak peak
Hopefully you've all been able to get your head around the new Community platform. Hint: always go to product.anaplan.com for new platform related stuff! No doubt @Paul & @CatherineH will bring this up in March but there's been a tonne of new-ness released and we're only in February. For me shapes in Management Reporting…
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.…
Sprint 3 - 3.5.3 Activity: Create Distribution Center Summary Module
Hi, Can somebody please tell the formula for this line item in this activity? In the Supply Chain model, create a new module: * Module Name: INV03 Distribution Center Summary * Dimensions: P2 Products list, s G3 Location: Distribution Centers? list, Time (month) * Category: Inventory * Functional Area: Inventory * Summary…
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…

Modeling

Discussion List