-
Extracting data from Anaplan with Qlik Sense
So you finally did it – you joined the Anaplan Community. So many possibilities just opened up in front of you when it comes to connected planning and finance, but what about analyzing and visualizing your data? Well, no need to worry about that because Qlik has that part covered. In today's article, we'll be talking…
-
A primer on Anaplan integration using Azure Logic Apps
Introduction With the release of Anaplan Cloudworks, this flow may be better addressed via a blob storage connection in Cloudworks, or with a combination of a Cloudworks flow and a post request to the Cloudworks API. My colleague @christophe_keom published a guide covering this topic. In my case, I wanted my flows to run…
-
Using saved text strings to speed up blueprint configuration
This is an addition and update to a existing community article using similar methods now in the latest modeling experience. As a model builder, you have to define line item formats over and over. Using saved text strings, you can speed up the configuration of modules. When you add a new Line Item, Anaplan sets it by…
-
How to automate subsets
How to ensure your Center of Excellence keeps on top of subset management One of the easiest things that can go wrong in a model is when subsets get out of sync. In larger models you may have multiple subsets on large lists and keeping track of them all can quickly become very difficult. For example, what happens when…
-
How To Convert Infinity, -Infinity, NaN to Zero Value
Sometimes in the numeric formatted cells, as a result of various calculations, it is possible to have returned as a result the Anaplan special numbers: Infinity, -Infinity, or NaN (Not a Number). If the numeric line item with this issue is also an input for other formulas, the final result could be altered. To solve this…
-
[Start Here] - Management Reporting
Welcome to this article on Management Reporting, our exciting new feature for the UX! Ready? Let’s go! What is Management Reporting? Management Reporting allows you to create highly formatted, customized slides to deliver key insights and clear reporting to your organization using the new presentation mode in platform.…
-
Overview of Anaplan Data Integration Options and Which is Right for You
* Manual Import/Export * Anaplan Connect * CloudWorks * REST API * Anaplan HyperConnect * MuleSoft, SnapLogic, Boomi, and OneCloud * Power BI, Tableau, and DocuSign * Anaplan Tab in Salesforce.com * Conclusion Anaplan offers various ways of integrating data into the platform. The decision of how to import and export data…
-
OAuth - Part 3: Third-Party Applications
If you need a quick recap on getting started with OAuth and a Use Case illustration, click here and there. What are we talking about? Historically if a customer wanted to build a software application that interacted with Anaplan, a service account would need to have been used to authenticate into Anaplan. I will be…
-
OAuth - Part 2: Illustrated Use Case
Now that we are more familiar with the concept of OAuth, let’s see it in action. Adding a new way to connect to Anaplan and get an access token Now that we know more about the Refresh Token, we can imagine a customized script using OAuth information for as long as the token remains valid. In those scenarios, you might want…
-
[Start Here] OAuth - Part 1: The Basics
* What is available today? * What are the key benefits from OAuth? * How do OAuth works? * How to leverage the OAuth protocol? What is available today? Up until the release of OAuth support, when it came to integration, Anaplan supported 2 different methods: * Basic Authentication: Scripts and other tools whose purpose is…
-
Optimizer: Hands-on exercises
Now that we know what Optimizer is and how it can help your organization solve complex business challenges, it's time to get under the hood and practice. We curated for you 3 different exercises based on different use cases; we also have an available E-learning course. Immersion Optimizer overview Optimizer toolbox…
-
Building a Chat Bot - Part 1: using GCP
* What is covered in this article? * What is NOT covered in this article? * What pre-requisites do I need? * Introduction * Using Anaplan APIs on GCP * Authentication * Secret Manager * Create a Google Cloud Function * Examining the code * Best Practice: Information encryption * In summary What is covered in this article?…
-
ALM APIs: This is how we use it
Application Lifecycle Management APIs (ALM APIs) were released earlier this year, and their purpose is to make model change management more scalable, automatable, and integrate with other systems. We have seen the ALM APIs being leveraged in 3 distinctive ways: * to orchestrate and run multiple model deployments (model…
-
Decoding Anaplan Errors in Model Building
Anaplan is a very smart and intelligent platform, and it educates its model builders/developers brilliantly about the mistakes or errors made. Here are some of the common errors that may occur while model building—decoded. ERROR 1: Automatic Sum of “Module.Line item” over “List hierarchy” is not possible, as “List” doesn’t…
-
Transactional API tutor
The purpose of this Transactional API tutor script based on Python is to facilitate the learning process of Transactional API Calls using the Anaplan platform. This version contemplates the most common Transactional API calls until November 09, 2020. Download the Python Script file using the file attachment located to the…
-
[Start Here] Application Lifecycle Management–Part 1: The basics
While building in Anaplan, have you ever wondered how to make model building more efficient, stable for your end-users, and increase control over access rights and changes to model structure? Then you may think, how do I have that much structural control but still be agile enough to make quick modifications to my apps and…
-
[Start Here] SCIM - The Basics
Are you using Central Identity Management (CIM) and want to connect Anaplan directly to your Identity Management System (IDMS)? Are you facing challenges with a Security audit? Would you like to add Anaplan to your corporate User Provisioning process? If any of the above questions describe even a part of your Anaplan…
-
Plan better, faster; migrate to the UX!
Provide your users with a seamless, intuitive, modern experience for them to plan more efficiently in a collaborative way, at their desks or on the move. Present and distribute pixel-perfect, visually appealing reports to stakeholders. The Anaplan UX (formerly new UX) has been with us for over two years now. Since it was…
-
SCIM APIs: A Use Case to enhance your Central Identity Management (CIM) Process
Need a refresher on SCIM? Read our [Start Here] article! What is User Provisioning? Let's start with a reminder; User Provisioning is a process by which an individual is granted access to the Anaplan platform and assigned the model role that allows them to interact with the information that they are authorized to use. We…
-
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…