How to

Export Issue
When I'm trying to Export a file from the Anaplan model in .xml format I'm getting an error message like below:- But when I'm trying to export the same file via CSV format, the row count is below 700. But previously the mentioned file was able to download in excel format without any issue. Can anyone suggest what will be…
LEVEL 3 Subsidiary view
Dear Members , I have done the following as shown in the screen shot . Is this Correct ? If no/yes , why ? For subsidiary view for Location : has taken (G3 Distribution center list )--- Is this correct ? or should I Take ( G3 location list ) Need Guidance in this regard Thank you
Community perspective: Central User Access Management
What is Central User Access Management? "Central User Access Management" is an Anaplan model through which we can maintain user access management for all the models within an enterprise. This is not readily available in Anaplan AppHub, but it is easy to create and maintain. This article will explain how to do it. Why we…
need to get lineitem into module with different dimensions
Hi All, In need of some dire help right now. Background: I work for a lending company. We dimension the data by turn (you can think of this as length of the loan) How can I pull the "override amount" line item in ss1 into the "override from UX" line item in ss2? it can go into any of the list members in dimensioned in the…
Anaplan way
Hi Members , To get a Certificate , Is it necessary to Complete " My Anaplan way " If Yes , how much does it take to complete ? Thanks
Workarounds To Sum Data While Using NONE as Summary Method Within Source Module
As the Anaplan model size capacity has recently grown from roughly 18 billion cells to 100 billion cells with the introduction of HyperModel, it is still important to structure models efficiently, while creating as little 'wasted space' as possible. The Planual states that the Summary Method for most line items should be…
Quarter Boolean to check off at the last month of the quarter
Hello, I currently have a Boolean that is manually checked. It is selected at the quarter level. How could I get it to check off another boolean that is monthly? I would like it to check off at the last month of the quarter. Please let me know if this is clear. Thanks
In-app help for end users
A customer recently asked me, “What ease of use features are available in the Anaplan user experience (UX) to help drive end user adoption and engagement?” The customer was about to roll out Anaplan to a large number of first-time Anaplan stakeholders and wanted to do everything possible to ensure excellent end user…
[Part 2] Using line item subsets for dynamic error messages for user input validation
* Step 1: Create a module for your error messages * Step 2: Create your line item subset * Step 3: Create a System module to store metadata associated with the validations * Step 4: Create a module and use COLLECT to summarize error information * Step 5: Create an Output module to display the error messages and other…
Community perspective: RANK and row counts – Management Reporting with multiple lists
A common request within any planning project is to create well-formatted, standard reports for the business to consume. However, these aren’t always as simple to create as first thought. The Management Reporting capabilities within Anaplan produce great looking outputs. However, they require a fixed number of rows for each…
[First Look] Pages Interface: Modules
Feature: Pages Interface for Modules Release Date: September 2022 Impact Assessment: Better alignment with UX pages What is changing? A new tab is available in the Admin screen of the Pages interface called Modules, which lists the modules used on that page. Those names can be selected and will open the modules as a new…
Community perspective: IFO – UPPER and LOWER to the rescue
IFO is a very crucial formula to use when working with raw data, staged in Data Hub, to create lists from within the data's metadata. It truncates the metadata within its line item to "Its First Occurrence" to prevent duplicates being imported into its target list. This keeps the action results clean and optimizes…
Untangling Anaplan time mapping in imports
There are four cornerstones in The Anaplan Way, with data being one of them. We all know that we should spend at least 1/3 of the project time on data alone because this is the cornerstone that we have no control over, and it needs to be thoroughly investigated and understood. One of the important things to consider about…
Management Reports: Table card formatting options
With the introduction of the table card in Management Reporting, you now have several formatting options available to determine how you want the table and data to appear on your report. This article will guide you through those options and guide you on when to use them. When looking to format the appearance of your Table…
[First Look] Tab Split View
Feature: Tab Split View Release Date: September 2022 Impact Assessment: Optional Change What is changing? A tab split screen (view) will now be available for both Workspace Administrators and End Users. This functionality is comparable to the undock feature in the classic experience. What are the benefits? With the tab…
[First Look] Enhanced Object Search
Feature: Enhanced Object Search Release Date: February 2022 Impact Assessment: Quicker navigation & model building What is changing? The new Search functionality is a new and centralized way to explore model objects and simplify how you navigate throughout your models What are the benefits? A single search will find…
[First Look] New Features in Modeling
Introducing new modeling features If you are looking for a brief overview of the new features available in modeling or the modeling experience, you have come to the right place. In this article, we will add links to new model building features and provide an overview of the essentials of the functionality. When possible,…
Anaplan SCIM APIs in Postman
WHAT IS SCIM? System for Cross-domain Identity Management, is a REST and JSON-based protocol open standard created in 2011 that allows companies to securely automate the exchange of user identity data between an identity provider, such as OKTA or Azure Active Directory, and an enterprise SaaS application, such as Anaplan…
Community perspective: Data Hub organization
This article is intended to help assist and standardize Data Hub organization across the Anaplan platform. This methodology is intended to help the technical teams, not end users, navigate and create your Data Hub model and troubleshoot problems with individual data sources efficiently. Functional areas To begin, setup…
Headcount alignment playbook
Table of contents: * Problem statement * Proposed solution * Stakeholders and responsibilities * Data sources and integration * Return on investment * Conclusion Problem statement Anaplan has had challenges getting our finance, human resources, and sales teams on the same page of what our headcount is and what our…
Community perspective: Employee grouping for sales targets
Within sales and target setting use cases, there are often situations that require assigning specific targets to a group of employees. While this can be done manually or through a blanket allocation, it may be more advantageous to designate groups within regions or markets for the purpose of distributing targets. There are…
Suppressing zeros in line charts
Problem statement Solution options Line item format setting: Zero format Chart configuration: Trailing zeros Suppressing all zeros in line charts with NaN Conclusion Additional resources/credits Problem statement Let's consider plotting a line chart for the following data set: For this example, I want to exclude zeros from…
Updating an import source file
Introduction The process to update the source file for an import action is not obvious—but it is simple. There are a number of reasons you may wish to update an import source file, and I have listed some below: * Adding or removing fields from your source file and target list or module * Changing the format of specific…
[Part 1] Validating user input in Anaplan: Approaches and challenges
Pros/cons of common approaches Common approaches: Examples Error logic User experience Example 1: Simple error messages Example 2a & 2b: Nested IF statement Example 3: Concatenation of multiple error messages Example 4: Separate errors for each line item Wrap-up of Part 1: Summary of common (sub-optimal) approaches…
Automate current date import using Power Automate
As you all know, Anaplan cannot display the current time from a function, so it needs to be imported into a module by an import action. As described here it can be done via Python: Import and automate current date import to Anaplan. I would like to to show you an easier way of doing it when your organization has access to…
Use Power Query in Excel to leverage the power of the Anaplan API
When working on our quality assurance items, we realized that one of the items that could go wrong in our regular data loads was that the lists loaded to our data hub could be empty. We had to figure out a way of monitoring this in a simple and straightforward manner. So, I decided to go for the combination of Excel and…
Reports, Boards and Worksheets–When to use which?
* High-level view * Report * Board * Worksheet * Let's deep dive * What about other reporting options? * In summary [Updated July 2021 with the new Management Reporting feature] As you are embarking on the UX journey, you may ask yourself: When should I use a board? When should I use a worksheet? And, When should I use a…
How to SUM using a dummy list
What is it? This article explains how to SUM, SUMIF, and use other aggregation methods using a dummy list rather than Anaplan’s native summary functionality. Why is it useful? Anaplan's native summary logic is simple to use, elegant, and effective. However, sometimes it results in bloated modules that use up workspace…
Evolve your Anaplan ecosystem with enterprise governance
Center of Excellence Model Governance Workspace Architecture Data Hubs Data Integration Build & Manage Security In this article, you'll find resources to support evolving your Anaplan ecosystem with enterprise governance. This broad topic was covered in depth during Anaplan Live! 2022 — including focused discussion on…

How to

Discussion List