-
Making YTG column '0' for a particular line item.
Hello Anaplanners, I need formula to below. I have a module which I am using in management report. Module has values for FY24, YTD, and YTG. But for one line item, 'Opening Cash', we do not need YTG column. Currently the line item just points to the other module to pull the data. May be I need something that makes YTG…
-
Anaplan Integration API Error - API path not found
Hi , I am encountering the following error: { "status": { "code": 404, "message": "Not Found" }, "path": "/2/0/workspaces/<workspace ID>/models/<Model ID>/exports", "timestamp": "2025-05-26T16:09:29.716228003Z" } Using CURL: curl -X GET "https://api.anaplan.com/2/0/workspaces/<workspace id>/models/<model id>/exports" ^ -H…
-
Level 1 model building certification exam
Hi members, I am new to Anaplan, still learning. Learning Videos are quite helpful on Anaplan Academy. I am on level 1 model building. I see certification at the end, am I eligible to give it? I know it will ask me questions based on exercises which can only be answered if I have workspace access. But just curious, can I…
-
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…
-
Event recording available: Managing Hierarchies with Anaplan Data Orchestrator (ADO)
If you missed our spotlight event on Anaplan Community Experience: Managing Hierarchies with Anaplan Data Orchestrator (ADO), a recording is now available! Anaplan experts Stephen Day (Product Manager for ADO) and Jon Ferneau @JonFerneau (Data Integrations Expert, Operational Excellence Group) shared how organizations are…
-
How to approach a user story?
Author: Devrath Ahuja is a Certified Master Anaplanner with over six years of experience in implementing and delivering global Anaplan solutions. As someone starting out on their Anaplan journey, sometimes user stories and the build can feel overwhelming. Have you ever looked at a user story and wondered, “Where should I…
-
Revision tag naming: How a small change today can save time and hassle later
Author: Riley Rafko is a Certified Master Anaplanner and Principal at Slalom. The context Recently, a Center of Excellence (CoE) group that I was working with came upon a common, yet anxiety-inducing, issue: a production issue needed to be fixed urgently but many pending changes in the development model weren’t yet tested…
-
Rename Line item in Production model
I have created a mechanism by which Line Item name can be changed using a Process/Import. It works perfectly fine in Standard mode. But, in deployed mode it shows an error "Deployed mode is enabled and you cannot change the structural data of this model. Change to standard mode if a structural change is required." Could…
-
Change the model source for all pages in an application in one go
Hello every year I use to copy a PROD model of a given period (Bud 2026 for example) and keep it open but "Locked" for users, in order for them to still be able to access it if they want to remind what has been done during the previous process. All the pages in the app are sourced on this model (the PROD one not the copy),…
-
How to filter a module line item based on another modules page selector
i have two modules 1: dimensions B (subClass), C (version), D (D = Entity) 2: dimensions, A Policy No, (hierarchy where B is parent to A) , C module 2. includes a line item formatted to D - Entity module 2 on a UX will Sync to page selectors B and C from module A but i need to filter mod 2 also where line item Entity is…
-
Avoiding CSV import errors: Three practical tips for Excel uploads across regions
Author: Ayesha Zoha, Certified Master Anaplanner and Manager at Kearney. One of the most common issues I have found during end user training or UAT is the difficulty in uploading data from an Excel csv. This usually arises because users need to upload small but detailed datasets from existing systems. Even with multiple…
-
Setting formula summary method on a ragged hierarchy to display on org charts
Authors: Upali Wickramasinghe, Certified Master Anaplanner and Principal Solution Architect at Zooss Consulting in Australia; co-authored by Andrew Petersen, Senior Consultant at Deloitte Australia. We were presented with a use-case to utilize the Anaplan Hierarchy Charts to display an organizational structure with some…
-
9.2.5 Activity - Adding the 5%
Hi All, I have gone through the forum and the replies given to answer this question have not been helpful. Can someone please advise on how to do this as the FY24 cell is greyed out in my view it is not blue. Thank you
-
10.2.6 Activity: Add Formulas to Employee Expenses Module
Hi All, I am getting the result below: When the result should be: This is my EMP01 Module AND the blueprint below: Can you please assist in how to get the desired result ? Thank you
-
Anaplan XL Feature Enhancement Request: Custom calculation columns/rows
Current Behavior In the Excel Add-in, users can add Custom calculation columns/rows, but the column/row name can only be entered as a fixed value. User Feedback By using custom calculation columns/rows, we can add calculation results such as monthly averages to reports, so we use this feature in many reports. However,…
-
Forecaster Data Collection fails during initialization
Hi everyone, I'm currently testing Anaplan Forecaster, but I'm unable to initialize the Data Collection. It immediately fails with a generic "Failed" status and no detailed error message. My history module contains: A unique Forecast ID (Item ID) Native Time dimension (Month) A numeric Quantity line item with historical…
-
9.2.5 Activity: Add Formulas to Price Growth Rates Staging Module
This is the error message i get: Format of mapping used for lookup doesn't match any dimension of the source I am new to anaplan so i am learning whilst also trying fix errors. This the formula i enter 'REV04 Price Growth Rates'.Unit Cost %[LOOKUP: 'SYS04 Location Details'.Country, LOOKUP: 'SYS06 Product Details'.Product…
-
Simple but useful UX wins in 2026
Author: Manoj Upadhyay is a Certified Master Anaplanner and Anaplan Lead Consultant at Relanto. Hello Community! The true advantage for our end users is frictionless planning. When the UX is intuitive, users spend less time on figuring out the tool and more time driving business value. These enhancements are about creating…
-
Level 2 Polaris Sprint 3 Exam – Question 1 (Need Help)
Hi everyone, I'm stuck on the first question of the Level 2 Polaris – Sprint 3 Exam and would appreciate some guidance. Question: In the INV01 Inventory Ordering module, which of the following are used to guard the Final Shipment Amount line item? (Select all that apply.) I've already tried multiple combinations of the…
-
Need clarification on DCA and guarding line items in Polaris Sprint 3
Hi everyone, I'm currently working through Level 2 Model Building (Polaris) – Sprint 3 and I'm having trouble understanding how the Final Shipment Amount line item in the INV01 Inventory Ordering module is protected. I'm confused about the different mechanisms involved, such as: IF THEN ELSE logic Dynamic Cell Access…
-
FCR Feature Enhancement: Support Captions in the Open Period Configuration
Current Behavior In the Open Period Configuration screen, both member names and captions are displayed in the member selection dialog when selecting Scenario and Date members. However, once the selection is completed and the member selection dialog is closed, only the member names are displayed on the main configuration…
-
FCR - Folder Security Report
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: Ability to list of all the various roles' security on each folder in our explorer file system. A report with the information for…
-
Add commas and rounding control to page auto sums
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: Right now, when someone highlights a column with values on a page, the values don't show commas and don't round decimals. How often…
-
CloudWorks to expose ignored values
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: CloudWorks does not currently show if there have been "ignored" values in the process. This causes: Data has been dropped. Totals may…
-
Save incomplete changes when synchronizing in ALM
Imagine this scenario: You are in the middle of making changes in your development model and have been doing so for the last few weeks. The changes are not complete and are not ready to synchronize. However, you just received a request for an urgent fix from the user community that is critical for the forthcoming monthly…
-
I have created this formula to pull in stock exception count dimensioned by country and Prod Family
is this right ?
-
Level 2 Model Building Course Sprint 3 Exam
Hi all, I've been enjoying the model building training thus far, but I've run into a problem on the Level 2 Model Building Sprint 3 Exam. The question is asking for the formula for the Beginning Inventory line item. I've followed the instructions for creating the formula exactly and my Beginning Inventory values match the…
-
@Solution Architects
Can some one share your experience on transition as a Solution Architect from a model Builder. I'm working on projects and your inputs would help me get an over all idea and get things prepared to work towards SA ? Appreciate it. Thank you
-
Polaris Modeling and Optimization Challenge recap — event recording available!
We recently hosted a Community Q&A Challenge inviting members to test their skills in Polaris modeling and optimization. Our internal experts developed a series of challenges, featuring a module rebuild alongside optimization challenges focused on the optimization of high calculation effort and high calculation complexity.…
-
What are limitations on UX 'Drill down', up to what level of hierarchy drill down works?
Can we find somewhere documentation about UX drill down feature? UX is sometime showing underlying data upto 5 levels in hierarchy but doesn't work 6 or 7. Appreciate any pointers on limitations on this feature. Business wants to know up to what levels in reports they can analyze underlying data.