-
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…
-
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…
-
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…
-
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
-
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…
-
Formula Calculatin Time
I have a MAPS formula calculation time of 8,929,021ms - which I think is around 149minutes ( dived by 1000 to give seconds, divided agian by 60 to give minutes. Is this correct? If it is correct - how does Anaplan deal with such a long calculation time? Thanks in advance for your help.
-
How I Built It: Chess in Anaplan
Author: Waleed Hakim is a Sr. Anaplan consultant. Hi everyone! I’m Waleed — a Senior Consultant working with enterprise clients to transform their planning processes through Anaplan. I've been in the Anaplan ecosystem for just under four years now, and while most of my time is spent solving complex business problems, I’ve…
-
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…
-
Add YTD and YTG to Polaris engine
Hello, It would be a significant advantage to have YTD and YTG calendar items in Polaris. Regardless of the calculation density, these are essential for our reporting requirements—whether supported natively or through a workaround. Thanks in advance.
-
Comments within formula
There should be a syntax to add comments within the formula. All programming languages provide this feature, for example: /* comment */ is used in Java, plsql. This will help to temporary remove any part of the formula for testing or add meaningful comments for reference.
-
Certified Model Builder - Certificate
Hi, I completed Level 1, Level 2, and The Anaplan Way. How can I get the certificate "Certified Model Builder"? I found this article, but the link in the article does not seem to work - Certified Model Builder Certificate Thanks!
-
Time hierarchy filter new ux when brought forward option is turned on?
Hello, Does anyone know any workaround or a solution to be able to enable the hierarchy filter in new ux when the brought forward option is selected in backend? I do not see the above hierarchy filter option if I enable the brought forward for a line item-
-
Migrating a model from Classic to Polaris
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 of reasons motivating the move such as workspace optimization, accommodating natural model growth over time, and…
-
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…
-
Avoiding Unnecessary Hierarchies in Anaplan: Escaping the “Top Level” Trap
In multiple Anaplan implementations across FP&A, S&OP, and operational planning use cases, a recurring design challenge is the overuse of hierarchical lists with Top Levels, especially on large transactional or operational lists. In many projects, hierarchies are introduced early with the intention of providing “future…
-
Selective Access on Flat List Subsets
Currently, selective access write permissions must be granted to a parent item for end users to modify an item's subset membership. In the case of a flat list, the items do not have a parent, which means users cannot modify the inclusion of these items in the subset. This has created challenges within my organization, as…
-
Previous list item in formula
Hello, Is there a way to assign a value depending on the previous list item? In my case, I need to assign the value 1 to the week 5, value 2 to the week 6 and so on until week 9. The values always go from 1 to 5, however the week number might change (for instance, choosing RFC24/01, value 1 is to be assigned to week1 ecc)…
-
Additional Week Formatting Options
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: The "w/e" prefix is quite bothersome, especially when it appears on our graph axis labels. My business and executive users often…
-
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…
-
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…
-
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…
-
Formula for Subsets
Add in a formula functionality to conditionally add items to a list subset, rather than having to manually check a boolean.
-
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…
-
Anaplan DocuSign Integration
Hi Team, Could anyone please share their experience in integrating Anaplan With DocuSign? Our use case is below - Users should be able to create Purchase orders in anaplan, Route for approval and track the approval statuses. Our Approver Business users are not Anaplan users. So, we need to create a PDF file using the PO…
-
Sales rep monthly Commission not matching with Anaplan 'Check Your Build' numbers?
Hi All Community Members, Despite putting a lot of thought and efforts, I am not able to figure out where am I going wrong. I have set all the Modules and formulae in place but still the numbers for the sales rep monthly commission is not matching with the Check Your Build numbers. Please find below details of my modules I…
-
[Polaris] Allow for the use of Suppress 0's functionality on saved views for Model to Model exports
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: While understanding there are potential updates in the works, an alternative solution for Model to Model import challenges within…