-
[Start Here] Anaplan Connector for Informatica Cloud – Part 1: The Basics
Welcome to the basics of the Anaplan Connector for Informatica Cloud. What you’ll find here is a quick overview of the connector before we get to the fun stuff: best practices, use cases and tips and tricks! You’ll find notes on what the connector for Informatica Cloud is, who it’s for, and use cases to give you a taste of…
-
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…
-
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.…
-
OEG Best Practice: Governance for the Office add-Ins
General information * We have listed below some of the best practices we recommend for the Anaplan product. These are based on our experience and are subject to change as we deliver new functionalities and learn more about how our customers use the product. * If you would like to contribute or comment, please contribute to…
-
Applying "transparent" conditional formatting in the UX
When we apply conditional formatting to a grid in the UX, there is no option to set a transparent color. However, with some creative use of specific color codes, we can simulate the transparent effect. I will focus on two specific cases below: editable cells and read-only cells. Both of these cases follow the same approach…
-
[Start Here] PlanIQ overview and resources
* First things first * What is PlanIQ? * Who is it for? * Use case examples * Now, let's go under the hood * To get started * Once you get more comfortable * Deep dive on algorithms * Support You are interested in starting time series forecasting with PlanIQ on Anaplan, but you don’t know where to start? You have come to…
-
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,…
-
ALM explained—Part 1: compatibility
Introduction Application Lifecycle Management (ALM) has been available since late 2016, and it is used widely and successfully across the Anaplan-customer base. ALM is founded on certain fundamental rules and structures, which if followed, will ensure the integrity between development, test, and production models is…
-
User Access Management: Part 3 - Practice makes perfect!
This is a detailed walk-through (and a downloadable link to a practice model!) that you can follow to get started on your UAM journey. Note that the examples here leverage the Bulk API for adding new users to models. If you have enabled the tenant-level option to Manage users in Administration only, then you will need to…
-
Calculate once and reference | Model Optimization Team series
Hey! 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…
-
How I optimize model calculation with MAPS reporting
Author: Jessie Zhao is a Certified Master Anaplanner and Sr. Data & Insights Architect at Anaplan. Please note: MAPS reports are dependent on a few key qualifications and may not be available to all customers. Please check with your BP if you have questions. As a CoE member, model building — either for new user stories or…
-
Management Reporting - How to handle Icons and Shapes
With Management Reporting, creating visually appealing reports is even easier. Find below our recommendations to handle icons and shapes in your reports to make them "pop". Icons There are a lot of websites providing free or subscription-based icons available for download and some even allow to change the colors and…
-
Show and Hide Selections in the UX - The Basics
Show and Hide Selections: why use them? When building out your apps and pages in the UX, there are often instances where you want to hone in on a specific set of data. With Show and Hide selections you can surface or remove particular rows and columns from view, providing end-users with a faster route to the insights they…
-
OEG Best Practice: Performance issues with CUMULATE over lists
Problem statement When using CUMULATE over a list—this is when using the format CUMULATE (x, y, z)—the performance can be poor with anything that exceeds a few million cells. This is because the function is running on a single CPU thread, which differs from nearly all Anaplan functions. Anaplan gets its efficiency from…
-
Enhancing Your Anaplan Audit History Reporting with Model History Export
We are excited to announce a significant upgrade to the existing Anaplan Audit History Reporting project written in Python. This project now includes the ability to export Model History. This enhancement provides a more comprehensive view of data changes within your Anaplan models, allowing for deeper analysis and better…
-
How to Clear Data in Anaplan
Overview I came to Anaplan from different database technologies in support of Enterprise Performance Management (EPM), and it was a common activity to ensure that the forecast or plan periods were clear before planning began. These other technologies allowed you to use a scripted language (e.g. SQL) to be very specific…
-
OEG Best Practice: The MOBILE way: Best practices for building in the UX for mobile devices
To achieve the ultimate Connected Planning experience, Anaplan users can use the mobile app to stay on top of their data from anywhere. With Anaplan at your fingertips, creating pages with mobile in mind has never been more important. To design and build pages that look and work great on mobile, use the MOBILE method to…
-
Anaplan API 2.0 Python Library - [Updated March 2022]
* Getting Started * Gathering the Necessary Information * Authentication * Getting Anaplan Resource Information * Uploads * Executing Actions * Downloading a File * Get Available Workspaces and Models * Example Code After a significant amount of refactoring, I'm very pleased to announce the latest release of my Python…
-
[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…
-
Unlocking High-Efficiency Data Uploads in Anaplan: A Multithreading Approach
In cloud-based business planning, the ability to swiftly and effectively upload large datasets is an important aspect of maintaining up-to-date planning. This post introduces the concept of multithreading to enhance data upload speeds to Anaplan significantly. This approach, however, is specifically tailored for data…
-
Performance tuning in Anaplan’s Optimizer
Author: Mike Henderson is a Principal Solution Architect at Anaplan. A question recently came up from a customer regarding Anaplan Optimizer, and I thought it would be useful to share the answer with the broader Community. For background, Optimizer uses linear programming to quickly solve complex problems involving…
-
OEG Best Practice: Dimension order
Dimension order affects calculation performance Ensuring consistency in the order of dimensions will help improve the performance of your models. This consistency is relevant for modules and individual line items. Why does the order matter? Anaplan creates and uses indexes to perform calculations. Each cell in a module…
-
PlanIQ and related data
Author: Evgy Kontorovich, Sr. Director Product Management at Anaplan. Background Customers are frequently wondering what can be used as related data. When thinking about related data, we can think about different types of “internal” time dependent inputs: Historical and future promotions Stockouts Price fluctuations…
-
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…
-
Setting up a process to remove inactive users
Author: Kay Kuang is a Certified Master Anaplanner and Principal Data and Insights Architect at Anaplan. Actively managing the users list to keep the list small and to keep only users who need access to the model will make the model go a long way. The users list can have a big impact on the model's performance — especially…
-
Creating a Data Integration Schema for your Models
A data integration schema describes the integration and flow of data across systems. It will typically consist of a combination of diagrams, tables, and other visual components that provide the ability to quickly understand the flow of data. In an Anaplan context, a data integration schema outlines the movement of data…
-
OEG Best Practice: Best practices for model cleanup in Anaplan
This article helps everyone with the suggested cleanup activities of existing models where Anaplan best practices weren’t adhered to from the beginning. Please follow this and develop a more user-friendly model. User access Begin by revisiting all the tabs in the User Access setting and set appropriate access by roles. A…
-
Transactional APIs - Part 2: Use Cases
Introduction Following use cases will be presented in this section: How to retrieve id for a given dimension/list & list member from its name or code How to retrieve allocated & consumed space for a Workspace & Model Workspace Sizing Use case Model Memory Usage Use case How to retrieve permitted number of Items & Index…
-
Summary Calculations With the User List
Even though the Users list does not have a top member assigned to it, with the release on April 24, 2021, model builders will be able to use the following summary functions with the Users List: SUM, LOOKUP, ISFIRSTOCCURRENCE, CUMULATE, ALL, ANY, AVERAGE, FIRSTNONBLANK, LASTNONBLANK, MAX, MIN, RANK. Lookup First, let’s look…
-
Manage inputs to Management Reporting
Author: Kay Kuang is a Certified Master Anaplanner and Principal Data and Insights Architect at Anaplan. Management Reporting is a great dashboard type in Anaplan. It looks clean, professional, and provides a familiar PowerPoint look to people while it is powered by the live data from the Anaplan model. It is a wonderful…
