Modeling
Discussion List
-
Polaris - How is the memory used calculated?
Hi, I have a scenario where I was comparing 2 approaches & noticed something strange. Even when the populated cell count is the same the memory used by 2 line items is different (almost double?) There is a difference in the calculation complexity but I haven't seen any article mention that in the sizing for Polaris. Does…
-
Create a Boolean-formatted line item to select the first week of the timescale (Year)
Hi everybody! Can someone help me with this simple excercise from level 2 please. I need to create a boolean line item that flags the first week of the time range (Year). Thanks in advance!
-
Dynamic Ranking: Rank a Line Item Based on Selectors
Summary Level: Advanced In any line of business, you might be asked to create a dashboard that ranks the sales of your customers based on whatever values are displayed in a two-dimensional grid but based on multiple dimensions chosen from selectors by the user, including top levels. In this example, we will use four…
-
Level 3 - Ask the Stakeholders - Establishing Sales Targets
Level 3 - Ask the Stakeholders Establishing Sales Targets Process Questions This forum is for asking the stakeholders of the Unicorn Candy Company questions about the Establishing Sales Targets Process. The Anaplan Academy team will be monitoring this forum during US Central standard business hours. Please allow up to 3…
-
How I Built It: Building a dynamic calendar in Anaplan
Author: Jason Zhang is a Certified Master Anaplanner and a Manager at PwC. Have you ever wanted to visualize upcoming events and milestones directly in Anaplan? While Anaplan provides powerful planning and modeling capabilities, it does not offer a native calendar view for displaying events in a traditional calendar…
-
Anaplan AI Gateway - Copilot
I'm trying to set up Anaplan AI Gateway. I was able to set up a source to anapan AI Gateway and sign in. Workspace provisioned in Agent Studio. Any insight on the "couldn't load tool permissions" error?
-
Feature Request: Model Copy API Endpoint
1. The Problem Currently, there is no API endpoint available to programmatically copy an Anaplan model. This is a critical gap for workspace administrators who need to back up models before making changes. The only available method is a manual, UI-driven process — requiring an administrator to navigate to the Model…
-
What's needed to make a subsidiary-view line item editable/enterable for users?
My module page has Time and Position (P1 Position) set as Pages, Team Member (07 Team Member) set as Rows, and Line Items set as Columns. I have two input line items whose 'Applies To' is set to 07 Team Member only. What do I need to do on the UX page to make these two input lines show up as editable cells for users?
-
Need Some Checklist or Steps to be performed when rollingout a new anaplan model for specific new re
Hi, our users have successfully tested the required functionalities in the UAT environment, and we are now planning to roll out a new Production environment for them. Could you please guide us on the necessary steps and prerequisites for setting up the new Production environment? Thanks in Advance
-
Academy: Model Building Level2, sprint 3, Lesson 3.5.5 question
I have a question for Model Building Level2, sprint 3, Lesson 3.5.5 and the product SKU by Distribution Center panel on the Distribution Center Summary UX page (in My Pages). I got it working, but I want to know if there is a better solution as my screen layouts are slightly different to the prototype. I used a grid and…
-
Anaplan AI Gateway vs. CoModeler: same AI wave, very different jobs
The one-line difference CoModeler helps you build the model. AI Gateway helps you ask questions of the model. What CoModeler does CoModeler is an AI assistant inside Anaplan for model builders. You describe what you want in plain language, for example “add a headcount module by department with a monthly roll-up.” It…
-
Increase the Breakback Cell Limit in Polaris (or Make It Smarter)
The idea Please raise the 1 million cell limit for breakback in Polaris, or rework how that limit is applied so it better fits what Polaris is designed for. The problem Polaris lets us build models with many more dimensions than Classic, and sparsity is no longer the constraint it used to be. That is a real strength, but…
-
Workspace hygiene recommendations: A readiness guide for Anaplan AI Gateway
Anaplan AI Gateway (“Gateway”) is a supported, governed MCP (Model Context Protocol) interface that connects external LLMs, assistants, and agents, such as Claude, Gemini, and Microsoft Copilot, to your Anaplan models. It lets your teams’ LLM clients query your Anaplan models directly. This means users can ask questions…
-
What to know when moving models across workspaces: A practical checklist
You may be considering moving a model into a new Workspace for several reasons. On the surface, a cross-workspace move looks like a simple copy, but the result is a new model with a new model ID. It loses its ALM revision history, and you need to review anything that pointed to the original: integrations, ADO, app pages,…
-
Anaplan Live!—Your Opinion Matters
We're getting ready for our next Anaplan Live! event. As active Community members and model builders, your input is extremely valuable. Our mission is to bring you content to boost your model-building skills, no matter what level you're at today. Take this brief survey, and let us know what you want to learn more about.
-
How to use the SUM function
Summary: When building Anaplan models, the SUM function is used to add up values that meet one or more specific criteria. Find out how to construct a formula using the SUM function in this short lesson. Course Objectives: By the end of this lesson, you’ll be able to: * Identify source and mapping cross reference data to…
-
Management Reporting: Table cards should dynamically adjust the number of columns based on filters a
Problem In Management Reporting, the number of columns in a Table card is fixed when the card is created. When a dynamic filter returns a different number of items (e.g. fiscal years depending on the selected Version), the card does not adapt: If the card was created with few columns, additional items (e.g. FY29) never…
-
When will this "Coming Soon!" functionality be coming?
Greetings, Product Management People! This support article from nearly a year ago alluded to Dynamic Bulk Copy coming soon! https://product.anaplan.com/supercharge-your-model-building-efficiency-with-anaplans-upcoming-modeling-features-53955fd1-9330-4aaa-b145-484ad733afc3 The screenshot shows the option to select the…
-
Level 2 Sprint 3 - Safety Stock Flag Count
Season's greetings all. I don't know why I am wrestling with this formula as it seems straight forward but it does not appear to be working correctly. My line item formula is as follows; 'INV01 Inventory Ordering'.Safety Stock Exception Count[SUM: 'SYS08 SKU Details'.Country Made In] Is there a logic context error here…
-
Ratio Summary method against two dimensions
Has anyone tried using Ratio Summary against two dimensions in Classic? I have managed to get it working on Polaris before but for some reason doesn't want to do it in Classic
-
Change a summary calc
I am creating a balance sheeting planning in Anaplan with a list below. For "Net Assets" line, how do I make it "Assets" - "Liabilities" instead of sum of assets and liabilities
-
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…
-
Enforce Dependent Dropdown Validation for Pasted Numbered List IDs
Idea Description As a model builder, I want dependent dropdown rules to be enforced consistently across all data-entry methods, so that users cannot enter values that would otherwise be unavailable through the configured dropdown selections. Example of Enhancement I'll know this is successful when values that do not meet…
-
Applying Formulas to Specific Rows in a Flat List While Keeping Line Items as Columns
This question may have been asked and answered before, but I’d appreciate your thoughts on the following scenario. If a Flat List is used as the rows in a module, is it possible to apply formulas to specific rows within that list? In the example below, Revenue and COGS are pulled from a DAT module by using a SYS module…
-
Can import actions be restricted from updating read-only items in a custom version list?
Hi everyone, I have a custom list that represents versions. Users need to be able to see all versions in UX pages and reports, but one specific version (Version 1) should be read-only. The problem is that when users run an import action, the action opens a dialog where they can select the version from a dropdown. Even…
-
How do you decide when an Anaplan module has become too complex?
As an Anaplan model grows, modules can gradually accumulate more line items, formulas, and business logic. At some point, splitting a module into smaller ones might make it easier to maintain, but it can also introduce additional dependencies. I'm curious how other modelers decide when it's time to split a module rather…
-
Using Anaplan as a monitoring layer for Workday processes
Author: Josh Baker is the Head of Finance Operations and Transformation at PJT Partners, Master Anaplanner and Workday Financials – Pro. Currently leads accounts payable, accounts receivable, expense, and finance transformation. Reporting is not actionable or intuitive Most finance operations teams have the same problem,…
-
Anaplan P&L Design: Should I Use a Flat List for P&L Rows and Line Items for Reporting Columns?
Hi everyone, couple questions here: I’m building an Actual vs. Budget P&L reporting model in Anaplan and would appreciate advice on the best structural approach. I’ve attached a screenshot of the desired layout. The report needs P&L items as rows, and the following as columns (line items): Actual Budget Variance $ Actual %…
-
Ran into two issues this morning with selective access, and no items available for selecting
Hello, One of my models is generating this issue: "PLANNED Position # has selective access enabled and you may not have been granted access to any items." When I try to adjust the selective access, it then says "no items to select". I'm unsure what caused this issue and how to correct it. Any help sincerely appreciated.…
-
Alternative to LOOKUP for Parent-to-Child Mapping [As Lookups in Polaris are worst performing]
Hi Community, I have a module dimensioned by L3 (Category) and need to display the values in a module dimensioned by L4 (Items), where L4 rolls up to L3. Example: Category 1 = 10 Category 2 = 20 Category 1 ├─ Item 1 └─ Item 2 Category 2 ├─ Item 3 └─ Item 4 Expected result: Item 1 = 10 Item 2 = 10 Item 3 = 20 Item 4 = 20…
Upcoming Events
-
Unlocking the Value of Community with Anaplan Community Bosses
Join us for an exclusive professional development roundtable designed to celebrate, connect, and elevate our premier platform advocates: the Anaplan Community Bosses. The Community Boss program stands at the very heart of our ecosystem, highlighting leaders who dedicate their time to guiding peer model builders and…
-
Designing for Fit, Utility, and Practical Guardrails with AnaplanXL
Join Anaplan experts for a practical introduction to AnaplanXL (AXL), the Excel add-in that connects Excel grids directly to governed Anaplan data. As the first session in our technical series, this event is designed to help: Model Builders understand the fundamental purpose of AXL: what AXL does, the basic guardrails for…