Author: Mike Henderson is a Principal Solution Architect at Anaplan. There is growing interest in taking existing models that operate in the classic (Hyperblock) engine to Polaris. There are a variety…
Hi Team, I would like to get the next year summary value into previous year’s month. If we need current year summary, then we can use YEARVALUE function to achieve but we need to bring data from next …
Appreciate that it is recommended to avoid using properties in lists, however we do have a couple of instances of this in our model. Just looking to pull one of these into a module that we have alread…
Hello Everyone, Want to create module which captures data days wise, but the challenge is the data should be Displayed in two ways. So, If current forecast day is 6th Aug, so 1st Column named "Till Da…
Author: Jessie Zhao is a Solution Architect and Certified Master Anaplanner at Anaplan. Working with a model in ALM has a lot of benefits. These include building new features in a development model an…
I have been stuck on this activity for the past 2 days and do not know what I am doing wrong: This is the formula I tried for Bonus: For bonus: IF Employed? THEN Salary * 'EMP03 Employee Drivers by Ro…
Hello! Welcome to the Model Optimization team's monthly blog post. This is an eight-part series, following the topics we see occurring most frequently in slow customer models. Our aim is to inform and…
Almost any model builder has had to come up with a solution to get the current date in Anaplan. We used to build integrations and use API for that. @JaredDolich posted a great article about using pyth…
When model builders modify a saved view, this breaks existing export actions that use that saved view. The reference to the view is not dynamic. For example, if a model builder adds a new line item to…
Hello, Does anyone know why the waterfall intermediate total is showing up in blue? I'm using a ragged hierarchy. With intermediate totals turned on & colour set to black I want to see the forecast ba…
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 fle…
I’m working on a page that includes two tables: Module 1 (called CRM Table): Dimensioned by L4 Employees, includes line items like Term Date, Role, and Department. Module 2 (New Hire Table): Dimension…
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 Li…
Thinking through the results of a modeling decision is a key part of ensuring good model performance; in other words, making sure the calculation engine isn’t overtaxed. This article highlights some i…
In the world of Anaplan modeling, performance is key. Slow model calculations can be a major bottleneck, impacting productivity and decision-making. But what if you could pinpoint exactly what’s causi…
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 m…
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 po…
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.…
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 lea…
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 …
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 …
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 adva…
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…
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 fi…
Hello, I have a module DEM03.1 Mapping (CV&ADI) with Time dimension and LIST03 SKU with the same List but without time. I'd like to get first non blank value from Date of introduction Line Item in DEM…
Hi hive mind, I have a tricky question. Here we go : I have a target module with 3 custom dimension (A,B,C) + Time (Month) I have a source transaction module containing line Items with A, B, C list fo…
Scenario My rows include 3 items - REC1, REC2, and REC3 my columns include quarters - Q1FY25, Q2FY25, Q3FY25 and Q3FY25 Line item - 'Select' which is formatted as Boolean. Desired Output - If I check …
It would be super helpful to have the timestamp as part of the export file name in Anaplan, especially when clients run reports every day during the budget season. Is it possible to do? And do automat…
Hello everyone. My case is simple : For a specific client need, I have a list with date property. Each time a date is input in the module, a process is run to "save" the input in the lists properties.…
