-
Enable Sorting by Columns or Rows in UX Worksheets and Boards
Description: Currently, Anaplan UX allows limited sorting capabilities, primarily focused on rows in grid views. However, users often need to sort data by columns or rows, depending on the layout and analysis requirements. This limitation affects usability in both Board and Worksheet pages, especially when working with…
-
Enable Right-Click Functionality on Any Cell Within a Row to Add/Delete List Members in Worksheets
Description: Currently, the ability to add or delete list members in Anaplan UX worksheets is limited to specific interactions, often requiring users to click on the row header or use action buttons. This can be unintuitive, especially when working with hierarchical lists or when users are focused on cell-level data entry.…
-
Ability to Default Close the Additional Insight Panel in Worksheet
Description: Currently, the Additional Insight panel in Anaplan worksheets is set to open if there are cards in the additional insight pane. Proposed Enhancement: Introduce a setting or toggle that allows page builders to default the Additional Insight panel as closed for a worksheet. This could be implemented as: A toggle…
-
Enable Native Reporting from Model History Logs
Description: Currently, model history in Anaplan is only accessible via manual export and review, which limits its usability for ongoing audit, compliance, and operational reporting. Users must download the history file and process it externally to gain insights into model changes, user activity, and data updates.…
-
Enable Case-Insensitive Filtering in UX Pages
Description: Currently, filters applied in Anaplan UX pages are case-sensitive, which can lead to inconsistent behavior and confusion for end users. For example, filtering for "North" will not match "north" or "NORTH", even if they refer to the same logical value. Proposed Enhancement: Introduce an option to make…
-
Enable Moving or Copying MyPages Between Models
Description: Currently, MyPages are tied to a specific model, and there is no native functionality to move or copy them to another model. This limitation creates friction for users who: Build personal pages in a development or sandbox model and want to migrate them to production. Need to replicate similar MyPages across…
-
Ability to perform "Insert Multiple Items" function on Board Pages
Today, you can add more than one list member on a worksheet via a "right-click" > Insert multiple items. However, you cannot do this same action on a board without creating an Import action that temporarily locks up the model. This impacts model builders and architects when designing UX pages and all end users needing to…
-
Multiple Lookups into DATA... module?
I have 3 hierarchies, Customer (C1-C9), Developer (D1-D3) and Product (P1-P6). I also have a combined list C10 which is C9_D3_P6. I have a DATA Rebates module with a LOAD list dimension and properties for C6, D2, P3. I have a reporting module with C10. I've also got a PROP C10 module with line items for each of the items…
-
History Pull Inconsistent Record
I pulled the history log for a specific time period and filtered it by module, line item, and list items. I'm trying to understand how to interpret this history: Row 1: Previous value was 0.5 → changed to 1 Row 2: Previous value was 1 → changed to 3 Row 3: Previous value was 0.5 → changed to 3 Row 4: Previous value was 3 →…
-
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…
-
Does the "Anaplan Formulas & Function" app still works?
Hello, Does the "Anaplan Formulas & Function" app still works? When clicking on "Download this app" I'm directed to a page "HTTP Status 400 - bad request". Thanks, Evrard
-
Invalid Name
Hello Experts, Greetings for the day!! I am trying to import data from data hub into spoke model. While I am importing I am facing one error "Invalid Name". I have checked both data hub and spoke model same list item is present in both models and there is no mapping issue. Could you please help me with this issue..…
-
Regex Formula
It would be very helpful to include a regex style formula in Anaplan so we can pre-process text fields ahead of an integration, or even help to cleanse messy inbound text. Currently if we want to remove special characters, or parse strings into cleaner formats we have to specify one by one the characters we wish to remove…
-
How do I create a dynamic picklist upon Boolean selection?
I want to create a dynamic picklist, where I will check boolean from a line item, only true values will allow me to select list items else on default it wont show anything. For example: Assume a scenario where I want to assign at least 1 employee who is present in my office to become the pantry inspector & review the…
-
How to Design Simulation Planning in Anaplan with Multi-Level User Input and Step-by-Step Logging?
Hi Anaplan Community, I'm working on a simulation planning model where users need the flexibility to input pricing adjustments at any level of the product hierarchy, and I’d love your guidance on best practices. 📌 Scenario Overview: We have a 4-level product hierarchy: Brand Category Sub Category SKU (lowest level) The…
-
What's the impact of using SA for a child list for getting filtered list items in dropdown?
I have a 3-level hierarchy, where the parent top 2 parent list is selective access enabled. I want the bottom-most list to also have filtered dropdown based on its parent's selective accesses. One way I was able to do it is by enabling selective access for the child list and enable Selective Access Boolean in the Line-Item…
-
OEG Best Practice: PLANS: This is how we model
PLANS PLANS is the new standard for Anaplan modeling—“the way we model.” This covers more than just the formulas and includes and evolves existing best practices around user experience and Data Hubs. It is a set of rules on the structure and detailed design of Anaplan models. This set of rules will provide both a clear…
-
Dimensions that don't exist yet
I need to dimensionalize a report in Anaplan by Regions we currently don't use. They aren't in Anaplan at all. We have the accounts we need but the Regions in Anaplan are different that the Regions needed for this report. I know I can create the Regions but the only issue is that I do not have the data needed to input the…
-
The power of the ‘No’ version approach in Anaplan
Author: Hanwen Chen is a Certified Master Anaplanner and Professional Services Sr. Manager at Anaplan. Over the years, working closely with Anaplan customers across industries, I've been called in to diagnose and fix struggling models — often in crisis mode. Time and again, one particular design pattern surfaces as a major…
-
Filter a list by a selector
I have a page that has a list of sellers and a list of accounts. The list of accounts module has a line item of the seller. Is there a way to set up a filter with the accounts card to filter out accounts when I select a specific seller?
-
From clutter to clarity: Mastering documentation in Anaplan
Author: Madison Matous is a Certified Master Anaplanner and Solution Architect at Akili Inc. Though not always the most glamorous task, documentation is critical to overall project success. It serves as a standardized reference for both the development team and end users. Successful adoption of a new Anaplan model is…
-
Best practices for technical documentation of a model
Author: Arun Thakar, Certified Master Anaplanner and Vice President in the banking industry. As go-live approaches and admin and end user training gears up, the question of ‘how do we document the model?’ might be front and center in your daily standups. Fear not! This article will cover some of the best practices on…
-
Creating more flexible export definitions in Anaplan
Anaplan exports, unlike imports, have no link to a saved view. However, there are ways to create Export actions that have more flexibility for future maintenance. After creating your view layout (using the view optimization best practices outlined in the Anaplan Polaris – View Optimization for Imports and Exports article)…
-
Did you know? Boolean read write
Author: Stacey Gibbens is a Certified Master Anaplanner and Solution Architect, Financial Planning & Analysis at Globe Life. Hello, Anaplan people! Today, I would like to share with you a solution to a model-building question that pops up on Community from time-to-time: controlling the behavior of user-facing Booleans so…
-
Two approaches to ragged hierarchy
Author: Taichi Amaya, Certified Master Anaplanner, and Financial Planning and Analysis Specialist at Pasona Group, Inc. In Anaplan, we consider it a significant feature that lists are hierarchical. Hierarchical structure allows for smooth and meaningful connections from the parts to the whole and gives flexibility to the…
-
Avoid the roll back every time the formula is wrong
Every time we create a wrong formula the system runs a roll back that takes about 8 minutes!! We would like to avoid this roll back... it takes so much time during the development phase! They could just send a warning message!
-
Calculation Effort column for Classic Engine
In the world of Anaplan modeling, performance is key. Slow model calculations can be a major bottleneck, impacting productivity and decision-making. But what if you could pinpoint exactly what’s causing the slowdown? Enter the Calculation Effort column — a powerful new feature designed to help you identify and address…
-
L2 Conclusion - REP05 Local Currency
Is there any issue with the formula for Local Currency? - Although it's fetching the correct result, want to check if there is anything else I'm missing. regards Sudhir
-
Using NAME with Numbered list
HI, I have a numbered list - 'employees' with the display name property set as Display Name. I have a system module called employee details dimensioned by employees list. I have created a text formatted line item in the module with the following formula NAME(ITEM(employees)). I expect to see the display name of the line…
-
Moving a model from Classic to Polaris
Author: Mike Henderson is a Principal Solution Architect at Anaplan. There is growing interest in taking existing models that operate in the classic (Hyperblock) engine to Polaris. There are a variety of reasons motivating the move such as workspace optimization, accommodating natural model growth over time, and…