-
How to create a module with a Boolean option that switches off "write access" on all Boolean boxes?
I am familiar with how to create DCA to switch off the write access for a list item. This example is costs for a land appraisal. Here is a module with rows that are editable. Here is an override module where I can change access from Write: To read: Now the Pricing method for the first 3 rows are greyed out: I can create…
-
Nested Ifs | Model Optimization Team series
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 guide how to build with best practice intentions for these model building topics. Each month, two of our analysts will take…
-
Allow the same action to run multiple times within a single process
Description of the enhancement required: Allow the same action to run multiple times within a single process How would it help your business process: There are many situations in which this would be helpful. One example Setting a production plan based on prioritising SKUs. i.e. The capacity of a production line is…
-
Running alternate hierarchy
We currently run the following hierarchy within our system This works for how the business currently reports, however in the future will need to still be able to report in the above hierarchy but then we would also need to report in the following structure. As you can see the bottom level would be the same, however I would…
-
Build a random number generator in Anaplan
Author: Noah Jackson is a Certified Master Anaplanner and Principal Data and Insights Architect at Anaplan. Anaplan does not have a RANDOM formula or function, but random numbers can be useful — I was interested in it for generating sample data, but it could potentially be useful for other applications such as Monte Carlo…
-
Variance Analysis With Native Versions Made Easy
When creating a model using versions, one of the first questions is, “Should I use Native Versions, or should I create a Custom Versions list?” Will I need to do version comparisons; do the comparisons need to be dynamic? With Native Versions, I can create another Variance version and create a formula, but a) it is not…
-
New UX Idea - Apply one more model source to all pages of the app at once
One of our model a dev and multiple prod models linked to a single dev via ALM. We have developed New UX App based on dev with a lot of pages in it. My aim now is to apply all prod models we have to this app, but the existing procedure is not effective for this idea. I want to have ability to add new source to the excising…
-
Model Changes Tracking
Hello, Recently, I have been involved in a Model Building activities. Project has two teams. Original MBs and my team to take over. My question is : if there is a way to track who created a particular module, line item or applied changes? (Apart from "History" tab)
-
Level 2 sprint 3 INV02 Country summary module
I am a loss how to build the formula for the Iine item safety stock flag count in INV02 I know this inv02 module is linked to inv01 's line item safety stock exception count (ending inventory is lower than the safety stock target level) the picture given in Anaplan tutorial is fairly difficult to understand how to link sys…
-
Level 2 Sprint 3 INV02 Country Summary module
I've created the INV02 Country Summary module and when comparing the "Stock exception Review Dashboard" the numbers do not reconcile. it seems like the safety stock flag count is not counting at the Product family level or it is individually adding up the "1's" per week as opposed to per month. I've attached my view as…
-
Native Version to Fake Version
Hey Champs, I was asked to provide a solution to one of the problems that one of our community member (@Naveed - not sure if this is your right handle) is facing. I couldn't arrive at the solution but was able to provide him the workaround. Let me know your thoughts on this He is using Native Versions in his planning model…
-
How to perform different calculations across list members in a hierarchy?
I came across the following situation and wanted to get more input on how others might handle this. If I am looking at a standard P&L hierarchy where the P&L lines are list members, is there a simple way to use Anaplan to calculate a line item differently for different list members (that doesn't involve long nested IF…
-
Impacts of copying or importing a model
Introduction When copying or importing a model to a different workspace within the same tenant, it’s important to understand all the pieces that are impacted by this action. It's commonly thought of as 'moving' a model. However, the reality is that a completely new model is being created with a new model GUID.…
-
alternative hierarchy
Hi Anaplan community, I get a request from the business to add another view to the aggregation of the organizational hierarchy in an existing model. Currently we have a couple of sites, rolling up into platforms, rolling up into "Global Manufacturing" or "Global Overhead". This is currently setup using hierarchical lists…
-
Email Notification
I created a action - to add list member. Additionally also a notification to notify me via email if there will be a new List member added. But unfortunately it is showing me two different buttons to execute the process. Is there any way i can create in one process the adding of list member followed by Email notification?…
-
Import Final Demand Forecast into DAT02 Module
Good Morning, While doing this activity in the Conclusion course, I got stuck Indeed, they are asking us to Import the Demand data into the DATA02 SKU Volumes module. But in the Level 1 model, there is not a module called data2. So do we have to create this module? If yes which line item, what to put as page selector, rows…
-
Edit Multiple 'Source Model' Settings for Pages Simultaneously
The ability to edit the source model of multiple pages at once would be a huge quality of life update for page builders. Currently, model builders have to edit settings for each page one-by-one. This idea proposes that page builders can apply the same change to multiple pages at once: image below shows how this could work.
-
Line Item Subset Formatting
This post is a bit of getting ideas to work around but also see if people are experiencing similar issues. I think it would be a good idea if Line Item Subsets could inherit the formatting and time settings from the source modules that they come from. In the situation where you had a KPI which was a %, a number and a…
-
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?
-
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() 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,…
-
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
-
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?