-
Displaying your data as a Calendar view
Problem Statement Ever wonder how to display your data in a calendar format in Anaplan or simply just want to have a color-coded display based on a specific alert/indicator in a calendar form? Step-by-step guide We just need 2 simple lists Day of Week and Week Number to start with. Then we need 2 modules Day of Week…
-
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…
-
Register for our April 30 platform release webinar!
Anaplan's next quarterly platform release webinar will be held April 30, 2025 at 8 a.m. Pacific Time. During this session, we will explore the latest features so you can optimize your Anaplan experience. Our expert-led session will equip you with a practical guide and live demonstrations to help you get the most out of new…
-
Streamlined Workflow Migration for Environment Transitions
I suggest enhancing the product feature to streamline the migration of workflows from the Dev Model to the UAT and Production environments. Currently, the process requires manually duplicating existing workflows and updating each task—such as the source workspace, source model, import actions, and ADO links—to reflect the…
-
Sumif based on month ?
A first module collects a quantity per month, client, and product. For each month/client/product, a warehouse (list element) is defined. Based on the warehouse, the start month is calculated (Time Period Format). My goal is to be able, in another module, to sum the quantities by products/warehouses/start month. When I try…
-
AnaplanXL conditional formatting
Is there a way to use conditional formatting on and AnaplanXL grid based on another lie item value. e.g. I have a separate line in the module that flags whether a period value is actuals or forecast (boolean or number), I want to use this to dictate the format of the cell and replicate the functionality in the Anaplan App.…
-
Straight Line Depreciation spread issue
Dear Model Builders, As per attached screenshot of my Straight Line Depreciation code, I am not able to get depreciation to calculate and spread for all subsequent months from Date in Use to Useful Life of the asset. All I am getting is a depreciation for a month of Date in Use but not for subsequent months. I have even…
-
Share your ALM best practices — March 2025 Community Challenge
Today, we’re kicking off our first Best Practices Challenge of 2025! This challenge series is an opportunity for Community members to share their expertise on a specific topic, exchange ideas, and learn from one another. This time, we’re focusing on Application Lifecycle Management (ALM). What is your overall approach to…
-
Reducing calculation effort
Currently looking to make use of the feature where can now see the calculation effort entailed in certain line items and I've already been able to eliminate or refine a number of elements in various modules but just wanted to check in terms of best approach to take to this next one. I have included a copy of the formula…
-
L2 Sprint 1 - Data from SYS007 Build Location to G3 Location Not Mapping
Hi, I'm on L2 Sprint 1 and I'm having an issue with mapping the data into G3 for SYS07 Build Location, It s not pulling in the distribution and shipping method, the build looks correct But when I come to map Result, No Distribution or shipping method. What am I missing Regards Andy
-
Based on version line items need to filter in DB
Module has line items and Versions toggled Q :If a module has 15 line items and a version dimension (A, B, and C), the user wants to filter based on the selected version in the DB: If Version A is selected, only line items 1 to 10 should be visible. If Version B is selected, only line items 10 to 15 should be visible. If…
-
Provide self-service download of Gurobi log files for Optimizer
As a frequent user of Optimizer, I want to be able to download Gurobi logs following an Optimizer run, so that I can analyse potential reasons for errors or changes in runtime. I’ll know this is successful when a button, or link, is available in the status window upon Optimizer completion, and I can use it to download the…
-
Give us the ability make Line Item names dynamic similar to display names for numbered lists
I would like to request the ability to use formula-driven display names for Line Items, similar to how display names work for numbered lists. This feature would allow the display names to automatically update based on the model’s current period settings. For example, if I have a line item named "FY25 Budget," it would…
-
Opening Capex Code not referencing Closing Capex correctly
Dear Model Builders, Please refer my attachd Opening Capex code which I believe not referring to the previous month's closing capex correctly. Appreciate your help on finding the cause of error and possible solutions. Thanks
-
Breaking into the Anaplan ecosystem
Author: Ayesha Zoha, Certified Master Anaplanner and Manager at Cervello. Throughout my career, I've had the chance to connect with individuals from diverse technology and business backgrounds, as well as countless college graduates eager to start their journey in the world of Anaplan. Over the years, I’ve noticed a…
-
could someone help me with the formula here 1.5.7.2 Add Formula to SYS13 Line Item
this is what is required
-
Summary Calculation for Hidden amounts (DCA)
Anaplanners, I have got a question: I have a module with the following setup:Dimensions: Scenarios, Category, Time (Month)Line Items: Operational Metrics (e.g., Maintenance Costs, Revenue Earned, etc.) Another Module: Controls whether specific months (e.g., April, May) should be marked as "Inactive". When months are marked…
-
Data integration and scalability: A framework for model assessment and optimization
Author: Avnish Goel is a Certified Master Anaplanner and Founder at ScriptStory. Recently, I led a model assessment initiative to identify suboptimal design elements in the data architecture for a leading investment banking firm. The project involved analyzing source systems and Anaplan models, leveraging both Anaplan best…
-
Dependant dropdown in Polaris
Have you encountered the problem during building that the Dependent dropdown does not work in Polaris the way it does in Classis? I somehow see the Dependent dropdown Check greyed out for the lists I want it on. Am I missing anything here?
-
Syncing Alternate Hierarchies on a Board
Hi, I am currently working for a model in which we have two different hierarchies, 1 is D1→D5 and other is P1→P5 where D1→D4 and P1→P4 are the same, and D5 and P5 are different. Now I am using two grids on a same Page, 1 having P1 hierarchy and the other having D1 hierarchy, because of this I am seeing to different Page…
-
Flexible time options - for instance on weekly time horizons
Many countries' business planners think in calendar week numbers, and there are a few different week numbering systems used globally. Customers request that Anaplan enhance the platform's native Time options flexibility to add more possibilities: To define weekly time horizons start/ end, Naming the periods, Options on…
-
Anaplan file export using Anaplan connect and process
Hi, I am trying to build regular export action / process and using in Anaplan connect to automate it . But when I create process / action with everyone access and run in Model it works . Bute when the same process I call through the Anaplan connect it gives me error "File not found in workspace or model". pls help me to…
-
Renaming the line item - Best Practices
Hello all, I need to rename a line item in a large model, I am wondering what are the best practices to do this? What should I consider before renaming to avoid destroying the model? Thank you in advance for your help!
-
Renaming a Line Item: Don't Break Import Actions
When a solution uses a line item as a source within an import action, whether model-to-model or external source-to-model, the renaming the line item will break the action. This issue impacts the model builders who need to do a rebuild of the action every time they make a change (if the model builder forgets to rebuild the…
-
How to convert month to text?
I am needing to convert month to text as we have a specific nomenclature we use for our company (i.e, if the current month/pay period is May but the pay accrual month is April I am needing to have a text display for May 25 as AprilPayMay25). I've done a lookup table in the past but was hoping for a formula that could do…
-
How to ask great questions in the Anaplan Community
Author: Seyma Tas is a Certified Master Anaplanner and product owner at Caliber Collision. A guide to help you get the answers you need The Anaplan Community is an incredible resource to share knowledge and get help. To get the best answers quickly, make sure you ask clear, well-crafted questions. Here are some tips on how…
-
how to take average in anaplan ?
difference between average and time sum function ?
-
4.6.7
I used the mapping column 3 family code to P2 product family column headers to parent column 1 product code to code I get the error another row has already been processed with this key and invalid name 53 failed
-
Multi-layer sort
Would be very useful to have a multi-layer sort (not filter) like in Excel i.e. Sort by column A alphabetically, then by column B, then by C. Acknowledging the workaround to concatenate the desired fields into a text line item and sort by that, but to me a publicised workaround is always a pointer to a needed/desired…
-
Include Dimension Index size information in module blue print for Polaris
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: Polaris has a limitation that a line item can not have more than a dimension index of 64. Models can start off with a dimension index…