-
How I Built It: Beginners guide to integrating with Anaplan using Python
Author: Matt Budd, Certified Master Anaplanner and CIO at Nightingale College and Solution Architect at Dialed Solutions. Hello Anaplan Community! In the last year, I've done a lot of work around creating automation and integrations with Anaplan using Python. Several solutions I've built using Python include: Creating a…
-
June 2025 Community Member Spotlight: Andrew Tye
Celebrating @andrewtye as our June 2025 Community Member Spotlight! With a decade of experience in the Anaplan ecosystem, Andrew is a Certified Master Anaplanner and Community Boss who has made meaningful contributions to the Community over the years. He’s shared nearly 800 comments and is a familiar presence in forums,…
-
Did You Know: Code for Line Item Subsets
Author: Jonathan Cushing is a Certified Master Anaplanner and Senior Consultant at Vuealta Consulting. The video gives the details of a little-known function in Anaplan whereby you can add codes to line item subsets (LiSS). The video shows: Where to input the LiSS code How it can be used to map a line item subset to a list…
-
Curiosity, Collaboration, and Connected Planning: Inside a 3-Day workshop
Author: Mikhil Agarwal, Certified Master Anaplanner and Delivery Manager at VISEO USA Inc. “They say a strong foundation doesn’t just support growth; it sparks curiosity.” That could not have been more fitting during our Anaplan onboarding workshop in Singapore last year. What began as a technical Level 1 Model Building…
-
How I Built It: Combining two custom time schedules
Author: Moriah Reyes is a Certified Master Anaplanner and Manager at Lionpoint Group. Hello Anaplan Community! I’m excited to share my ‘How I Built It’ tutorial with you all. This video shows how you can cleverly use an index list and text list to combine two custom time schedules. Building a custom time schedule can be…
-
May 2025 Community Member Spotlight: Marina Ketelslegers
Meet @Marina Ketelslegers — our May 2025 Community Member Spotlight! As a Certified Master Anaplanner with five years in the Anaplan Community, Marina has shared valuable insights and ideas that have helped other members along the way. Check out her spotlight to learn more about her path, her favorite Anaplan tips and…
-
April 2025 Community Member Spotlight: Alexandru Pavel
We’re celebrating @alexpavel in our latest Community Member Spotlight! For the past eight years, Alexandru has been a steady, helpful presence in the Community — with over 500 comments, and a role as a Certified Master Anaplanner and a Community Boss. He consistently shows up with thoughtful insights and a genuine desire…
-
Level 3 Model Schema Diagram
Hi All, I'm currently going through my L3 and was asked to upload a model schema design diagram. For this assignment, should I create a schema diagram only for the three Regional Sales Executive user stories discussed in this course or for the entire model. The instructions seem a bit unclear. I also want to answer this…
-
How to set up cloudworks process job biweekly ?
Hi team, I am using cloud works to schedule a job to run, but I need you help to set up the process integration biweekly. How to schedule a job biweekly?
-
Date into Time Period Month
I have a situation where i have a line item formatted as a date(lets name it dateLine), and another line item formatted as time period month(monthLine). Currently monthLine=Period(dateLine) which gives me result like :- jan 21, feb 21, etc. However because of Period function limitation of model calendar, for values going…
-
How I Built It: Dynamic cell hardcoding
Author: Casey Pham is a Certified Master Anaplanner and Director of FP&A Systems at Yext. Hello Anaplan Community! In this ‘How I Built It’ demo, I'm going to show how we dynamically hardcode data in cells in order to preserve values that were previously derived from calculations. An issue I've seen in past implementations…
-
Streamlining travel data: A comprehensive approach to trip parsing and expense linking
Author: Steven Kraplin is a Certified Master Anaplanner and Senior Financial Analyst at The MathWorks. In a recent project, I was faced with the task of designing a model that could efficiently consolidate travel data from various systems. The goal was to organize the data into trips and link all related expenses incurred…
-
How I Built It: Upload Anaplan data — account hierarchy and key accounts
Author: Saikrishna Bandaru is a Certified Master Anaplanner and Sr. Anaplan consultant. In this video, I demonstrate how to create a user-friendly Anaplan UX page that allows end users to upload or update specific data directly into Anaplan. The example covers account mapping, enabling users to mark accounts as "strategic"…
-
How I Built It: Replacing list items
Author: Chris Allen is a Certified Master Anaplanner and Manager at Allitix Part of Accenture. Hello, and thank you for checking out my ‘How I Built It’ video tutorial on replacing list items! The video will walk you through the process of replacing list items. The key feature leveraged here is importing a new code into a…
-
Creating a two-layer ranking system in Anaplan
Author: Laiza Tagumpay is a Certified Master Anaplanner, former Customer Success Business Partner at Anaplan in the Philippines, and is now a Solution Architect at an implementation partner in Canada. When developing effective plans, companies often rely on multiple layers of prioritization criteria. In this blog, we’ll…
-
How I built it : Centralizing complex calculations
Author: Fabien Junod is a Certified Master Anaplanner and Senior Solution Architect at Autodesk. Hello Anaplan Community, Let me ask you a question: do you have the same complex calculation in multiple models (maybe with different dimensions) and wish you could centralize them? In this “How I built it” tutorial, I shared…
-
Need help finding a possible error in SYS01 Time Settings by Week and INV01 Inventory Ordering
Hi all - I have been trying for days to figure out where there is an error on my own, and I have not found the solution. I believe the error is somewhere in the SYS01 module as my formula for Beginning Inventory (which I've confirmed is correct, as far as the Anaplan Community is concerned) just resets every week that…
-
How I Built It: Fast, efficient model build of scenario planning with P&L impact analysis
Author: Marina Ketelslegers is a Certified Master Anaplanner and FP&A expert and independent Anaplan Solution Architect. In this 'How I Built It' tutorial, you'll learn how to create a dynamic and flexible impact analysis and allocation framework tailored to your needs. Whether you're evaluating P&L scenarios with business…
-
2025 Anaplan Platform Recertifications (June Update)
DON’T MISS OUR INFO SESSIONS Register now for the July 9th ACE session on updates to the Anaplan Certification Program. Partners should plan to attend the partner boost session in June for more information. ANAPLAN ACADEMY SYSTEM DOWN TIME – JULY 6TH & 7TH Anaplan Academy will be unavailable on July 6th and 7th due to…
-
My journey on Workflow implementation — Part 1: the buildout
Author: Kevin Beltz has been a Certified Master Anaplanner since 2018 and is writing this blog on behalf of Wildflower Aspect. Hello Anaplan Community! Today I’m happy to share Part 1 of my Workflow journey. I segmented the blog into three sections: the state of Anaplan at my client, live build thoughts, and a summary…
-
A conversation with Lis de Geus — Journey | Anaplan Community Podcast
Today we're excited to share episode 16 of Journey, an Anaplan Community podcast. Our host, Dennis Lemoine (@DennisL), Director of Customer Engagement & Experience, chats with Lis de Geus (@lis.degeus) — Certified Master Anaplanner and Principal Solution Architect at Bedford Consulting. Lis has been in the FP&A space on…
-
Level Mismatch Error
Hello All, I am getting level mismatch error while set up the summary method as ratio, i am not able to set up the applied to and ratio as describe in the below ss simultaneously. what is the possible reason for the error and any ideas and suggestion would be appreciated, thank you for your help.
-
How I Built It: Creating functional P&Ls using line item subsets without COLLECT formula
Author: Austin van der Linden is a Certified Master Anaplanner and Senior Model Builder at Hubspot. Hello Anaplan Community! In this 'How I Built It' Tutorial, I show how you can build functional P&Ls using line item subsets as a mapping tool. One of the cool functionalities provided with line item subsets is that you can…
-
How I Built It: Limitless interdependent multi-select filters
Author: Daniel Badura is a Certified Master Anaplanner and Lead Architect at Dr. Oetker. Hello Anaplan Community! In this ‘How I Built It’ tutorial, I show how you can build filters that filter filters, without using any dependent dropdowns. Each filter allows multiple selections, and they are all mapped using a single…
-
Updates to the Certified Master Anaplanner Exam study guide
Announcing the updated Certified Master Anaplanner Exam study guide: Essential Anaplan Topics Achieving Certified Master Anaplanner status is a significant milestone in your Anaplan journey, demonstrating a mastery of the platform and a deep commitment to excellence in Connected Planning. To help you prepare for this…
-
AI and ADO brings planning innovation with Joe van Bolderen — Journey | Anaplan Community Podcast
We’re kicking off 2025 with a bang and an outstanding Community member for our first podcast of the year. Join me in welcoming Joe van Bolderen (@Joe_VBCG) to Journey, an Anaplan Community podcast along with host Dennis Lemoine, Director of Customer Engagement & Experience. Joe has been a Certified Master Anaplanner since…