-
🚀 Stop Writing Nested IFs in Anaplan - Use LIS Instead
If you’ve built complex Anaplan models, you’ve probably written formulas like this: IF A THEN IF B THEN IF C THEN Value1 ELSE Value2 ELSE Value3 ELSE Value4 It works. But it’s slow. It’s hard to debug. And six months later… even you won’t understand it. Let’s talk about why nested IFs hurt performance and how Line Item…
-
Trying to use a formula to choose a value to use in a calc
I am trying to choose between 2 values to use based on a value in another module and lookup to a Cohort from a month value. So, either the Extrapolated Blank Tariff CoS if the Cohort has Flash ticked in Month End Attributes, or Blank Tariff CoS if the Cohort does not have Flash ticked in Month End Attributes. This formula…
-
ADO connection problem with “Google Cloud Storage”
I’m having a problem connecting to “Google Cloud Storage” with Anaplan Data Orchestrator. The GSP Service Account Email is correct and the GCP Private Key is correct, but it will not accept the bucket name. Please provide some guidance. Thanks.
-
Ability to Select Isolated Cells in Quick Sum Bar
When using the quick sum bar functionality (https://help.anaplan.com/anapedia/Content/Modeling/Navigate%20Anaplan/Quick%20Sum%20Bar.html?_ga=2.86794650.366156822.1550101511-1666663741.1546456255), you are currently only able to select "blocks" of cells (a series of cells in adjacent rows/columns). It would be useful to…
-
Management Reports - Automating PDFs
Hi, we need to bulk export approximately 150 customer Management Reports as PDFs each month from Anaplan. It involves selecting each customer from the context selector, exporting to pdf and then renaming the file. Currently this is a manual process. Has anyone implemented an automated solution to bulk export Management…
-
How to calculate the weight?...
Hi all I have a list of networks organized hierarchically on a list of entities, which is itself organized hierarchically on a list of divisions (organization). An entity can have several networks. I also have a list of product models, which is itself ranked with three higher levels: this “Models” L4 list is ranked at a…
-
Can Anaplan ADO (Source Data step)append all similar files in a folder and auto-include new ones?
There is a client requirement to load multiple structurally similar files (the system generates new files) from the source data. Is it possible for the ADO "source Data " step to read multiple files from a folder path (instead of a single CSV file), append all these files, and then pass the combined data to the ADO an then…
-
【2026年1月】プラットフォームアップデート
New UX機能のアップデート ・階層チャートのページネーション Optimizer ・Optimizerの全般的な機能強化 Forecaster ・Forecasterのフォーキャスト書き込み先の変更機能 Anaplan XL (バージョン2601) ・グリッド内のネイティブ Excel 式 ・ワークブック スライサーの遅延リフレッシュ ・利用可能なコネクターのきめ細かいコントロール Anaplan Data Orchestrator ・Data Orchestrator のデータスペース…
-
RTO and RPO details required
For auditing purpose I need RTO and RPO details. Could you please share the details and also along with the source URL.
-
XL3SetProperty to navigate
XL3SetProperty to navigate
-
undefined_onFileChange
I get the undefined_onFileChange error on uploads. I get the error on every item I try to upload(Lists, Modules) I have tried the following: Refreshed Browser Cleared Caches Changed browsers Restarted machine Redefining the file Recreating the file Changing the file type I probably tried some other things also. Anything…
-
AXL Slicer Enhancement Request: Save Preferences with Multi-Select
Current behavior: When the Multi-Select Members option is enabled in the slicer settings, the user’s previous selections are not saved when reopening the workbook. As a result, users must reselect the slicer members each time they open the workbook. However, when the Multi-Select Members option is disabled, the previously…
-
Formula not resulting in the correct value
I have the following line item and formula, but it appears to not result in the correct value, the correct value according to the formula and the excel version of this is: 302,590 and not 315 as in Anaplan. All of the correct values are pulling through into the calculation so this is probably a syntax error that I cannot…
-
Anaplan XL - Member Properties
Hi, Where are the member properties for lists defined in Anaplan XL? In the training documentation there is an example showing a property such as “Birth Date”, which appears to be a list-item attribute. That suggests you can create custom list properties from the Anaplan list. However, when I connect through Anaplan XL, I…
-
I have created this formula to pull in stock exception count dimensioned by country and Prod Family
is this right ?
-
How to quickly duplicate documents and roll forward data in Disclosure Management
Author: Veronica Pietrobon is a Product Manager at Anaplan. Need to kickstart a new report based on an existing one? Our Copy feature on the home page makes duplicating your Disclosure Management documents incredibly simple and efficient. When you copy a document, it intelligently replicates everything — the complete…
-
Clay before carbon fibre, flat files before data full blown orchestration
Author: Alejandro Gomez Sanchez, Certified Master Anaplanner, and Principal Consultant. Data orchestration is a remarkable capability. When done well, it is genuinely transformative: comprehensive, accurate and dependable data for decision-making is available instantly. Beyond the satisfaction of well-orchestrated data, my…
-
How I Built It: Chess in Anaplan
Author: Waleed Hakim is a Sr. Anaplan consultant. Hi everyone! I’m Waleed — a Senior Consultant working with enterprise clients to transform their planning processes through Anaplan. I've been in the Anaplan ecosystem for just under four years now, and while most of my time is spent solving complex business problems, I’ve…
-
Anaplan XL Reporting : with FCR
Hello, At present, the parent (subtotal) is always displayed above its detailed elements when drilling. This behavior cannot be modified through grid options, drill settings, or workbook configurations, and there are no hidden parameters or prerequisites to enable a layout where the subtotal appears after the details. The…
-
Mapping Cohorts in the format YYYYMM to Time value Month
I have a module that has 4 line items, 2 of which work on Month which results in the correct values, however 2 work on something called Cohort - so for example 202204 is Apr 22. See module below, the top 2 result in blanks/zeros and the bottom 2 result in correct values. So I want somehow to map the Cohorts to the time…
-
Solution for indent diabled for hierarchical list when the page has more than two axis
Hello fellow Anaplaners, I have a question about the UX for Anaplan for hierarchical list. If I have a list with multiple layers, say P1, P2, P3, and P4, and the workpage had 2 axis, list and line items, in its vertical axis and time in its horizontal axis (see figure below) The list is shown without indentations, and may…
-
I am struggling with my mapping and import of E2 Employee List
Hello Model Builders! I need your help in Model Building. I have tried over 10 times to import data into E2 Employees# under Lesson 4.8.2. I have spoken to some colleagues on my team and the we were unable to resolve this issue. If anyone could assist please share a solution or trick to this. I noticed other colleagues had…
-
Cracking the Mystery of Infeasible Models 🕵️♂️
You've spent days carefully crafting your model, eagerly awaiting that satisfying moment when the optimal solution appears, only to be met with the dreaded message: infeasible 😱 The excitement turns into a classic plot twist worthy of a detective novel. But don't worry! Here we have 3 practical tips to help you figure out…
-
I'm trying to bring a value in from another module but it results in a blank
Referencing in the Blank Tariff module below the Total Handset Revenue from the P&L module, however the value is not shown, instead I see a blank. Any ideas?
-
FCR:Questions about Workflow Process Log Specifications (Retention / Display Limits)
I would like to ask about the specifications for the Workflow Process Log. Background We have confirmed that the Process Log, which can be viewed via Explorer > Workflow > Process Log, is no longer visible after a certain period (approximately 3 months). However, we have received feedback from users that this retention…
-
Reorder line items functionality for end users
Ability for the front-end users to reorder the line items in a grid in worksheet view. Currently the functionality is availability for model builders only.
-
Need Set Global Default Format Grid function in New UX
My users want to make it possible to set Format Grid - Small for all grids in the New UX. This function exists in Classic UX to set all dashboards to Striped, Ruled, etc. We would like to have this opportunity to set all grids of one App in New UX to one style, e.g. Small which will improve screen space utilization.
-
Ability to apply Row and Column header configuration on all grids across a page
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: Currently, each individual grid on a UI/UX page needs to be edited as follows to change the Background color of the row headers and…
-
Corrupted Import Action
Hi, I'd like to know if my issue already occurred to anyone here. I created a saved view out of a module using different hierarchical lists. In the saved view, I pivoted the dimensions and restricted the view only on a specific line item. Then, I used that saved view to import data into another module however the data…
-
I'm trying to calculate a % value based on the CoS of tariffs
The calculation needs to work on the CoS values in the below, so trying to compute the Blank Tariff CoS value as a % of the Relevant Tariff CoS, so for example - 244,024/14,878,715 = 1.64%