Community Knowledge Base

Advance your overall Anaplan knowledge and understanding

Building a pyramid visual using a bar chart
Author: Subham Garg is a Senior Data & Insights Architect at Anaplan. Anaplan doesn’t have a pyramid chart option for reporting. However, there are certain metrics that work better with a pyramid chart than any other chart format. For instance, sales pipeline or number of employees at different ranks in a company are best…
Anaplan's Device Grant API Flow: A Seamless Machine-to-Machine Authentication Option
In the world of modern application development, seamless authentication is key to providing a smooth user experience. Anaplan, a leading platform for planning and performance management, offers a versatile approach to authentication through its Device Grant API Flow. In this blog post, we'll explore the Device Grant…
CA Certificate Quick Start Guide using Sectigo
Creating an Anaplan CA Certificate using the Sectigo Personal Email Security (S/MIME) certificate involves several steps. Here's a quick start guide to help you through the process: Step #1: Purchase the Sectigo Personal Email Security (S/MIME) certificate from Sectigo's website. You can find it here. The cost is $15 for a…
How to Configure Salesforce for Integration with Anaplan CloudWorks
The integration between Anaplan CloudWorks and Salesforce is in the Beta testing phase and is only available to customers enrolled in this program. Find out more about Beta testing, Early Access (EA), and learn how to register for an Anaplan EA program. How to Configure Salesforce for Integration with Anaplan CloudWorks…
Using the Anaplan Certificate with the Anaplan REST API: A Comprehensive Guide
If you're diving into integrating with the Anaplan REST API using an Anaplan Certificate, you'll need to know certain requirements. This post is a step-by-step guide to ensure a seamless connection using Python. If you'd prefer to avoid a programmatic approach to using your certificate, then please check out the CA…
How does Authentication with CA Certs work?
Why CA Certs? The purpose of this blog series is to give a deeper look on the use of Certificate Authority (CA) Certificates, especially on how this method of authentication works and how to use them for your different integrations. A Quick Recap On Anaplan APIs Authentication We recommend our readers to have some basic…
OEG Best Practice: Data integration decision app
We built this app to make getting started on your Anaplan data integration journey simple with a quick questionnaire and helpful information and links. A common question that arises during Anaplan implementations (or even after go-live) is "How can I automate data feeds into and out of Anaplan?" While the ultimate decision…
PlanIQ - Probabilistic forecasting using forecast quantiles
Probabilistic forecasts & forecast quantiles PlanIQ produces probabilistic forecasts. This means that PlanIQ algorithms output a distribution of possible values, rather than a single point forecast typically outputted by other solutions. This distribution can be divided into quantiles. Applied to forecasting, quantiles…
OEG Best Practice: Formula structure for performance
Thinking through the results of a modeling decision is a key part of ensuring good model performance; in other words, making sure the calculation engine isn’t overtaxed. This article highlights some ideas for how to lessen the load on the calculation engine. Formulas should be simple; a formula that is nested, or uses…
Community perspective: How to maintain corporate brand standards in Anaplan
Overview One responsibility of a marketing team is creating and regulating the corporate brand standards. Logos represent the most recognizable part of this tool kit, but the choice in color can be equally important when consumers are challenged with recognizing popular companies. McDonalds: Red & Yellow. Starbucks: Green…
Unlock Your Next Level Model Building Potential with Improved Anaplan DX
Hi Anaplan Community! I’m excited to present you Improved Anaplan DX by valantic, a Chrome extension, that also works seamlessly on Edge. This tool is designed to make your Anaplan model building experience smoother, more efficient and supercharge your productivity. Download the Improved Anaplan DX today to bring your…
Introducing the Anaplan Integration Script Generator: Simplifying Anaplan Connect Scripting
Introduction Anaplan, a leading platform for enterprise planning, has revolutionized the way organizations manage their data and streamline processes. However, leveraging Anaplan's powerful features often requires scripting with Anaplan Connect—a command-line utility for interacting with the platform. To simplify this…
Anaplan API Live: Unlock the power of Anaplan APIs with this comprehensive instructional guide
Author: Anirudh Nayak is the co-founder of Elite EPM and an Anaplan Community Boss. Introduction Whether you're a model builder, a business owner, or an enthusiastic Anaplan user, harnessing the power of Anaplan APIs can be a game-changer. To help you on this journey, I am excited to introduce a new instructional guide in…
Anaplan's Authorization Code Grant API Flow: A Seamless App-to-App Authentication Option
In the realm of contemporary application development, achieving seamless authentication is paramount for delivering an exceptional user experience. Anaplan, a prominent player in the realm of planning and performance management, presents a flexible and robust solution for enabling resource authorization between Anaplan and…
OEG Best Practice: Data Hubs: Purpose and peak performance
You may have heard about a model called a Data Hub, but perhaps you aren’t confident that you understand the fundamentals, primary functions, or considerations when architecting one. There are three main advantages to incorporating a Data Hub: Single source of truth : Stores all transactional data from the source system.…
Using Anaplan Connect with OAuth
How to Use Anaplan Connect with OAuth Authorization Anaplan Connect is a powerful command line interface that allows you to automate your Anaplan environment, enabling seamless data integration and synchronization between Anaplan and other systems. While Anaplan Connect offers various authentication methods, including…
The art of the possible: Predictive profitability
Achieving and maintaining predictive profitability is a common strategic imperative. Anaplan can help organizations with this strategic imperative more effectively manage and optimize their margins. Doing this effectively crosses finance, sales, supply chain, and marketing. Anaplan allows each part of the business to…
Community perspective: Version compare and dynamic module line item description update
There are times when we need to generate output modules with the ability for version comparison. Although Anaplan has its own version comparison function, sometimes we need to build a dynamic scenario creation and comparison function. Please see Planual instructions for versions before proceeding with custom versions, as…
Displaying your data as a Calendar view
Problem Statement Ever wonder how to display your data in a calendar format in Anaplan or simply just want to have a color-coded display based on a specific alert/indicator in a calendar form? Step-by-step guide We just need 2 simple lists Day of Week and Week Number to start with. Then we need 2 modules Day of Week…
Using Python 3 with the Anaplan API
* Getting Started * Authentication * Getting the Information Needed for Each Script * Uploads * Multiple Chunk Uploads * Single Chunk Upload * Imports * Exports * Actions * Processes * Downloading a File * Deleting a File * Standalone Requests Code and Their Required Headers * Get Workspaces List * Get Models List * Get…
Workspace management
This article introduces basic workspace concepts, provides recommendations on how to structure workspaces, and offers tips to help organize and reduce workspace size. Workspaces are a combination of a single or multiple models. Workspace size is the total of all models in a workspace, excluding archived models as archived…
User provisioning
We know how good it feels when you start exploring Anaplan on your own. One very important area that needs special attention from you is the Users section in Anaplan. This is the section where you add users into Anaplan or remove users from Anaplan. There are other things as well that you can do in the Users section, but I…
Calculate the difference between two dates (days/months)
Calculating the difference between two dates is a common requirement and one that you will likely need to do at some point. Below you will find the best practice for calculating the difference between two days, and the best practice for calculating the difference between two months. While there are multiple ways to get to…
Improve Productivity: How to Optimize Scheduling of Products
Business Problem In manufacturing and production planning use cases, we often come across problem statements to solve for optimal product sequence on a production line. As different combinations of products can have different changeover times, a sub-optimal product sequence can impact the productivity of the production…
HyperModel: five tips to improve your experience
Are you considering HyperModel for your ecosystem, or have you recently deployed it? Fantastic! We've compiled a shortlist of the top five tips to help make kicking off your HyperModel experience as smooth as possible. Check out these top five tips to improve your experience: 1. Recognize that the Hyperblock has not…
OEG Best Practice: Line item subsets demystified
Line item subsets are one of the most powerful and efficient features in Anaplan, yet one of the least understood. The COLLECT() function is probably the only “black box” function within Anaplan as is it not immediately apparent what it is doing or where the source values are coming from. In the following article, I will…
Dynamic Display by Language Selection
Problem Statement Ever wonder how to display your data in a different language format in Anaplan or simply just want to cater to language display options based on user selection? Step-by-step guide We need all the lists that require translation to be defined and it is best to have modules with definitions of each language…
Community perspective: How to vary model inputs using optionality
Sandi Duffy is a Certified Master Anaplanner and Senior Finance Manager at Challenger Limited. With Anaplan, it is easy to run multiple scenarios within the same model by using optionality. A common use for this would be during the budget setting process. Say, for example, you have a budget model but would like to see what…
[Start Here] Anaplan Connect 2.0 and JDBC Connectivity
* What is Anaplan Connect? * What is covered in this article? * What is NOT covered in this article? * What pre-requisites do I need? * Deep Dive on Integration * Integrating with SAP HANA Cloud * Integrating with Snowflake * Integrating with Azure SQL Database * Integrating with Google Cloud (GCP) BigQuery * Integrating…
How to prepare for the change to the default Modeling Experience - FAQs
What is happening? The New Modeling Experience will become the default experience in February 2023. It is replacing the Classic Modeling Interface but not eliminating Classic Dashboards or forcing you to use the UX Apps and Pages. What does that mean? Simply, the modeling interface is getting an update to the look and feel…
[Part 1] Enhanced Reporting of the Anaplan Audit Log Summary
As organizations continue to embrace Anaplan's powerful platform for connected planning and decision-making, maintaining robust security and compliance measures has become increasingly essential. The Anaplan Audit Log serves as a critical tool in achieving these objectives, providing granular insights into user activities…
[Part 2] Enhancing Anaplan Audit Log Data Extraction with a Streamlined Python Solution
The Anaplan Audit History project, consisting of several Python modules and a configuration file, works synergistically to streamline the process of fetching, formatting, and loading Anaplan audit log data into a preconfigured Anaplan Model. The project leverages the Anaplan REST API, the Python Pandas library for…
Tip for showing more than 400 items on a chart axis
Problem Statement There is a limit on the number of items that can be displayed on a chart axis in Anaplan. Per the Anapedia page on Chart Settings: Note: The maximum number of items that can be included in a chart axis is 400 items. How do I display my chart if my axis has more than 400 items? Solution (Workaround) While…
Integrating Securely: Using the Anaplan REST API with Certificate-Based Authentication
In the ever-evolving landscape of technology, secure communication between platforms is paramount. The Anaplan REST API offers a robust way to connect and interact with the Anaplan platform, and one of the most secure methods of authentication is through certificate-based authentication. In this article, we'll delve into…
Forward Cover Functionality
Summary Statement In the supply chain horizontal, you may be asked to calculate a forward cover in Anaplan. In this article, we modified a best practice suggestion from @nathan_rudman based on a question posed by @mikhivin about accounts receivable coverage which looks backward. See this post on count back for turnover.…