-
Moving Sum for Formula driven number format line items
I am trying to create a Net Debt / EBITDA formula at the bottom of one of our P&L income statements where, i have tried the MOVINGSUM function. However this does not work for summary line items which EBITDA is. What i would like is to be able to sum the previous 12 months EBITDA (Including the current period) numbers in a…
-
Concatenated List for to store Archiving data
Hi Anaplanners, I’m working with a calculation module (Module A) that is dimensioned by a concatenated list, Time, and Native Versions. In this module, I am performing a subtraction using values from another module (Module B), which is dimensioned by Native Versions and a different concatenated list. The two concatenated…
-
How I Built It: Fast, efficient model build of scenario planning with P&L impact analysis
Author: Marina Ketelslegers is a Certified Master Anaplanner and FP&A expert and independent Anaplan Solution Architect. In this 'How I Built It' tutorial, you'll learn how to create a dynamic and flexible impact analysis and allocation framework tailored to your needs. Whether you're evaluating P&L scenarios with business…
-
Time Period Formatted line items dependency on Time Range
Currently dropdown for time period formatted line items shows all time periods for Model Calendar. There should be an option to make them dependent on Time range applicable to that particular Module/Line Item. For Example: If Model has 5 years, a Month formatted line item will show all 60 months in dropdown even if that…
-
Top 25 Anaplan features released in 2025
Author: Misbah Ansari is a Certified Master Anaplanner, Anaplan Community Moderator, Leader India User Group, and Founder at Miz Logix. Anaplan has consistently released several features monthly to stay ahead of the competition and enjoy being a leader in the Connected Planning world. 2025 was no different and there were…
-
Level 1: Lesson 8: REV02 Volume Inputs Error while importing
Can someone please confirm if my mapping looks correct for REV02 Volume Inputs and what should the value be in the Time Tab and Line Items Tab
-
Feature Enhancement Request: Record Duplication
Current Behavior When a record is duplicated, the system automatically assigns the name: “[Duplicate] (Original record’s name)”. User Feedback The duplication feature is widely used by many users. Overall, users find the duplication function very helpful for efficiently creating similar records. In addition, automatically…
-
Field Selection (Not give the option to select Top level)
I have a list call lease ID that has a top level called All Lease ID. I do not want the top level to be seen in my selection. What can i do ?
-
Copy a Process
I am frequently encountering cases where i need to copy and existing Process then edit it slightly. Current example is a DEV model is being rolled out to many regions. I need to have a suite of Processes per Region as they are slightly different in the way they update from Data Hub. Right now i have to create a record of…
-
Iterative Development in Polaris
This article is part of a series on Polaris best practices. Click here for more Community content or visit Anapedia for detailed technical guidance. As Anaplan solution architects and model builders begin to develop in Polaris, it's important to consider how you approach the development workflow. In Polaris the upper limit…
-
Anaplan XL Clone
Is there a clone feature? I am looking to duplicate a connection and its data into a new Excel worksheet. The Anaplan Excel Addin allowed this, but I am not seeing it in the new Anaplan XL Clone. Is this feature available in the Anaplan XL? Please help.
-
RetrieveTIMESUM using ANY
Hi everyone, I was trying to Retrieve a Line Item (Boolean) using TIMESUM as formula to another module by using ANY. This Boolean LI has A,B,C as dimensions. My target module has only A as dimension. In order to use a reference module for mapping, does this reference module had to have A,B and C as dimension or just A…
-
Harnessing the power of Combined Grids: A unified experience for developers and end users
Author: Saikrishna Bandaru is a Certified Master Anaplanner and Sr. Anaplan consultant. Introduction: Why Combined Grids matter With the October 2025 Anaplan release, one of the most impactful enhancements in the UX is the Combined Grids capability. Combined Grids allow page builders to bring together data from up to five…
-
Ask each time import version
i have three version YEP 1, YEP 2 and Budget. Only YEP 1 and YEP 2 have the option to select mapping. Budget is fixed mapping. How do i restrict the selection to only show YEP 1 and YEP 2
-
Formula for Subsets
Add in a formula functionality to conditionally add items to a list subset, rather than having to manually check a boolean.
-
List of subprocessors
Anaplan provides documentation that lists the affiliates and subservice organizations that are material to the provisioning or support of our hosted service. For the latest information regarding third-party subprocessor vendors, see the current list of subprocessors. To subscribe to this page and receive notifications when…
-
Talent Builder Job Opportunities - ANP Consulting
Position Title: Consultant/Senior Consultant/Manager Company Name: ANP Consulting Location (City, Country): PAN INDIA/Hybrid/Remote Role Overview: About Us ANP Consulting is looking for motivated experienced Anaplan professionals having strong analytical skills, a technical and problem-solving mind with proven track record…
-
Show Parent when no child + selection
Good morning, My lists are as follow. Parent: Mission --> Programm --> Activity --> Expense (lowest level) My objective is to put in place a filter that allows me to see the Activity items even though I have no existing Depense under the acitvity, combined with a filter where the user can select to narrow the view on one…
-
Cloudworks Integration Flows in UX
At the moment, we are able to add Cloudworks Processes to the dashboards and the addition is great. Could we do the same with the Integration Flows? I see multiple benefits from this for several customers and I do not think that the implementation would be too different from what is currently in there. Is this currently in…
-
Anaplan XL: Grid - Edit Axis exclude members should except levels or somemember.children
Hello, it is not possible to select a "level" (only single members) in AnaplanXL/Axis/Edit/Exclude. This is important when you have 2 or more dimensions on an axis and want to exclude a combination of one member of one dimension with a level of antoher dimension. Therefore, I would have to use manual MDX as a workaround,…
-
Microsoft Teams - Anaplan Integration
A number of customers have expressed a desire to have an Anaplan - Microsoft Teams integration in the same way as now exists between Anaplan and Slack. * Push links to pages to users' Teams accounts * Anaplan notifications * Subset of above: as Anaplan Process Orchestration progresses the need / benefit from Teams link…
-
UX Pages - Guidance on Cataloging
Hi, I'm working across 5 models with the follwing profile of UX pages - model A. 69, model B. 132, M C. 31, M D. 49, and M E. 33. Total of 314 New UX Pages. This strikes me as quite a number of pages to keep track of, and I think building a 'catalogue' with some relevant data would improve the User Experience, and the…
-
How can i export accuracy metrics from Anaplan Forecaster to Model.
There was an error rendering this rich post.
-
From alternative to essential: The expansion of private markets
Author: Daniel Dunleavy, Certified Master Anaplanner and Manager at Alpha FMC. Private markets — once the domain of large institutions and specialized investors — are now playing a central role in how businesses grow and how capital flows through the economy. As the global economy moves into 2026, private investment in…
-
Excel Plugin asks me to log in
Hi, I am trying to create a new Anaplan Connection using the excel plugin. It asks me for an environment and I chose the default one (https://us1a.app.anaplan.com). It then asks me to connect with my Anaplan account but it just says : ———— The Anaplan server returned an error: Authentication Failure. If you're unsuccessful…
-
Talent Builder Job Opportunities - ANP Consulting
Position Title: 𝗔𝗻𝗮𝗽𝗹𝗮𝗻 𝗠𝗼𝗱𝗲𝗹 𝗕𝘂𝗶𝗹𝗱𝗲𝗿 Company Name: ANP Consulting Role Overview: 𝗔𝗡𝗣 𝗖𝗼𝗻𝘀𝘂𝗹𝘁𝗶𝗻𝗴 is currently hiring Anaplan Model Builders for one of the consulting clients. We are seeking 𝗖𝗔-𝗾𝘂𝗮𝗹𝗶𝗳𝗶𝗲𝗱 𝗽𝗿𝗼𝗳𝗲𝘀𝘀𝗶𝗼𝗻𝗮𝗹𝘀, including freshers, who possess a strong foundation in finance and are looking to build a career in the…
-
Enable Sort Functionality with Nested dimensions
Current Limitation: Anaplan restricts sorting functionality on line items or dimensions in columns when rows have nested dimensions. Sorting is only allowed when there is a single dimension in the row axis. Impact: Limits the usability of reports that require multiple dimensions in row axes. Reduces the value of recently…
-
Level 3, model building
Hello, I created INPUT1 module to add stretch goal % per country by all products. However, even I select specific products the percentage works fine (I can adjust the percentage) but upon selecting to all products it grays out and won't let to change the percentage. please advise. Thanks, Farhad G.
-
I want to apply conditional formatting to summary
If all periods exceed 100% i want it to flag red like below. How do i apply the condition at summary level?
-
How do we convert these column time into time dimension in anaplan
basically this is a transactional list wherein attributes are from A to E column. Need to create a hierarchy from A to E then convert these column to time .