Anaplan platform discussions

Need practical solutions quickly? You've come to the right place.

Integrations and extensibility
Discuss APIs, Data Integrations, Extensions and more.
Intelligence
Topics like PlanIQ and Predictive Insights.
Modeling
Discover how to build efficient models that deliver the best results.
Security and tenant administration
Learn how to keep your data and users secure.
User Experience
UX features and end user collaboration.
Community feedback
Tell us how we're doing.

🚀 Newest questions

Anaplan for Microsoft 365
Using the excel addin for Microsoft 365 when I try to add a card to import data I get the message 'Cannot insert data from a custom view'. I am not using a custom view. Any ideas what I am missing here?
Total Figures for shop based on list item mapped to other lists
Hello I have a calc module (CALC1) structured around a dummy list 1-20, plus a series of dimensions such as Region (1-3) and Shop Type (A-C), plus a timeline. This dummy list lays out a series of revenue adjustments over time based on the dimension categories, such as [+5% revenue for region 1, shop type c across periods…
Data Split between Many to Many Relationship Mappings
Hello Anaplan Community, I am encountering an issue with one of my development work and would be greatly appreciated your assistance. There are 2 different modules involved in my model: 1) INP01 Percentage Input by Product (Applies To: P3 List) 2) REP01 Percentage Split by Department (Applies To: Departments List) The…
Hiring: FP&A Professional with Anaplan Level 2 or Master Anaplanner Certification – US-Remote
Hi Anaplan Community! We’re currently sourcing for a Manager Anaplan Financial Systems that blends deep financial planning & analysis (FP&A) experience with technical Anaplan model building. Ideal candidates will have: 10+ years of FP&A or finance analytics experience Proven success in strategic planning, budgeting, and…
ADO - Another Key Has Already Been Processed With This Key
Hi All, So I am getting an interesting set of errors when pushing to a hierarchy in a model from ADO: This is a 10 level hierarchy, and there are no errors for level 10. I have tried pushing data to a hierarchy with the first 9 levels only with no issues at all, so it seems to be an issue with the 10th level. I have…
Performace responsiveness In Polaris Engine
Hi Community, I have been exploring the Polaris Engine & trying to better understand its performance compared to the Classic Engine. Assuming I have a module with the same structure, same input data, and identical calculations in both engines: >Which engine is expected to perform better in terms of calculation speed and…
Resetting Numbered List in Polaris Engine
Hi Community, I’ve been exploring the Polaris Engine and had a question related to how Polaris handles Numbered Lists, specifically in comparison to the Classic Engine. In the Classic Engine, we have the ability to reset a Numbered List , which clears the list and allows new items to start again from index 1. >Does Polaris…
Polaris Engine Suppress Zero Functionality
Hi Community, I'm exploring the Polaris Engine and came across the new "Suppress Zero" feature, which is not available in the Classic Engine. I understand that this feature helps to hide rows or columns where all values are zero, but I have a question specifically about how it behaves when the suppressed dimension is…
How to get input mapped to parent to pull through against child
Hello as context, I am creating an input module with no timeline that is effectively a dummy list 1-30, then a series of line items mapped to various lists such as Region (A-C), Shop Type (1-3), etc. Finally I have three line items - start date, end date & effect value. I can therefore say 'Adjustment 1 = +5% sales for…
Alternative of Rankcumulate
Is there an alternative to using RANKCUMULATE in Anaplan for cumulative ranking by group? The model's performance is impacted due to the use of rankcumulate. I'm looking for a more efficient approach or best practice to achieve cumulative ranking within groups without degrading performance.

❓ Unanswered questions

Anaplan for Microsoft 365
Using the excel addin for Microsoft 365 when I try to add a card to import data I get the message 'Cannot insert data from a custom view'. I am not using a custom view. Any ideas what I am missing here?
Data Split between Many to Many Relationship Mappings
Hello Anaplan Community, I am encountering an issue with one of my development work and would be greatly appreciated your assistance. There are 2 different modules involved in my model: 1) INP01 Percentage Input by Product (Applies To: P3 List) 2) REP01 Percentage Split by Department (Applies To: Departments List) The…
3.3.7.2 Add DCA to INV01 Inventory Ordering -> Shipping cost question
Hi all, i'm checking the value for the shipping cost but i found something strange The formula looks correct to me, and I also reviewed the module behind the lookup function, which seems fine. For example, for WEEK 2 2020 / NUTZO BAR EN, the final shipment amount is 8,192, but the shipping cost for ROAD should actually be…
Level 3 - Designating Sales Reps to Accounts
What is the frequency of designating sales reps to accounts? Is it during Yearly/Quarterly Accounts Review?
Azure blob connection Cloudworks vs ADO
I am trying to connect to Azure blob, the credentials work on cloudworks, but do not work on ADO. Has anyone else experienced this issue?
Looking for Anaplan End-Users to take a short survey!
We are looking for Anaplan end-users to provide feedback on their experiences with the Excel add-in. Interested individuals will respond to this 5-minute survey to help us understand personal needs and behavior when using the add-in. The feedback provided by survey takers is essential to the roadmap of Anaplan's products.…
CERTIFICATION BADGES - ANNOUNCEMENT
Anaplan Champions! The Community team just posted this announcement that certification badges may not be showing up on your profile probably until next year. Rest assured, you will get credit once you complete and pass the exams. https://community.anaplan.com/t5/Blog/Badges-Back-Soon/ba-p/123385
PlanIQ Error Messages and Warnings
Users may encounter error and warning messages in PlanIQ. The table below includes descriptions of the messages and details what should be done in order to address them, where applicable. Message types: * Errors will fail the relevant PlanIQ step. Users will have to follow the instructions in order to avoid the errors. *…
Current page filters and sorts are applied to all pages of multi-page exports
This item has been identified as an outstanding known issue. Issue Setting a current page filter or sort and then exporting this data to file, will apply the current page filter/sort to all pages of the data. Workaround Remove all filters/sorts, export the data, and apply the filters/sorts in Excel --- Internal Reference:…
New UX : Source model selector unsable from page to page
Hi Sorry for the repost if somebody already realized this issue. A client implemented to new ALM feature for the standard UX. She realized that the selector can randomely switch form one source to the other while switching the page. Of course it's very dangerous. She is performing some UAT on the DEV and suddently she…

✅ Answered questions

Excel date format for February 2030, 2031 and so forth don't align with Anaplan format
Hello, I’m running into a recurring issue when importing CSV files into Anaplan, specifically with dates in February for the years 2028, 2029, and beyond. Here’s what’s happening: In Excel, the date format is set to Custom (e.g., 2/26/2025). When imported into Anaplan, the date is interpreted as 26-Feb, where: Month = Feb…
ADO - Another Key Has Already Been Processed With This Key
Hi All, So I am getting an interesting set of errors when pushing to a hierarchy in a model from ADO: This is a 10 level hierarchy, and there are no errors for level 10. I have tried pushing data to a hierarchy with the first 9 levels only with no issues at all, so it seems to be an issue with the 10th level. I have…
Hiring: FP&A Professional with Anaplan Level 2 or Master Anaplanner Certification – US-Remote
Hi Anaplan Community! We’re currently sourcing for a Manager Anaplan Financial Systems that blends deep financial planning & analysis (FP&A) experience with technical Anaplan model building. Ideal candidates will have: 10+ years of FP&A or finance analytics experience Proven success in strategic planning, budgeting, and…
Need Help: Import Updates Only Specific Combinations Without Erasing Others
Hi Anaplan Community, I'm facing an issue while importing data FROM A MODULE (text details) INTO A MODULE that has two dimensions: "Unique Line ID" and "Organization x Site". The source file is based on a numbered list. It includes text-formatted columns (line items) that contain the names of the "Unique Line ID" and…
Anaplan XL Reporting
Hi all, Is there any way I can replicate this in Anaplan XL Reporting? I have 2 modules, the first one contains the numerical data on projects and region dimensions. The second one has the project property, which is the area each project is applied to. In the module view, I can nest the region, project, and filter to only…
Polaris Engine Suppress Zero Functionality
Hi Community, I'm exploring the Polaris Engine and came across the new "Suppress Zero" feature, which is not available in the Classic Engine. I understand that this feature helps to hide rows or columns where all values are zero, but I have a question specifically about how it behaves when the suppressed dimension is…
Performace responsiveness In Polaris Engine
Hi Community, I have been exploring the Polaris Engine & trying to better understand its performance compared to the Classic Engine. Assuming I have a module with the same structure, same input data, and identical calculations in both engines: >Which engine is expected to perform better in terms of calculation speed and…
Resetting Numbered List in Polaris Engine
Hi Community, I’ve been exploring the Polaris Engine and had a question related to how Polaris handles Numbered Lists, specifically in comparison to the Classic Engine. In the Classic Engine, we have the ability to reset a Numbered List , which clears the list and allows new items to start again from index 1. >Does Polaris…
Don't miss Anaplan Live! Spotlight on April 28!
Join the next Anaplan Live! Spotlight on April 28 at 11:00 a.m. (SGT) to hear from Metro North Hospital and Health Service, an Anaplan customer, about why it's critical to start with the business process when designing a new application. See a demo of their app and model and hear how their very intentional approach in…
Prevent end users deleting a list item when using Worksheet in UX.
Hi, I have a worksheet for end users to enter new hires into, for which the list item which persist across versions. I am having an issue where the end user can delete a list item using the grid functionality because the Current Version value is blank, but I want to prevent them deleting them (as data will be lost from…

Welcome!

It looks like you're new here. Sign in or register to get started.