Model Builder

Native function for Date & TimeStamp
Hi, is there in Anaplan the possibility to retrieve current time (date and time)? I know that now this is possibile only via integrations, but I will need to know if there is a native function.
Level 2 Polaris Sprint 3 Exam Question 7 — all answer options marked incorrect
Hi everyone, I am taking the Level 2 Model Building (Polaris) – Sprint 3 Exam and need help with Question 7. Question: “Using the Distribution Center Summary UX page, in March 2025, which Distribution Centers have Stock Exceptions (All Products)?” The answer options are: San Francisco, Dusseldorf, Melbourne, Marseille, and…
Talent Builder Graduate Mini Resume - Andrés Avilés
Name: Andrés Avilés Location: Mexico City, Mexico Certification: Anaplan Professional Model Builder Certification | Anaplan Talent Builder Program | Jun 2026 – Jun 2028 Educational Background: Bachelor’s Degree in Finance, Universidad de Sonora. Business Intelligence Diploma, ITAM. Academic exchange experience at The…
REP02 Size Margin Report Module in Lesson 8 Activity 8.8.3
Hello everyone, I am going through the L1 model builder course, and I am stuck at the activity 8.8.3 "Add Size Margin Report Module". I think I am doing the right things, but in certain combinations, I don't see values in my module. I am attaching all of the screenshots in this docx file. In fact, after creating this…
Talent Builder Graduate Mini Resume - Sarthak Kajle
Name: Sarthak Kajle Location: Navi Mumbai, Maharashtra, India Certification: Anaplan Certified Model Builder (Level 1 & Level 2) Educational Background: MMS (Finance) BAF (Accounting & Finance) Profile Summary: Business Analyst with 4 years of experience in financial reporting and analytics using SQL, Tableau, and Excel.…
Talent Builder Graduate Mini Resume - Anoop Chhabra
Name: Anoop Chhabra Location: Bangalore, KN, India Certification: Anaplan Certified Professional Model Builder Educational Background: Anaplan Academy, IIT-D (B.Tech), IIM-B(MBA) Profile Summary: I have a vast experience across various domains & technologies for clients from different industries - Aero, Agro Chemicals,…
Display Item Deletion Count in UX
When deleting items from a list via the UX, there is no indication of how many items are being removed. The model backend provides this count during deletion, but the same visibility is absent in the UX experience. It would be helpful to surface this count to users when performing deletions through the front end.
Talent Builder Graduate Mini Resume - Monica Drake
Name: Mónica Drake Location: Los Angeles, CA Certification: Certified Anaplan Model Builder (Level 1 &2) Educational Background: Anaplan Academy, George Washington University (Digital Marketing), Universidad San Marcos (Public Accounting) Profile Summary: As a Certified Anaplan Model Builder and Business Operator, I…
"Saved Views" on Actions & other Model Objects like Time, Versions, Users, Source Models, etc
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: in Actions - the only way to get the information is to manually export or to have an export action. It would be great if I could make…
Lesson 13.6.4 doesnt show the year information in the UX but it shows in the module. Why?
Lesson 13.6.4 doesn’t show the year information in the UX, but it does show it in the module. Why?
Talent Builder Graduate Mini Resume - Sandeep Reddy
Hello Everyone, I’m excited to be transitioning into the Anaplan and EPM ecosystem after 11+ years in business consulting and strategic research across automotive and industrial sectors. I have completed the Anaplan Certified Professional Model Builder certification with hands-on exposure to Connected Planning, FP&A…
🚀 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…
YTD Should Exclude Current Month and Include Actuals Only
Currently, Anaplan’s native YTD (Year-to-Date) calculation includes the Current Period, even when that period contains forecast values. Issue From a financial planning and FP&A perspective, YTD is expected to represent Actuals only. However, Anaplan calculates YTD including the Current Month, which can contain forecast…
Blueprint View - "Is Summary" and "Parent" - Impact of Clearing These Values
Hello and thanks in advance for any assistance! I am hoping to better understand what the "Is Summary" and "Parent" in the Blueprint View impact in the model? My end goal is that I would like to set all of the "Is Summary" to FALSE and clear out the "Parent" in the Blueprint view. I do not fully understand what the impact…
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)?
Aligned by Design - A proportional cascade framework for multi-level forecast reconciliation
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: In enterprise planning and forecasting, we aim to produce statistically sound forecasts at multiple organisational levels (e.g.…
Talent Builder Graduate Mini Resume - Caleb Bourgeois
Name: Caleb Bourgeois Location: Greenville, South Carolina, United States Certification: Anaplan Professional Model Builder Anaplan Level 1 Model Building Anaplan Level 2 Model Building Anaplan Talent Builder Graduate Educational Background: 15+ years of professional experience in client-facing design, communications,…
Talent Builder Graduate Mini Resume - Dhanesh N. Kalkar
Name: Dhanesh N. Kalkar Location: Mumbai Certification: Anaplan Model Builder Google Project Management Anaplan Way Educational Background: DME, BE (Mechanical Engineering) Profile Summary: I’m a Technical Consultant with over 11 years of experience, increasingly focused on leveraging automation and connected planning to…
Talent Builder Graduate Mini Resume - Keyley Mable
Name: Keyley Mable Location: New Orleans, LA, United States Certification: Anaplan Certified Model Builder Educational Background: Bachelor of Science in Kinesiology with a minor in Chemistry Profile Summary: Results-driven consultant with a passion for leveraging technology to solve complex business challenges. Currently…
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"…

Upcoming Events

Building Valuable Anaplan Workflows
Join us as Anaplan experts explore how organizations are using Anaplan Workflow to streamline business processes, improve collaboration, and drive greater efficiency across their connected planning ecosystem. Designed for model builders, solution architects, COE leaders, workspace administrators, and business process…
Driving Security, Compliance, and Governance with the Anaplan Audit Log
Join Anaplan experts for a practical deep dive into the Anaplan Audit Log and learn how organizations are using it to maintain robust security and compliance measures. Designed for workspace administrators, security and compliance teams, IT leads, and other hands-on Anaplan users looking to better understand how to track…
Anaplan's Quarterly Customer Platform Release Webinar
Anaplan's next quarterly platform release webinar will be held July 29 at 8:00 a.m. Pacific Time. During this session, we will explore the latest features so you can optimize your Anaplan experience! Our expert-led session will equip you with live demonstrations to help you get the most out of new features and…
Building Smarter Models with Polaris and Planual
Join us as Anaplan experts share practical strategies for building smarter, more scalable models using Polaris and Planual best practices. Designed for model builders, solution architects, COE leaders, workspace administrators, and anyone responsible for developing and maintaining Anaplan solutions, this session 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