-
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…
-
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…
-
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…
-
New UX Idea - Apply one more model source to all pages of the app at once
One of our model a dev and multiple prod models linked to a single dev via ALM. We have developed New UX App based on dev with a lot of pages in it. My aim now is to apply all prod models we have to this app, but the existing procedure is not effective for this idea. I want to have ability to add new source to the excising…
-
Training & certification for non-model builder
Hi, I would like to ask the training and certification available for non-model builders. I would like to learn about Anaplan from user end trouble shoot purpose and guide on UAT, deployment and Dashboard creation but not directly involved in model building.
-
Update Anaplan IRR Function to calculate running IRR
We have a business requirement of calculating running IRR to calculate the performance fee. Currently, Anaplan IRR function gives 1 final output basis entire cashflow We need running IRR to start calculating the performance fee from the period if the IRR exceeds Hurdle rate This is a highest priority item and needs to get…