How to

[Start Here] User Access Management - Part 1: Get Started
A foundational design element of any Anaplan model is User Management. This includes creating the design within the Anaplan model and app, as well as establishing the process for managing and maintaining access once users are active. The table below contains questions that are typically asked as part of the Foundations…
Building a Chat Bot - Part 2: using Slack App and Ngrok
In our part 1 (for AWS or for GCP), we set up the foundations to build our grand project: having a chatbot interacting with Anaplan. By getting a new token at will, we will then be able to authenticate to Anaplan as many times as we need. We are still far from our main goal though. So, let’s continue! In today’s series, we…
Hosting Images on Google Drive, Box, or Sharepoint
* What is Visual Reference? * Image Hosting * Google Drive * Box Folder * SharePoint * Imgur What is Visual Reference? Visual reference while planning can be a very powerful tool. The human brain processes image 60,000 times faster than text, and 90 percent of information transmitted to the brain is visual. Since we are…
How to Interact With Anaplan Application Lifecycle Management (ALM) APIs?
* What is covered in this article? * What is NOT covered in this article? * What pre-requisites do I need? * Introduction * Anaplan Setup * Postman Setup * ALM Process * Step 0: Create Revision * Step 1: Take Target Model Offline * Step 2: Retrieve last revision from Target Model * Step 3: Retrieve syncable revision tag…
Reducing Text Calculations
This article builds on and gives an effective method leveraging techniques and concepts spread across Anaplan. For further reading, please see at the end for those other articles, guidelines, etc. In addition, this article is written with the understanding that the problem that you are solving at hand has no other choice…
Sync Multiple Production Models at Once Using ALM API
With the release of the new ALM APIs recently, I thought it would be useful to see a real-life use-case of how they can be leveraged. Oftentimes customers will have a single development model tied to multiple production models and when changes need to be pushed, the model builder must go into each production model to do…
Allocation Using RANKCUMULATE
* Overview * Before You Start * Allocation Example * Business Problem * Module Overview for this Example * Setting up the CALC: RANKCUM Alloc Module * Evaluating the Results * Further Considerations For a refresher on the RANKCUMULATE formula, click here. Overview The purpose of this article is to demonstrate how to use…
CloudWorks—This is how we use it, Part 4: Using CloudWorks APIs with AWS Lambda
In Part 3, we described the procedure for using CloudWorks APIs. But the main question would be, how can we use them? Indeed, we can find that having a dedicated screen in Anaplan itself is already a major step forward. And it surely addresses most of the future needs. Nevertheless, in our strive to open our platform as…
Anaplan Connector for Informatica Cloud – Part 3: Imports and Exports
* Informatica Anaplan Connector Standard Practices * Model to Model Imports * Executing a process with multiple import actions * Solution 1 * Solution 2 * API Based Metadata Usage * Scenario * Export Actions in a Process * Exporting Users LIST * Capture ERROR DUMPs * Error Dumps & Processes For a refresher on the…
Anaplan Connector for Informatica Cloud – Part 2: Design Guidelines
If you need a refresher on the Connector, read our Part 1 - Start Here article. What is covered in this article? Standard practices on building integrations using Anaplan Connector for Informatica Cloud (Hyperconnect). What is NOT covered in this article? This article does not cover training on building, executing, and…
Python and Anaplan: Pt 1—Setting Up Your Environment
Combining a scripting language such as Python with Anaplan can provide you and your team greater flexibility and functionality in your planning journey. If you've never used Python before, or want to check out some different ways and use cases of Python and Anaplan, look no further—this series of articles will introduce…
Python and Anaplan: Pt 2—Anaplan Model Registry Case Study
Welcome back to the second article of our Python and Anaplan series! If you're joining us for the first time, please see Python and Anaplan: Pt 1—Setting Up Your Environme... - Anaplan Community for help setting up your environment. What's best next—start using your Python environment in a real and useful scenario. With…
DocuSign Connector: Part 3 - 5 tips and tricks you didn't know about the DocuSign Connector!
* 1: Set Signing Order First * 2: Use Saved Views to your Advantage * 3: Use 1-Dimension Output Module * 4: Use Flat Lists * 5: Do not use 'List' format Before we get started, if you need a refresher on the DocuSign Connector, go here, and if you want to leverage Anaplan, DocuSign and Box, go there. The Anaplan DocuSign…
DocuSign Connector: Step 2 - Layering in Box
* Phase 1: Setting up Box * Step 1: Set-up your Box Folders * Step 2: Format all Folders * Phase 2: Setting up DocuSign * Step 1: Add a Box Recipient Layer in DocuSign Workflow * Phase 3: Setting up the Anaplan Model * Step 1: Update Model Logic * Step 2: Add the Box Layer Line Items into your Output modules * Phase 4:…
[Start Here] Anaplan Connector for DocuSign – Part 1: The Basics
Welcome to your introduction to the Anaplan Connector for DocuSign. What you’ll find here is a quick walkthrough of the DocuSign connector, where we’ll quickly cover the basics of what the DocuSign connector is, who it’s for, and a quick discussion of some popular use cases for it. Let’s get started. What is the Anaplan…
CloudWorks–This is how we use it - Part 5: Model-to-model
If you need a reminder on CloudWorks; go here. Why we are excited With the new CloudWorks release comes a long-awaited feature: “model-to-model" (or M2M) actions. Until now, you had 2 options to automate Anaplan-to-Anaplan flows: Implement a third-party tool such as Anaplan Connect (requiring a server that can run Java) or…
Building a Chat Bot - Part 1: using AWS
* What is covered in this article? * What is NOT covered in this article? * What pre-requisites do I need? * Introduction * Using Anaplan APIs on AWS Cloud * Authentication * Create a role * Python Code * Examining the code * Best Practice: Information encryption * In summary What is covered in this article? First of…
Bridging Versions With Waterfall Charts
General Requirement For a set of measures, end users want to be able to choose any two versions and see the calculated variances between them. They also want to see a visualization in the form of a waterfall chart that explains the difference between the selected versions. Problem Statement Let’s say we have a summary…
How to create a time filter module
This article provides the steps needed to create a basic time filter module. This module can be used as a point of reference for time filters across all modules and dashboards within a given model. The benefits of a centralized Time Filter module include: * One centralized governance of time filters * Optimization of…
[Start Here] CloudWorks—This is how we use it, Part 1: The basics
Welcome to this three-part series: CloudWorks—This is how we use it. Here we will help you understand why and how to use CloudWorks, covering the basics, setup, and APIs. Let's begin with Part 1: The basics What is CloudWorks? CloudWorks simplifies the data integration process, allowing end users to easily access the data…
[Start Here] Anaplan APIs in a Nutshell
* What is covered in this article? * What is NOT covered in this article? * What pre-requisites do I need? * Introduction * Authentication * Integration API * Bulk API * Transactional API * CloudWorks API * Application Lifecycle Management (ALM) API * Audit API What is covered in this article? High level description of…
Transactional APIs - Part 3: SQL Query Anaplan data using Transactional API via Data Virtualization
Here’s a sample transcript of conversations I routinely have with our customers who are new to Anaplan platform: * Customer: I have a need to query Anaplan ‘table’ and integrate Anaplan data to my database. Is this possible? * Anaplan: Certainly, using Anaplan Transactional APIs, you can query a saved view and output the…
Impact of Model Archival on UX Pages–and the Workaround
If you have been using the current UX for quite some time you would have probably realized by now that models and apps are two different entities/sections within Anaplan, and they are not connected to each other by default—unlike Classic UX where dashboards were part of the same model and were always connected or attached…
PlanIQ - Dealing with outliers
Outliers in time series data are values that differ greatly from the rest of the time series. Outliers can be caused by measurement errors, data entry errors, organic real occurrences such as seasonal effects and other reasons. Since outlier values could impact the accuracy of the predictions produced by forecast models…
PlanIQ - How to manage NULL values?
In real-world forecasting applications, it is common for datasets to contain null values, which represent missing values for specific points in time. There can be multiple reasons for the presence of missing values. For example, a transaction may not have occurred, or a device or service that monitors data may have…
PlanIQ - Algorithm selection by item: mix and match your forecast
What is algorithm selection by item? Algorithm selection by item is the use of more than one algorithm to produce optimal forecasts across multiple items. Instead of using forecasts generated by a single algorithm for all items in the historical data module, where the algorithm is selected based on best overall performance…
PlanIQ - New product introduction: all you ever wondered about starting your forecast from scratch
New Product Introduction (NPI) or Cold Start in time series forecasting is a scenario where forecasts should be produced for new items (e.g. new products, new SKUs) for which there is limited historical data, or no historical data at all. Items with no historical data In scenarios where the new items have no historical…
PlanIQ - How to use item attributes to refine your forecast
Metadata attributes are static, non-time dependent categorical text features that describe the items in the historical time series data. Examples for attributes could be style, category, geographic location, size, item hierarchy level etc. The advanced neural network machine learning algorithms supported by PlanIQ can…
Anaplan Connect 2.0 - Approaches to Anaplan integration using On-Prem integration platforms
This article is the last one on our series about Anaplan Connect 2.0. To refresh your memory on Part 1 & 2, go here and there. There are several On-Prem integration platforms that are popular amongst Anaplan customers. These include Informatica Power Center, IBM InfoSphere DataStage, and Talend Studio. However, none of…
Anaplan Connect 2.0 - Advanced Scripts
This article is the 2nd part of our 3-blogs series on Anaplan Connect 2.0. If you missed part 1, go here. Disclaimer:The scripts and examples in this article have been fully tested by our team, but they are not supported by Anaplan; if you have any issue, please use the comments below. Target Audience: Integration…

How to

Discussion List