-
RANK | 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…
-
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…
-
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…
-
SUM and LOOKUP | Model Optimization Team series
Hi! 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…
-
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…
-
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…
-
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…
-
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…
-
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…
-
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…
-
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…
-
Use fake week to replace default week calendar
Author: Kay Kuang is a Certified Master Anaplanner and Principal Data and Insights Architect at Anaplan. Some businesses run their planning or operations by weeks. However, setting the Anaplan model default Calendar Type to Week format can be inconvenient. For example, converting dates to monthly format can sometimes be…
-
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…
-
Bi-directional Integration: Bridging Workday and Anaplan
Intended Audience Level of Difficulty: Advanced Requires an experienced developer, solution architect, or data engineer Resources Required: Internal Expertise: Data Engineer/IT Admin/Integration Admin Tools Needed: Anaplan Connect, SQL Database, Text Editor Access Requirements: Database access, Anaplan model/s Estimated…
-
Set up Aligned DCA and Selective Access Management
Author: Kay Kuang is a Certified Master Anaplanner and Principal Data and Insights Architect at Anaplan. On a list level, you can use two ways to manage the access: Dynamic Cell Access (DCA) and Selective Access. There are benefits and limitations for both approaches. I'd like to share an approach that could leverage the…
-
How to review models and applications to drive improvement
Author: Andrew Martin (@andrew_martin_1), Operational Excellence Director at Anaplan. Overview Many stakeholders ask this question for different reasons. Examples include: A CoE leader needing comfort that best practices have been followed in the build A Solution Architect seeking affirmation that the architecture is the…
-
Data distribution design from Data Hub to multiple spoke production models
Author: Hanwen Chen is a Certified Master Anaplanner and Principle Solution Architect at Anaplan. Use case You may have encountered a situation on your Anaplan project where the model size is too big when you try to load data from different business units (BUs)/GEOs/product groups in a Data Hub into a single spoke model.…
-
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…