Modeling

Please do not Deprecate Classic Dashboards
Hi There, I am on a project where we have downloaded a model out of the model showcase, specifically the weekly stat engine. This assets provides a starting point for integrating statistical algorithms for demand planning. With the deprecation of the classic dashboard a crucial functionality of these models is lost. We are…
Is it possible to have a chart with a dropdown selection to show either weeks, months, quarters?
For example, if I have sales numbers w.r.t to time, however I want a single chart on front end that has a dropdown selection to switch between lets say 6 weeks, 6 months, 6 quarters as 3 options, how can we achieve that?
Converting Text to Date and Date to Text
Author: Julie Ziemer is a Certified Master Anaplanner, Anaplan Community Boss, and Solution Leader/Business Analyst at Akili. While Anaplan has specific functions to convert between data types, converting Text to Date and Date to Text are two commonly searched topics on Community and they require the use of several…
An NPV formula that calculates as Excel's does
Description: To have an NPV formula function that calculates NPV exactly as Excel's period-based NPV formula does. Benefit/impact: Current NPV formula returns results as Excel's XNPV formula does (using elapsed days instead of periods). We are in a position of having prospective customers and existing customers use…
Best practices to clean up models (especially Actions)
Hi everyone, Trying to get some ideas and best practices from this great community on how to clean up unused fields in Actions. I recently deleted some line items that I was no longer using. There was nothing in the "Reference by" column so it made sense. But they were linked to some Actions to Spoke models and I ended up…
Produce random numbers
Hi, I was wondering if there is anyway to have random number generator? Thanks
Random number generator
Is there a way to generate random numbers from a defined range of numbers so that the numbers being changed regularly in a module every time we refresh the model or just run an action?
RANDOM() function
Function that will generate random numbers, between specified min & max values. Excel has two functions to provide random numbers: RAND() generates a decimal value between 0 and 1 RANDBETWEEN( x , y ) generates an integer >= x and <= y It may be worth considering an extension to these functions such as: RANDOM( x , y , z)…
OEG Best Practice: Pre-allocation in lists (and impacts to model performance)
What is pre-allocation in lists? Pre-allocation in lists is a mechanism in Anaplan that adds a buffer to list lengths. It is not added by default for lists; it becomes enabled when a role is set on a list. Please follow 1.03-01 though. Only add roles when needed. When it is enabled, a 2 percent buffer is added to the list,…
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…
Noted! Using model notes in Anaplan
Author: Hillary Sich is a Certified Master Anaplanner and Consultant Manager at Allitix. We use sticky notes, OneNote, Evernote…. Even if we can’t agree on the type of notes we use in everyday life, we can all agree that notes are an important tool. We use them for organization and communication. The big question here is,…
Variance impact calculator
Author: Anya Skvortsova is a Certified Master Anaplanner and CoE Lead at Asana. Purpose FP&A is often asked to calculate the impact of variables on the total variance. There is more than one way to go about it. I’d like to share a variety that uses the typical Salary/HC reporting modules output to define the contributions…
Level 2- Sprint 1- 1.3.6
Hey everyone, I am hoping someone would be able to provide some clarification for me. I am on lesson 1.3.6 of Sprint 1 for Level 2 and it states that the following items need to be in the saved view. What are the subset line items? "Include: Code, Parent, and subset line items" Thank You, Laura
Calculate Space Utilized depending on Format and cell count
Hello Anaplanners, I have small query regarding size calculation, like how size of model is calculated using cell count of lineitem depending upon format used.. I would be better if I can get example calculation explaining how size is calculated using different format. Thankyou
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…
Level - Sprint 1 - 1.4.6.1
1.4.6.1 Rename Actions Using the recommended naming conventions for Actions: * Rename the Actions used to load the P3 SKU list and SYS12 SKU Details system module:* Organize the Actions in the correct sequence. * These Actions will be included in the Process: 1 Load Products. * Rename the Action used to Build the P3 SKU…
Calculating in a ragged hierarchy?
Does anyone know how to do a calculation in a ragged hierarchy which returns to the level of the hierarchy?
Ragged to Balanced Hierarchy
Please can someone give the step by step points in an easy way to convert a Ragged Hierarchy to Balanced Hierarchy in Anaplan. Thanks!
Filter the Hierarchy Level
Hello all. A few days ago I saw a "How I Built It " video regarding the Hierarchy filter which taught me how to use Ratio Summary for filtering . I wanted to replicate the same structure but here is the thing. I created a module for filtering Group level ( higher level ) or Product level ( Lower level ) like the picture…
Time Problem ASAP
Hello everyone , I have an old model with a time scale of 2023 and 2024 and after that I wanted to add 2025 in the time , some models take in consideration the next year , others not ! Is there any of you who faced this issue before ? If yes can you provide me pleasewith the solution. For me : I doubt that the problem…
Level 2 - 1.6.3.2 Import Data into DAT04 Distribution Center Parameters Module
L2 - Sprint 1 - 1.6.3.2 Import Data into DAT04 Distribution Center Parameters Module * Download data file: Weekly Safety Stock.csv. * Import data file into the DAT04 Distribution Center Parameters module. I am trying to do the mapping Distribution tab map is not coming properly Please help to resolve the issue . Regards,…
4.6.7 Activity: Import Data into P2 Products List
Let me know what am I doing wrong here. getting different result while importing.
Custom Switchover
Hi, I want to build a custom switchover for Fake version/List I created separately (Actual, Forecast, Rolling Forecast) I created a custom switchover time period 2. Then I created a custom switchover period 3. Next, I have the module where I want to apply the formula, however its showing Circular references: values Result…
How I Built It: Replacing the "group by" function of Excel in Anaplan
About the Author: Damien Bouquier has been a Certified Master Anaplanner for 5+ years and has developed solutions across a wide range of industries for FP&A, supply chain, and sales operations planning use cases. Hi Anaplan Community! Excel allows you to group and ungroup data areas to explore the data. Anaplan does not…
Copy a branch to another Parent.
I want to Copy a branch to another Parent. The hierarchy is 5 levels and i want to copy an item at level 3 and all its children to another item under level 2. All suggestions are appreciated!
Did You Know? Model building hacks
Author: Kirill Kuznetsov is a Certified Master Anaplanner and Solution Architect at Planingo. Hi fellow Anaplanners, Today I would like to share six model building hacks I use on a daily basis. This is not what can be found in Anaplan learning course — some of them I figured out myself, some are hidden in Anapedia, and…
Question 6 in level 1 model building exam
Could anyone who has finished the exam show me the formula for question 6? I failed 2 questions for this part. I think I just need to refer the relevant numbers from another module and apply selections, and then it could be done. However, my way didn't work. Here's my formulas. Thanks very much!
Activity : Filtering and Displaying Hierarchical Data
I want to create an interactive anaplan module that allows user to select an item from a hierarchical list and dynamically display associated items from the next level in the hierarchy Lists : P1 Product Family ( LVL 1) P2 Products ( LVL 2) P3 Products SKU ( LVL 3) Requirement : When a level 1 item is selected , display…
Creating iterations in Anaplan
Hey Everyone, I'm trying to find a solution in an excel sheet that utilizes an iteration function that I need to replicate in Anaplan. Basically, we take the previous number multiply it by 90%, then take that new number and multiply it again by 90%. For example, FY2024 is 28,940 FY2025 is 26,046 FY2026 is 23,441 (etc etc…
Separate into Several models
Hi. We will start a new project. In previous project, we made 1 model in 1 workspace. Off course, we have several models like (sand, test, Production model). It means we had several information in 1 model like (HR, Marketing so on..). Then, we can make separate models like HR model and Marketing models ? And We can share…

Modeling

Discussion List