Modeling

Dependency on both Parent and Parent of Parent
Hey guys, Can someone offer some ideas on how I can setup my manager drop down to be both dependent on Sales Team and Sales Sub-Team on the scenario below. This filter module is dimensioned by Users. Scenario 1: When Sales Team and Sub Team are blank, Manager is blank Scenario 2: When Sales Team is selected and Sales…
Anaplan optimizer - cumulate function
Hi guys, We are currently working on an optimizer, and one of our constraints is a cumulative function (monthly quantity accumulation to consider). However, the optimizer doesn't handle the use of functions in its constraints well. Has anyone encountered this issue before? I can provide more details if needed. FYI it works…
The Truth About Sparsity: Part 1
Throughout my five-plus years at Anaplan the conventional wisdom has been that we should eliminate sparsity in order to model efficiently. Throughout the last year, as part of the PLANS standards initiative, we have been critically re-evaluating all of the existing best practices and techniques and sparsity was included as…
Convert list to text
Is there a function to change a list value to a text? I want to use the & operator with list values, but it only accepts text. When I try just using the list-formatted line items, I get the error below, so it seems that if I could convert the list selection into text then I'd be fine: The 'text1' argument for the '&'…
Planning,Budgeting & Forecasting for insurance
Hi Team, Please can anyone clear my doubt regarding group level in insurance app and what is the work done by the group level finance manager.What covers under the group? Is it region or something else? The below is the link for the app.…
Add Version Formula
Can anyone share a use case or an example where the 'Add Version Formula' would be needed? I'm a bit confused about how to implement it, so any example would be helpful.
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…
How I Built It: YTD values using a fake calendar
Author: Jared Dolich is a Certified Master Anaplanner with 8 years architecting Anaplan models. Anaplan Champions! A colleague asked me recently how I might obtain a YTD value using a fake calendar. Yeah, I know — I should have asked why they couldn’t use the normal time hierarchy, but there are occasions where you are…
Calculate once and reference | Model Optimization Team series
Hey! 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…
How to roll back a production model to recover lost data
Author: Jessie Zhao is a Solution Architect and Certified Master Anaplanner at Anaplan. Working with a model in ALM has a lot of benefits. These include building new features in a development model anytime without affecting production users, securely managing production lists by identifying structural data that needs to…
Kindly help me to understand how I can achieve this?
I have two modules. In the first module, when I select "America," its child fields should become editable. If I change the value of any child field from zero to a non-zero value, all other child fields under "America" should become non-editable, except for the one I modified. If I revert that value back to zero, all child…
Evolve your Anaplan ecosystem with enterprise governance
In this article, you'll find resources to support evolving your Anaplan ecosystem with enterprise governance. This broad topic was covered in depth during Anaplan Live! 2022 — including focused discussion on Centers of Excellence; model governance; workspace architecture; data hubs and data integration; build and…
[Start Here] User Access Management - Part 1: Get Started
A foundational design element of any Anaplan model is User Management. This includes creating the design within the Anaplan model and app, as well as establishing the process for managing and maintaining access once users are active. The table below contains questions that are typically asked as part of the Foundations…
Is there a shortcut to go to the module referenced in a formula?
Some of my time is spent working through models to see how everything is connected and im just wondering if there were any shortcuts to access modules referenced in formula more quickly? Currently i'm looking at the formula and then manually locating the module from my modules list to then open it. If no shortcut exists I…
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…
April 2025 platform releases and what’s next
Check out the latest Anaplan feature updates and enhancements in our April 2025 official release notes. The information below offers supplemental information to that post. UX New UX for Models section in Administration The Models section in Administration has been redesigned with a more intuitive interface. Tenant…
How to DYNAMICALLY Copy Data from One LIST ITEM to Another?
Hi Anaplan Community, I’m working on a use case where we have to work with templates (List: L_Template#), data pertaining to the template stored in a module (IM01 Input Data). We have given the end-user privilege to create N number of templates, now the ask is if we could Copy data in IM01 Input data of Template 1 to…
When to import alphanumeric data as numbers
Author: Andrew Barnett is a Certified Master Anaplanner and Vice President at PJT Partners. Today, we will be discussing a scenario that we often run into in Anaplan. Numeric data comes in with units of measure, whether explicitly stated or implied in the data. The data might be a currency, like US Dollars or Mexican…
Alternative for the default export chunking
Author: Anya Skvortsova is a Certified Master Anaplanner and CoE Lead at Asana. Problem statement When exporting the data from Anaplan module, Anaplan’s default chunk size is 10MB. The common challenge is that the chunks produced may have the rows split not just into the separate files but also split the row in the middle…
Load FY-Level Data into specific month via Data Import Between Modules
Hi Community, I have a scenario where I need to push data from one module to another within Anaplan. Here's the setup: The source module contains data at the FY level (i.e., yearly summary), example FY25 The target module has the same dimensionality but is at a monthly granularity. I need to load the FY25 value into…
Pages with 2 models as a source has issues with Actions. A major problem
We have a new page with 2 model sources, and an action button from each source. When we select the first model 'CyT - DATA HUB', we see the 'UPDATE SUPPLY CHAIN' action greyed out as expected, as it is from another Model, and cannot be pressed. The action info is correct (highlighted) for the DATA HUB 'IMPORT ORDER'…
Enhancement Request for the ability to assign list items to a subset using a formula
I would like the ability to populate a subset based on a line item attribute in another import module that contains the full list.
Unlocking the power of Polaris: A guide to efficient model building
This article is part of a series on Polaris best practices. Click here for more Community content or visit Anapedia for detailed technical guidance. Polaris is Anaplan's next-generation calculation engine, designed for highly dimensioned calculation at scale. It represents a paradigm shift in the ability to model business…
Saved views
We have a number of saved views across various modules in our model, does the number of saved views impact model performance at all?
Formatting time: Period instead of month
Would be great if a customer could choose how to format the months not just Jan 21 but P01 21 or P1 21 or P1 FY21. Now the period notation is only possible when selecting "13 4-week periods", but not if a customer selects any of the other option, like a month model or a week model with 4-4-5.
Alternate Hierarchies - Use Cases
Hi All The topic of Alternate Hierarchies is very interesting for me, as we are exploring this topic as a future development for the product We are looking to build functionality that will allow multiple parents off a single child member and specify which hierarchies should be used in which part of the model This will…
Architectural Use Cases for setting Action Imports / Import Data Sources to Production Data
There's only 1 practical architectural use case I can think of at the moment why you would consider setting actions as production data but would like to check in with others if there are other use cases I have not considered. The one use case I have considered is if you are splitting the same model in to regional models,…
The ability to add a dynamic sub total to a grid
I would like the ability to add a dynamic subtotal to a grid, so when rows are filtered out the total is updated on the fly
How to Pull Data from Non-native Versioned Source Modules into a versioned module?
I have a Report module that uses native versions (Actual & Budget). I need to pull data from two separate source modules: One module contains Actuals data (not versioned). Another module contains Budget data (also not versioned). Since the source modules do not have versions, how can I pull their data into my versioned…
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…

Upcoming Events

Community Challenge Recap: Annual rollover best practices
In this ACE Spotlight event, we will cover the most effective techniques for making your annual rollovers seamless and repeatable, based on the solutions from our latest Community Q&A Challenge.
ACE: Anaplan Workflow expanded
Join us for an upcoming Anaplan Community Experiences session focused on continuing your learning with Anaplan Workflow. In this event, we will explore best practices for designing and implementing workflow processes that support structured planning, approvals, and collaboration across teams. The session will provide…
Quarterly Platform Release Webinar
Registration will open soon for this event. 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…
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…

Modeling

Discussion List