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 (…
Hi in the classic interface, when a module is dimensioned on a list, it's easy to add several entries at the same time with the action of creating items as showed below (which eases also the fact to c…
One of the foundational elements of any Anaplan model is hierarchical lists. When creating hierarchies there are two basic choices: balanced or unbalanced. In this article, we'll look at the differenc…
Hi All, Just another simple one this time. I need to capture the code of the L0 Hospital subsidiary. I tried code(item('L0 Hospital Subsidairy')) formula in a text formatted line item i keep getting a…
My PRACTICE module has time dimension as Months 2019. I want to create an IF statement in the RESULT line item that says IF Time Period < Jul 19 THEN TEST 1 ELSE TEST 2 How do I reference the Time Per…
Hello all, Does the auto-axis functionality not work for waterfall when you have negative numbers? Case 1 - Positive numbers Case 2 - Negative Numbers The numbers are exactly the same & its the same c…
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…
Introduction In part two of the new ALM Explained series, we discussed the best practices for testing and validating changes prior to deploying them to production models. However, we also know that te…
Hello, Is there a way we can retrieve the module IDs & line item IDs? It'd be really helpful in understanding the MAPS report instead of having to copy paste & check the id for each line item. Thanks!
In Part 3 of our CloudWorks - This is how we use it series, we will introduce you to the CloudWorks API. This is typically for an audience comfortable with REST APIs concepts and programming. If you n…
Hi All, Facing an issue while uploading the screenshot as it is showing "error while uploading the file". Is it only for me or is anyone else facing the same. Can anyone help in resolving this at earl…
Comparison By Year Comparison By Year Several times I have been asked for a chart with the possibility to compare seasonality or month over years. It´s proven to be both popular and useful in its own …
*Content reviewed for accuracy June 2020 Making sure that production data lists are correctly marked within a model is a key step to setting up and using Application Lifecycle Management (ALM). This g…
Hello, Good Day! Need some professional help on how I can replicate the weeknum function from Excel to Anaplan. I am relatively new to this platform. I have a module where I should be able to get the …
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: As an end…
As a workflow builder, I want to have the possibility to add a machine task after a reject, so that I can run a process or write data. For example: A Decision task can end on Reject. Afterwards, it sh…
The ‘Copy Branch’ action hasn’t currently made its way onto the UX, so I was recently challenged to create a workaround. This is my relatively simple solution, which could be amended for “Assign” by d…
Hi all, Is it possible to return a value from an item on the same line item? For example, picture this as my module: I want to be able to calculate a delta between S1 and S2 or S3 and S1, like this: H…
* What is Anaplan Connect? * What is covered in this article? * What is NOT covered in this article? * What pre-requisites do I need? * Deep Dive on Integration * Integrating with SAP HANA Cloud * Int…
Hi Team, I have a requirement where, I have 2 Apps i.e., App A & App B. I have an access to App A but not App B. Conversely, the other user has an access to App B but not App A. My ask is, if I click …
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…
Using the following: https://us1a.app.anaplan.com/2/0/workspaces/Workspace ID/models/Model ID/files to retrieve file ids. One can substitute "modules", "processes" for files to get those ids. Is there…
Preface: Utilizing CA Certificates is the best practice for Anaplan Data Integrations. The wake-up script is best leveraged with CA Certificate authentication in the individual scripts for security pu…
Summary As a supply chain Anaplan modeler, you might be asked by finance to convert your 445-monthly forecasts into a normal, Gregorian calendar since their general ledger accounts are usually set up …
Hello, everyone. In the near future, I will be introducing a supply chain model (from demand forecasting to supply and inventory planning) to a Japanese Manufacturing company as a Model Builder. As pa…
Hi all! I tried to follow the steps of this article about dynamic line item names change but I can't get it to work, so I would like some help on why it's not working. For context: I am building a Pri…
