-
How to use “LOOKUP” function in Anaplan: Explanation through an example
Hello Anaplan Community, During my Level-I and Level-II trainings I thought that it would be useful if an explanation with an detailed simulation for use of LOOKUP and SUM functions. There for I prepared a detailed explanation for each functions. Below you can find the explanation with an detailed simulation for use of…
-
Measuring Forecast Bias at Aggregate Level
Hi, I would like to ask if how can we measure bias at the aggregate level. Do I just use the Total Actual Values vs Total Forecast Values to calculate for the Bias%? If yes, how can it consider possible scenario of offsetting biases at the item-level (e.g., one item has +30% bias, while the other item has -30% bias), if…
-
Managing Anaplan ALM with API using Postman Tool
Hello Team, While am trying to retrieve syncable revision tag from the source model, am facing issue of whose screenshot i have attached below, Reference : I have cross verified the ALM between source and target and also i have verified the Model whether its defined correctly in the environment variable and also checked…
-
Demystify non-linear optimization: Episode 2
Episode 2: Changeover optimization In Episode 1, we discussed how to configure optimizer to evaluate IF-THEN logic and multiplication of two binary variables. In this episode, we will be discussing how to solve a changeover issue for the beverage manufacturer. Changeover on a production line happens when the production…
-
Introducing the Optimizer Toolbox
What is the Optimizer Toolbox? The Optimizer Toolbox is a Model Builder’s reference guide that details common linear program constructions for themes such as allocation, scheduling, and time-phasing. Each theme is dissected in a sequence of modules that progress from simple to complex. For example, the “drawer” on…
-
Optimizer: Hands-on exercises
Now that we know what Optimizer is and how it can help your organization solve complex business challenges (quick reminder here) it's time to get under the hood and practice. We curated for you 3 different exercises based on different use cases; we also have an available E-learning course. Immersion Optimizer overview…
-
Demystify non-linear optimization: Episode 1
Prologue The Anaplan community has been facing more and more interesting optimization problem statements every day while they solve complex business problems. Business challenges often involve finding optimal assignments such as sales reps to customers, demand to production capacity, or workers to shifts – all while…
-
A master undo/redo button
For productivity issues, a master undo/redo button on Anaplan will help alot. Currently only few things can be undone, but a master undo will help alot e.g undo data updates, undo formula changes .... Any thoughts!
-
Matrix Inverse using Optimizer
In the following article, we will discuss how to use Anaplan Optimizer to compute Matrix Inverse. Matrix Inverse as a functionality can be used to solve a Multi Linear Regression Problem in Anaplan. Using Matrix Inverse, we are going to solve the following Multi Linear Regression equation: Y = b0 + b1x1 + b2x2 + b3x3 +…
-
IS IT POSSIBLE TO LOCK THE ROLLING FORECAST?
Hi, I would like to know if it is possible to lock or save the rolling forecast for the remaining months of the current year?
-
Dimension Reorder affects any view or Actions
Hi Everyone, I Need to implement planual in which I need to reorder some Line items applies to Lists(dimensions). I want to make sure that this reordering of Dimension should not cause any issues in View(Custom or saved) and Actions. Please Note I am not adding or deleting dimensions in modules just reordering dimensions.…
-
Multiple lists
Scenario: I created a module with 2 lists. List 1 as Pages List 2 as Rows Line items as Column I want to show only few items in List 2 if specific item is selected in List 1. Ex: List 1: 1,2,3, - List 2, 1a,1b,2a,2b,3a,3b if List 1 selected as 2 List 2 only shows 2a and 2b Tried making List 1 as the parent of List 2, There…
-
For any of you Plan IQers...
Update from @Rebecca on new releases - exciting direction of travel for Anaplan developing our own algorithms and also excited to see how this kind of functionality can have application and impact even with smaller data sets. Read more here!
-
Anaplan Live! Recap for model builders and technical teams
Now that a couple of months have passed since Anaplan Live! in San Jose, I have finally had a chance to reflect and think back on some of my favorite topics that were covered in the Platform track. I enjoyed the new and rekindled connections I made at the event, but if you're anything like me, you didn't have time to…
-
Create Product Replenishment Page
I want to understand the relation of the Planning Period Filter for months relation to the INV ordering module and how the data changes
-
Team Up Feasibility Calculation by Optimizer
Hi Community, I am working on a simple team member setting model using optimizer but it keeps returning "The problem is infeasible" error. Here is my model: - The module consist of a Nurse List and a Doctor List. It has three line items : Team, Success, and Team Up Constrain. Team - It is the variable for optimizer. In…
-
how to hide the unique identifier when we duplicate a display name in a numbered list
For eg. I have two line items display name as Brazil here as an example. I want both of them to be displayed as Brazil only and not Brazil(#17) & Brazil(#18) in the Tree View. The issue is only in the Tree view. When we use this list in a module, the display name is shown as Brazil only. The issue stands in the Tree view…
-
How to use “SUM” function in Anaplan: Explanation Through an Example
Hello Anaplan Community, During my Level-I and Level-II trainings I thought that it would be useful if an explanation with an detailed simulation for use of LOOKUP and SUM functions. There for I prepared a detailed explanation for each functions. Below you can find the explanation with an detailed simulation for use of SUM…
-
Change 100items at the same time,from "Clear target prior to import" to "Only update imported cells"
Hi there! I would like to know how can I change one settings characteristic in my Actions. In particular, would be to change from "Clear target prior to import" to "Only update imported cells" in 100 items at the same time, rather than doing so 1 by 1. It would be very usefull. Thank you in advance Community!
-
Where to find Anaplan Sales Planning/Performance Management Talent
My company has seen a huge uptick in demand for Anaplan talent with Sales Planning or Performance Management experience. Most candidates I interview are more on the F&EP side. Where should I look or what measures should I take to find the right candidates? Leadership has also discussed widening the parameters to include…
-
Automate Notification Feature
Hi Team, I have currently published the "Notification" button on New UX page which shares the URL for the respective page with defined "Recipient". Anaplan has introduced the "ANAPLAN Cloudworks" which automates the defined Actions(Import/Export) but how can I automate the notification feature through ANAPLAN Cloudworks…
-
M5 Forecasting Conference on Dec 6-7 is now virtual
While originally intended to be held in New York City, global conditions surrounding Covid have shifted the M5 Forecasting Conference to a virtual event. Although the circumstances are unfortunate, the glass half full take is that the conference is now open to a much larger audience. The last M conference was held back in…
-
Simple and Effective Way to Present Forecast Evaluation Metrics
Predictive forecasting tools like PlanIQ can create incredible opportunities for businesses. If we want the outputs of a forecast model to create value, it's critical that we evaluate the model and present information about its performance in an elegant way that is easy for planners to understand. I spent some time putting…
-
What is Forecastable?
Earlier this year The International Institute of Forecasters launched a podcast called Forecasting Impact. The inaugural guest was Rob Hyndman, a bit of a celebrity to those of us engaged in the forecasting community. Rob heads the Department of Business Statistics at Monash University and authored many of the open source…
-
Change Management: The Achilles Heel of Progress
Overview The scope of the solution is aligned among the project sponsor, key stakeholders, and the architect. The solution addresses all the concerns of the current business process and will drive the expected results once implemented. The project rests on a “Big ****” implementation: a swap out of tools and processes that…
-
high level overview of the different use cases for Predictive Insights, Optimizer and Plan IQ
Is there a slide or resource I can refer to that: describes a high level overview of the different use cases for Predictive Insights, Optimizer and Plan IQ My understnading is : PlanIQ - Uses time based data (historic, related or master) to predict future results Predictive insights - Uses current search trends to evaluate…
-
Move Data Faster With Model-to-Model Import in CloudWorks
Model-to-model import is now available in CloudWorks! Easy to set up and ready to use, model-to-model import helps you automatically move data from one model to another—on the schedule that’s right for you and without additional IT resources. With CloudWorks, Connected Planning has never been easier—you can distribute data…
-
Improving Forecast Accuracy
Improving forecast accuracy often features the business value expected from a system implementation like Anaplan for demand planning. In reality, forecast accuracy is not a business value—but it contributes to business value in terms of better service levels and economic inventory levels. Often, customers want to improve…
-
[Start Here] Anaplan Optimizer
In this series, we will teach you what Optimizer is, how it can help your organization solve complex business challenges, and when to use it. We will approach this in 2 steps: Where to start with Optimizer? (this article) How to setup Optimizer – hands-on exercises For territory assignment For transportation And more What…