-
Data Quality Orchestration : a simple example with ADO & Workflow - Part 2/2
In this article, you'll find a simple but hopefully inspiring illustration of the power of Anaplan Data Orchestrator (ADO) combined with Workflow. This is a 2 parts article. The Part 1 focuses on the Workflow and the steps to achieve Data Quality tasks. This Part 2 is a deep dive on some details. Above is the final Object…
-
Data Quality Orchestration : a simple example with ADO & Workflow - Part 1/2
In this article, you'll find a simple but hopefully inspiring illustration of the power of Anaplan Data Orchestrator (ADO) combined with Workflow. This is a 2 parts article. This Part 1 focuses on the Workflow and the steps to achieve Data Quality tasks. The Part 2 is a deep dive on some details. Summary For illustration,…
-
Cutover activities: Things to do before UAT and before go-live
Author: Nikitha Kumar is a Certified Master Anaplanner and Sr. Principal Solution Architect at Anaplan. Cutover activities are the tasks that are performed to transition from DEV environment to UAT or PROD environment. In the delivery lifecycle, cutover activities are done twice: UAT cutover activities are done…
-
How to test the ADO Snowflake connector
Author: Noel Rocher, Partner Success Manager at Anaplan Step 1: Snowflake trial environment Go to developers.snowflake.com and select the START FREE button at the top right of the page. To check if the trial account conditions meet your needs, look at the Trial Account overview. Choose the software edition and cloud…
-
How to test the ADO Salesforce connector with a Salesforce Developer Account
Author: Noel Rocher, Partner Success Manager at Anaplan Step 1: Register for a Salesforce Developer Account Note: the Developer Edition is coming with API access enabled. If you are using a Professional Edition, you'll need to purchase this feature. Go to https://developer.salesforce.com/signup Fill out the form Validate…
-
Setup your ADO Demo using an AWS S3 Connection
Author: Noel Rocher, Partner Success Manager at Anaplan The problem statement "I would like to Demo the ADO S3 Connector with a CSV file hosted on AWS S3 as an ADO Data Source." The solution Use a free AWS Account to host the example CSV file. Steps to take We will walk through how to setup an AWS environment using a free…
-
Calculate with the fewest cell | 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…
-
How to roll back a production model to recover lost data
Author: Jessie Zhao is a Solution Architect and Certified Master Anaplanner at Anaplan. Working with a model in ALM has a lot of benefits. These include building new features in a development model anytime without affecting production users, securely managing production lists by identifying structural data that needs to…
-
PlanIQ algorithm properties
Review the table below for information on each algorithm and its specific properties. Question? Leave a comment!
-
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
Please note: This feature is not available at this time and the content has been removed.
-
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…
-
[UPDATED] Summary Calculations with the User List
Author: Rob Marshall, Director of Architecture and Performance at Anaplan, Operational Excellence Group (OEG). Prior to the February 2024, users were not allowed to use aggregation functions (SUM, ALL, ANY, AVERAGE, FIRSTNONBLANK, LASTNONBLANK, MAX, MIN, RANK) when having the Users list in a module because the system could…
-
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…