Model Builder

3.4.3 Activity: Create Country Summary Module
Hi, I have a doubt in level 2 sprint 3.4.3 Activity: Create Country Summary Module I did the following :- Step 1 → Created a new column "Country Made in" in SYS08 SKU details Step 2 → Wrote a formula Parent(Supplied By) to bring parent of the location i.e. country in "Country Made in" column Step 3 → I have written the…
SUM and LOOKUP | Model Optimization Team series
Hi! Welcome to the Model Optimization team's monthly blog post. This is an eight-part series, following the topics we see occurring most frequently in slow customer models. Our aim is to inform and guide how to build with best practice intentions for these model building topics. Each month, two of our analysts will take…
Converting Text to Date and Date to Text
Author: Julie Ziemer is a Certified Master Anaplanner, Anaplan Community Boss, and Solution Leader/Business Analyst at Akili. While Anaplan has specific functions to convert between data types, converting Text to Date and Date to Text are two commonly searched topics on Community and they require the use of several…
Best Finding for Truly Understanding Optimizer (Conceptually & Technically)
🚀 Best Finding for Truly Understanding Optimizer (Conceptually & Technically) One of the most effective ways I’ve found to deeply understand Anaplan optimizer both conceptually and technically is by working hands‑on with Excel Solver. Why? Because Solver forces clarity. It makes you explicitly define: 🔹 Decision variables…
Default today's date on UX with ADO
Hi everyone, I am trying to make a UX Page with today's date as default. That means, everyday when I enter in my UX page, I will see today's date (so the date will change everyday) and the figures related to the date, will change accordingly. Any ideas or tips&tricks? I need to men tion that I need to use ADO and not…
Anaplan Export (Tabular Multiple Column): Saved View Line Items
When exporting from Anaplan using "Tabular Multiple Column", will the export include only the line items saved in the saved view, or will it also export line items that are excluded from the saved view?
Model Bulder Mini Resume - Thiago Liberman Trajano
Mini Resume Name: Thiago Liberman Trajano Location: São Paulo, SP, Brazil Certification: Anaplan Certified Model Builder (Level 1 & Level 2) SCRUM Master Oracle Cloud - Data Science Educational Background: Degree in Economics from PUC-SP Master Degree in Economic Development UNIFESP Professional Master Degree in Data…
Data Hub: Will multiple imports and loads at the same time slow it down or lock it?
If two spoke models pull data from the same Data Hub at the same time, will it slow down the Data Hub or cause any locking? Also, if the Data Hub is being loaded/updated with a different set of data while it’s sending data to two spoke models, will that slow down the Data Hub or cause any locking/issues?
Create export template for Anaplan users to import using months
Author: Tyler Beck is a Certified Master Anaplanner at TBLB LLC, and is currently a Team Lead at CVS Health. Use case An end user needs to export a template from Anaplan using Months as the time period in columns, and qualitative data in rows. When the template is exported as a CSV file the years in the dates turn to days…
Result from ISNOTBLANK() is not aligned to LENGTH()
Hi Anaplanners, I have encountered this super weird situation where I am using ISNOTBLANK() formula to identify if there's any characters in my Parent Reporting Sub-Segment (PRSS) column, but some rows (see ss below) is showing ISNOTBLANK() = TRUE even when there's no inputs. When I tried to troubleshoot this with LENGTH()…
Lookups to apply to LISS Parent Line items
Hi Anaplan Community, I'm encountering an issue with my Anaplan model where a lookup function isn't picking up values from line item subset with line items that have "Is summary" turned on. If I keep the "Is summary" checked in the source module, the only way I can retrieve the values in this line is by using the "SELECT"…
Do scheduled CloudWorks actions run in parallel or sequentially?
If we schedule two CloudWorks actions to start at the same time, using the same source model but different saved views, and updates two different target models, will they run in parallel or sequentially (with one finishing before the other starts)?
Fiscal to Gregorian calendar conversion in Polaris
Author: David Edwards is a Certified Master Anaplanner and Associate Partner at Columbus Consulting. For retail and consumer goods companies, a common issue occurs when different departments (typically supply chain and finance) utilize different calendar structures. Supply Chain teams often rely on a fiscal calendar (such…
Complete Training for Model Builders from Anaplan Academy
New, aspiring, and experienced Model Builders can now come to Anaplan Academy for all the training they need to improve their Anaplan skills. Here’s an overview of the three levels available on demand in the Learning Center or with an instructor either in-person or virtually. Level 1 Model Builder Training is meant for…
🚀 Stop Writing Nested IFs in Anaplan - Use LIS Instead
If you’ve built complex Anaplan models, you’ve probably written formulas like this: IF A THEN IF B THEN IF C THEN Value1 ELSE Value2 ELSE Value3 ELSE Value4 It works. But it’s slow. It’s hard to debug. And six months later… even you won’t understand it. Let’s talk about why nested IFs hurt performance and how Line Item…
L3 User Story 2.4
Hi Community, In L3 User Story 2.4 requires the comments to be seen by others. Who should see the comments? That Country Sales Manager's ? and do we have to create a link or add an line item for comments associating with all accounts and then publish it do UX so end user can add comments along side of the accounts…
issue with DEM04 export
Hi Community, @Misbah @MikhailErgyun I’m currently working through Level 2 and have a question regarding module cell count and Time Ranges. In my DEM04 module, the initial cell count using the Model Calendar was 547,596. When I switched the module to use a Time Range (FY19–FY21), the cell count reduced to 395,486. However,…
DCA is active for an ID, but data is invisible
For a line item, where DCA read and write both accesses have been provided to an ID, but that person can't see any value. The ID has full access to the model, only difference is, the ID is not WSA. Can this make any difference? To clarify more, that particular line item has four dimensions, i.e., Users, List1, SS:List2,…
How to identify if I have access to Polaris WS ?
How to identify if I have access to Polaris WS ?
3.3.5.2 Inventory Ordering Module Formulas
Hi, I belive My Formula is correct for Beginning Inventory line item of 'INV01 Inventory Ordering' Module and I made some mistake in SYS01 Time settings by week Module with the Line item 'Not 1st week of Timescale?'. Do i need to change anything in SYS01 Module. In the INV01 Module the value is increasing instead of…
Remove Aggregation of period but not amount
Hi there, I am trying to upload a flat file into anaplan. There are multiple records that are duplicate. I know when I load the data it removed the same records and aggregate the values. I am okay for it to aggregate the amount, but not the periods. Is there a way to stop it from aggregating the period. My summary is set…
3.3.5.2 Inventory Ordering Module Formulas
I was trying this forumla for Beginning inventory Line item, it says below error. My DAT01 Beginning inventory also good for my concern. Is there anything missing from my side.
Avoiding Unnecessary Hierarchies in Anaplan: Escaping the “Top Level” Trap
In multiple Anaplan implementations across FP&A, S&OP, and operational planning use cases, a recurring design challenge is the overuse of hierarchical lists with Top Levels, especially on large transactional or operational lists. In many projects, hierarchies are introduced early with the intention of providing “future…
Previous list item in formula
Hello, Is there a way to assign a value depending on the previous list item? In my case, I need to assign the value 1 to the week 5, value 2 to the week 6 and so on until week 9. The values always go from 1 to 5, however the week number might change (for instance, choosing RFC24/01, value 1 is to be assigned to week1 ecc)…
API Call for Imports and Import Data Sources Metadata
In as much detail as possible, describe the problem or experience related to your idea. Please provide the context of what you were trying to do and include specific examples or workarounds: It would be helpful to be able to pull the information from the Imports and Import Data Sources tabs within actions via API. It would…
L1MB Exam Activity 4/5
Hi All! I seem to be stuck on activity number five, presumably due to something I missed during activity four. Here is everything I entered for SYS08 and EMP03 so far. I read some previous threads and made sure to update the new line items and make sure that "role" was set to "list." When I try to change the formulas in…
Sales rep monthly Commission not matching with Anaplan 'Check Your Build' numbers?
Hi All Community Members, Despite putting a lot of thought and efforts, I am not able to figure out where am I going wrong. I have set all the Modules and formulae in place but still the numbers for the sales rep monthly commission is not matching with the Check Your Build numbers. Please find below details of my modules I…
Cooking the P&L like a Blanquette: Robust Models in Anaplan
When you start modeling a P&L in Anaplan, there’s a universal temptation: “Let’s just add one more line item, it’ll be faster!” OH NO ! And yes, in the short term, it often is. But after a few iterations, you end up with a model that works… but looks like a stew that’s been cooking too long: too many layers, hard to…
How to represent in Anaplan an organizational structure
Hi, is it possible to use a Network Card in order to show an organizational structure which cannot be managed through Hierarchy Lists, cause there are branches that don't have the same hierarchy levels associated? Example: In a L1 COMPANY > L2 AREA > L3 SERVICE > L4 OFFICE There is a case like this: COMPANY A AREA A…
2.3.9.1 Import data into DAT03 Historic Volumes module - import error
Hello, I'm getting an import error "Invalid date or timescale identifier" when importing from the data hub DAT03 export saved view into the Supply Chain module DAT03 Historic volumes. This is also causing errors in the next step of running process 9. Screenshots attached below, any tips on fixes?

Upcoming Events

Quarterly Platform Release Webinar
Join us for our Quarterly Platform Release webinar where we highlight the latest enhancements and updates to the Anaplan platform. In this session, members of the Anaplan team will walk through key capabilities released this quarter, explain how they support better planning and modeling experiences, and share guidance on…
ACE: Anaplan Workflow
Registration and events details will release closer to the event date. Join us for the third session in our Workflow Expanded series as part of the Anaplan Community Experience program. This session continues our exploration of Workflow best practices and builds on the lessons from the earlier events in the series. We will…
ACE: Anaplan Workflow
Registration and events details will release closer to the event date. Join us for the fourth session in our Workflow Expanded series as part of the Anaplan Community Experience program. In this session, we continue building on the concepts and best practices discussed throughout the series, with a focus on helping model…

Model Builder

Discussion List