-
Data Hub: Will multiple imports and loads at the same time slow it down or lock it?
If two spoke models pull data from the same Data Hub at the same time, will it slow down the Data Hub or cause any locking? Also, if the Data Hub is being loaded/updated with a different set of data while it’s sending data to two spoke models, will that slow down the Data Hub or cause any locking/issues?
-
LDAPS Configuration
Hello, I need a way to route authentication credentials through LDAPS instead of LDAP. Customers have made changes in their security departments and now require all communication to go through LDAPS. Initially, we tried blocking the LDAP port, but unfortunately that caused ANAPLAN XL to fail. However, this is such a…
-
Running NPV Calculation
In as much detail as possible, describe the problem or experience related to your idea. Please provide the context of what you were trying to do and include specific examples or workarounds: NPV function in Anaplan gives the final NPV value unlike Excel's XNPV which can be extended to calculate in each period. We had to…
-
User Access Management: Part 3 - Practice makes perfect!
If you missed the first two articles in this series, read Part 1 here and Part 2 here. This is a detailed walk-through (and a downloadable link to a practice model!) that you can follow to get started on your UAM journey. Note that the examples here leverage the Bulk API for adding new users to models. If you have enabled…
-
Filters on UX Page
Could not enable filters on UX page. Created Planning period Filter and apply filter on column is disabled. Any help on this
-
Workflow Template Groupings
It would be great if workflow templates can be grouped by admin, so I can filter on workflows that are related to the overall high-level process.
-
Ability to Export Role Access by Page
For access reviews, it would very helpful to have the ability to export a view like below for all roles. The below screenshot shows page access for one particular role. For models with many pages and roles, there is currently no easy way to show access summaries to business owners.
-
Anaplan XL Calculations
I am still now to the calculation of Anaplan XL, i would like to get the proportion in terms of value between child vs parent (within the hierarchy) For instance, i want to get the % of each 08S( child) vs the parent value (BL TS), i would like IN general a formula that give the proportion of child vs parent dynamically,…
-
Current page filters and sorts are applied to all pages of multi-page exports
This item has been identified as an outstanding known issue. Issue Setting a current page filter or sort and then exporting this data to file, will apply the current page filter/sort to all pages of the data. Workaround Remove all filters/sorts, export the data, and apply the filters/sorts in Excel --- Internal Reference:…
-
Enable Direct Integration Between DocuSign PowerForms and Anaplan
Currently, Anaplan supports integration with DocuSign templates to send documents via email and track signed responses back into the model. However, it would be highly valuable to extend this capability to DocuSign PowerForms as well. The proposed enhancement would allow administrators to publish a PowerForm link directly…
-
Create export template for Anaplan users to import using months
Author: Tyler Beck is a Certified Master Anaplanner at TBLB LLC, and is currently a Team Lead at CVS Health. Use case An end user needs to export a template from Anaplan using Months as the time period in columns, and qualitative data in rows. When the template is exported as a CSV file the years in the dates turn to days…
-
Export Action Notes
Export Action Notes 1. Purpose of the Export Action What it does: Describe why this export action exists. For example: "This export action allows users to extract specific data from the Anaplan model into an external file for further analysis or reporting purposes." Who uses it: Identify the intended audience. Example:…
-
Result from ISNOTBLANK() is not aligned to LENGTH()
Hi Anaplanners, I have encountered this super weird situation where I am using ISNOTBLANK() formula to identify if there's any characters in my Parent Reporting Sub-Segment (PRSS) column, but some rows (see ss below) is showing ISNOTBLANK() = TRUE even when there's no inputs. When I tried to troubleshoot this with LENGTH()…
-
Set Default & Page-Level Toggles for Card Comments/Maximize
Hi all, Just discovered we can turn off comments and maximize on cards other than text. As I was using it, an idea came to mind. Since I'm usually turning comments and maximize off for cards like images and text, it would be a huge time-saver if they were off by default. Another idea could be a "apply to all cards" button…
-
How I Built It: Replacing list items
Author: Chris Allen is a Certified Master Anaplanner and Manager at Allitix Part of Accenture. Hello, and thank you for checking out my ‘How I Built It’ video tutorial on replacing list items! The video will walk you through the process of replacing list items. The key feature leveraged here is importing a new code into a…
-
Anaplan XL Enhancements
There are few things which I thought would make sense with respect to user using Anaplan XL: Creating Anaplan Connection: Currently creating Anaplan Connection gets active the moment we select module from a model, but still we can build reports from Any module of that Model. So its ideal to have ability to create…
-
Can't move on past first Lesson.
I am currently taking the Anaplan course, I completed the first lesson but whenever I try to move on to the next one it won't let me. When I try to move on it tells me that the prerequisites weren't met but I've already went through the whole first lesson in full, if there's something I'm missing please let me know.
-
Anaplan Excel Add-In | Connect to New Model
Hi - I recently created a new Anaplan model that serves as a 'reporting' model for some past versions. We have Excel workbooks that retrieve data from ~20 modules that I would like to connect to the new model. The new model is identical to the old model just with different versions (fake version list). is there a way to…
-
Show Line Item Format in New Model Building Experience
The new model building experience is far better than the classic and needing to click into every module if syntax is unknown. A big incremental enhancement would be to add some sort of icon or naming to show you the Line Item type. Adding this naming would allow the builder to better understand what they are referencing…
-
A reminder of Bulk Copy - Current year to Prior year version for YoY analysis
A quick reminder of the Bulk Copy functionality. Bulk Copy allows you copy large volumes of data from one slice of a model to another in a single, optimised operation, instead of using formulas or imports. Use case: copy a version (RF1) into a prior year version (PY RF1) using a versions list to allow for year-on-year…
-
Actions Editing - Not Syncing to Prod
I have a Dev and Prod environment. I have an action where I am importing data from another workspace. I am needing to map some new line items in the action so that it pulls correctly. I am updating the mapping in the Dev environment, but after I sync to Prod those changes are not flowing through. So they show updated in…
-
Native Time Formats with Hours and Minutes
Problem Statement: There is a business need to allow users to filter and analyze data based on specific times (e.g., 14:30). The current 'Date' format in Anaplan does not provide this level of granularity. This functionality is essential for time-sensitive planning and analysis use cases where differentiating between…
-
Auto-update on UX Cards when Template is Updated
The core idea is to have UX Cards automatically update when the Card UX has changed: new line items into a grid or Field Card, conditional formatting rules change, etc when the same card is displayed multiple times. Example: User Filter Cards I have the same User Filter card on 90% of my Pages - let's call it 16 Pages. I…
-
AnaplanXL & VBA Macros
Hello, I have two questions related to building a VBA macro that uses AnaplanXL. Above is a picture of what I'm building toward, a data grid with several header rows. The color-coded headers are our list dimensions in Anaplan. In this example the yellow cell's value should be the intersection of Dept_1, Line_Item_1,…
-
400 error when using From Action
hi, I'm receiving this error when trying to create item in numbered list item. My list has a display name property (used only to display name, never in modules) In form Action I ask user to give display name and other informations about the item (informations are line items in associated modules). It seems that when I ask…
-
Change the model source for all pages in an application in one go
Hello every year I use to copy a PROD model of a given period (Bud 2026 for example) and keep it open but "Locked" for users, in order for them to still be able to access it if they want to remind what has been done during the previous process. All the pages in the app are sourced on this model (the PROD one not the copy),…
-
How I Built It: User Access Management
Author: Kevin Dale Bandelaria is a Certified Master Anaplanner and Solutions Delivery Head at OmniQuest, Inc. Solution overview The User Management process in Anaplan was developed to simplify how administrators set up and maintain model roles and selective access settings for users. Traditionally, configuring access in…
-
SSO Admin Screen - Remove the ‘Load from XML file’ option given that its not reliable
We have had issues updating our SSO cert and have been advised by support not to use the above option. Given that it is not reliable, it would be better to have it removed so that users are forced to use the manual option which works consistently.
-
CERTIFICATION BADGES - ANNOUNCEMENT
Anaplan Champions! The Community team just posted this announcement that certification badges may not be showing up on your profile probably until next year. Rest assured, you will get credit once you complete and pass the exams. https://community.anaplan.com/t5/Blog/Badges-Back-Soon/ba-p/123385
-
Workarounds for coercing timescales in Polaris?
Hi, all. Polaris formulas don't coerce timescales like classic does and I'm looking for a workaround. I want to build a UX time selector like I have in my classic models: The way it works in classic is like this: The "Filter" line item looks at the month formatted, quarter formatted, and year formatted boolean line items…