-
Did you know about Anaplan FCR's Drillthrough feature?
Author: Werner Priels is Product Manager at Anaplan, focusing on Financial Consolidation. When managing multiple data interactions in Anaplan FCR, having a clear and transparent audit trail is not just a nice-to-have; it's a necessity. The out-of-the-box drillthrough feature is a powerful tool that provides deep insight…
-
Automate Optimizer process using API
In the last post, we showed how to retrieve logs using our API. Today, we will also show how to automate an Optimizer process using our API. That way, you can schedule the solving of an Optimizer action using code. You can also use Anaplan Connect to automate the request, and soon you will be able to use Workflow as well.…
-
Recording now available! January 29 platform release event
If you missed our January 29, 2026 platform release event, the recording is now available! In this webinar, we highlighted the most recent feature releases and how to take advantage of these in your environment. Our expert-led session demonstrated new features and innovations, provided a technical deep-dive and “how-to”,…
-
Automated license and size management
Author: Anish There has 2.5 years of experience in Anaplan and is an Analyst at Deloitte. Managing user licenses and keeping track of model sizes in Anaplan can be daunting for teams juggling multiple models across DEV, QA, and PROD environments. Traditionally, consolidating user information means manually exporting from…
-
2026 certificate maintenance for Certified Master Anaplanners
The 2026 Certified Master Anaplanner Program has begun, and there is incredible opportunity for 2026 Certified Master Anaplanners (CMAs) to demonstrate their thought leadership, technical expertise, Anaplan championship, and mentorship capabilities across the entire Anaplan ecosystem. At their core, a Certified Master…
-
Speeding up ADO data syncs with Workflow
Author: Mark Warren is the Architecture and Performance Director at Anaplan. Anaplan Data Orchestrator (ADO) is used to connect, transform, and manage data from various sources to be used in Anaplan models. It is a data management system that enhances integration, efficiency, and data governance within the Anaplan…
-
On-Demand Calculation in Polaris
Author: Dave Smith is a Senior Product Manager at Anaplan. We are thrilled to announce the rollout of On-Demand Calculation in Polaris, a feature that significantly enhances performance and efficiency for our users. On-Demand Calculation is designed to compute values only when they are needed, leading to a more optimized…
-
Did You Know? Anaplan Extensions
Author: Ahmed Brahim is a Certified Master Anaplanner and Senior Consultant at Atkan. Hello Anaplan Community! In this ‘Did You Know’ video, I’ll be going over the various Anaplan Extensions and covering: What Anaplan Extensions are The different add-ons available (Excel, Google Sheets, PowerPoint, etc.), Relevant use…
-
Anaplan API user reporting with Python
Author: Michael Moore is a Certified Master Anaplanner and Director, Enterprise Planning at HP. In this article I will cover: Why use Python for user administration? Prepare Begin OAuth2 login Finish OAuth2 login using redirect URL to fetch authentication token Import useful Python modules Fetch data about yourself Sort…
-
Manage Conditional Formatting Lost Progress
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: When in a View and adding conditional formatting, if you click the x in the top right-hand corner while you're editing a rule you…
-
Dividing (not formating) all the results by 1000
Hello, Is there a quick way, in Anaplan XL to divide all the results by 1000 without creating a measure for every row or every column?
-
ADO connection from postgreSQL
Hi everyone, I am trying to create a connection ADO from PostgreSQL, but I consistently receive the following error: Failed to establish a connection The following message was sent from the target system: The SSL certificate is either invalid or not in unencrypted PEM format. Please check your certificate and try again.…
-
Polaris: The science behind better business planning
Author: Parmod Kumar, Certified Solution Architect, and Financial Planning & Supply Chain Specialist at TCS. Reading time: approximately 8-10 minutes. Why the Polaris engine Is powerful and beautiful Polaris is Anaplan’s next‐generation calculation engine, built from the ground up to handle high dimensionality, sparse…
-
How I Built It: Rethinking scenario planning with Polaris
Author: Philipp Erkinger, Certified Master Anaplanner and Principal Solution Architect at Bedford Consulting. Dear Anaplan Community, The Anaplan Polaris Engine has brought a significant transformation in the way I construct and design Anaplan models. Over the past three years, I have had the privilege of working on…
-
REST API V2 after 16-Feb-2026 for CA Certificate authentication
Hi Does anyone successfully find the correct way to adapt the REST API scripts according to the new API v2 CA Certificate standards: adding the new parameter "encodedDataFormat": "v2". I tried to prefix the payload used to generate the encodedData and encodedSignedData by using the timestamp (also UTC), considering 8+92 or…
-
FCR: First showing "Explorer" when opening AnaplanXL Web
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 the earlier versions (XLCubed and FluenceXL), users always started directly in the folder tree, whereas now it takes quite a few…
-
ISFIRSTOCCURRENCE returns duplicates due to extra dimension
Hi ALL, As shown in the screenshot: Columns are Locations and D2 Roles. Each Location is mapped to a Final Region Set (e.g., Toronto).The module is dimensioned by Locations and D2 Roles. I want to export this mapping to another model, but in the target module, I don’t need the D2 Roles dimension. When I try to use…
-
How I Built It: Center of Excellence App
Author: Marina Ketelslegers is a Certified Master Anaplanner and FP&A voice for Anaplan and AI passionate about CoE support, solution architecture, and training. Hello Anaplan Community! I’m sharing a short walkthrough of my Anaplan Center of Excellence (CoE) App designed to help new CoE leads set up their CoE with clarity…
-
Filter dropdown for form action
Hi, I have a form action button that adds a L5 list item to a hierarchy. L5 does not have selective access but L4 does, but I still see all L4 list items in the dropdown when I trigger the form. How can I only view the ones I should have selective access to? L5 does not have selective access. L4 is also a selector on this…
-
Finding History for List Item Creation and changes
Dear Hive Mind, Do we have a way to get the history of a particular List Item, from its creation into a model up until its removal ? I am trying to chase when / how an item has been added into a model and how / when it would have been deleted and then recreated with the same code. Is there a pattern (manual or API) to get…
-
Update columns in a source
Hi, i have a source that uses a connection to Skutrak, and i selected 3 columns when i created the source, now i want to bring in a 4th column, do i have to recreate a source from scratch and then use that in a new transformation view and do all the work i did again, or can i update the source column selection, and add the…
-
Level 2 3.3.5
I am having trouble with the result of the formula I have input. Can anyone help me what's the problem why is it just showing 13,000 and 0? Below is the screenshot
-
Design Grid - "simple" Find Member does not exist anymore - only Advanced Search
Hello, I used to find Members in the Design Grid Dialog by typing in a text into the search field and pressing the "Find Member" button. The cursor jumped to the first result within the dimension tree. This does not work anymore. I always get the same dialog as the "Advanced Search" Button. I am using Version…
-
AXL Slicer Enhancement Request: Save Preferences with Multi-Select
Current behavior: When the Multi-Select Members option is enabled in the slicer settings, the user’s previous selections are not saved when reopening the workbook. As a result, users must reselect the slicer members each time they open the workbook. However, when the Multi-Select Members option is disabled, the previously…
-
Module 1 Missing Data
Good afternoon, I am working on Module 1 and I have downloaded the Example Model into my workspace. Upon completing the activity 1.4.2 where they ask to "Find the price of Fuddy Duddy in Tijuana" I am having a hard time navigating the model and actually finding the data. It seems empty.
-
More Detailed Filters on Anaplan Model History
Currently, History page only allows us to filter based on date range. I think the search functionalities should be expanded further. It should be categorized at least as metadata (structural) and data changes. This will enable us to review model structural changes apart from comparing revision tags. For example, after…
-
Ability to Apply Filters before downloading Model History
Currently, If I want to check history to view some activity on a specific module or list, but I am not aware of the dates when that change took place, It takes forever for me to extract the history for downloading 'ALL' change history and locate that change. I face issues especially when the changes are too many and file…
-
L3 Certification
Hi All, Please help me on path to enroll for Level 3 certification. I have completed L1 & L2 long back ago.
-
L2 Conclusion - REP05 Local Currency
Is there any issue with the formula for Local Currency? - Although it's fetching the correct result, want to check if there is anything else I'm missing. regards Sudhir
-
A four-lens metrics system for Anaplan CoEs
Author: Marina Ketelslegers is a Certified Master Anaplanner and FP&A voice for Anaplan and AI passionate about CoE support, solution architecture, and training. I’ve seen how Anaplan Centers of Excellence (CoEs) start with strong momentum. There’s enthusiasm, executive support, and a clear ambition to make connected…
-
FCR: Idle timeout
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: I would like users that have been logged in and idle for 15 minutes to be automatically logged out as part of their security…
-
How to identify if I have access to Polaris WS ?
How to identify if I have access to Polaris WS ?
-
Conditional Formatting on Booleans
As a model Builder I would like to use Booleans as a Basis for Conditional formatting. For example. I have a Boolean/ Checkbox which indicates that not all fields in a new Item/ setting has been filled. I would like to be able to use that boolean directly instead of reverting to a number. The advantage would be to save on…
-
Anaplan XL - "working..." on Formula Reports
In Anaplan XL, using formulas to pull data (Xl3lookup), how do I stop it calculating all the time? I'm often seeing this message of "working…" despite not having changed anything in my workbook to trigger that. Thanks, Tom
-
Heatmaps in Spoke Model
In the current Anaplan UX, there is no native heatmap visualization option within pages built on spoke models. Users must rely on conditional formatting in grids, which: Is limited in visual flexibility Is not intuitive for business users Does not scale well across multiple dimensions Requires manual setup in each module…
-
Sync connections without pressing sync???
I have a Data Orchestrator data source from Snowflake, and i connected to my data 3 days ago and have transformation view and a link and a workflow that successfully pushes the data to my list in my model. However when it ran overnight the data was identical to that of 3 days ago, and if i go to ADO i see the last data…
-
Restore revision Tag
In ALM, revision tags aims to represent a certain version of a Model, it would be convenient to be able to restore them.
-
Anaplan XL: About “Use Embedded Workbook Formatting (Preview)” option
We are currently experiencing an issue with the behavior when grid Auto Refresh is disabled. For our use case, it is important that the configured formatting is reflected before any manual refresh is performed. Therefore, we have enabled “Use Embedded Workbook Formatting (Preview)” as a workaround to have the formatting…
-
Prevent Dependent Dropdown Disruption
Problem Description: When a dependent line item used to filter a dropdown is deleted or has its format changed , Anaplan's underlying dependency link for the filtered dropdown can become stale. While the UI might show a newly created line item with the same list format as the dependency, the filter itself remains…