-
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…
-
How to be frugal when building inventory rollover
Author: Vinay Varadaraj Mirajkar is a Certified Master Anaplanner and Senior Solution Architect at Anaplan. Imagine you are modeling inventory projection in the classic engine with below assumptions: Large number of products and locations Planning horizon with daily buckets (let’s say 60 days) This is very common in use…
-
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…
-
In 2.3.10 of Spring2use an intermediate module to align the source with the target
In Sprint 2, Create Demand Forecast, "Remember that Anaplan can automatically aggregate data upwards (from lower to higher levels) in the hierarchy, but in this case you will It is necessary to use an intermediate module to align the source with the target", for the second half, how to achieve it?
-
In the L2 we were discussing about intermediary module to connect the Source and Target
How to connect the growth % which has the Product family as dimension with the P3 SKU using intermediary module..I'm stuck Can someone help?
-
Stop duplicating modules: Meet Combined Grids
Author: Vijay Pasumarthy is a Certified Master Anaplanner and Sr. Principal Consultant at Genpact. If you had two modules with a common dimension and wanted to show information from both on the same page, your options were limited: Build a new “combo” module and recreate all the line items or Drop two grid cards side by…
-
issue with DEM04 export
Hi Community, @Misbah @MikhailErgyun I’m currently working through Level 2 and have a question regarding module cell count and Time Ranges. In my DEM04 module, the initial cell count using the Model Calendar was 547,596. When I switched the module to use a Time Range (FY19–FY21), the cell count reduced to 395,486. However,…
-
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?
-
Converting Fake Time to Native Time in Anaplan Polaris
In the world of Anaplan, "Fake Time" lists are often a necessity when native time doesn't offer the flexibility your specific business case requires. However, the real magic happens when you can map those custom list items back to Native Time Periods. If you are working in a Polaris-enabled model, efficiency is the name of…
-
DCA is active for an ID, but data is invisible
For a line item, where DCA read and write both accesses have been provided to an ID, but that person can't see any value. The ID has full access to the model, only difference is, the ID is not WSA. Can this make any difference? To clarify more, that particular line item has four dimensions, i.e., Users, List1, SS:List2,…
-
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…
-
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…