
Modeling
Modeling
Discussion List
- 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…
- 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…
- 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 …
- 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 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…
- 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…
- 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…
- 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…
- 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…
- 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…
- I want to create a functionality where the end user will select a start and end month from a pick list and based upon the difference in months Anaplan will calculate the average revenue. Revenue data …
- 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…
- Just to give context we do not use the native versions in Anaplan, rather we use a list name forecast versions and then have a subset of these that we have of these that are marked as those we wish to…
- Hello, Apologies for the long post, I tried to be descriptive enough! I've a module in production which has close to ~3 billion cells, (this module alone occupies 25GB of space). I'm trying to optimis…
- Hello, I'm looking at giving certain users access to update switchover for Native versions, and copy over activities, reducing reliance on the Tech team. It looks like it's these types of actions are …
- Most companies have brand-specific colors they use for fonts, icons, logos etc. When implementing building pages in Anaplan I attempt to use their colors where possible (and reasonable). UX page build…
- Author: Hanwen Chen is a Certified Master Anaplanner and Professional Services Sr. Manager at Anaplan. Use case This is an interesting use case. One of our customers wanted to be able to include/exclu…
- 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…
- I'm attempting to show the 'remaining' months eg everything after the current period in the time settings - is this possible ? or would I need to create a fake period list?
- 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…
- Every time we create a wrong formula the system runs a roll back that takes about 8 minutes!! We would like to avoid this roll back... it takes so much time during the development phase! They could ju…