Model Builder

Time Problem ASAP
Hello everyone , I have an old model with a time scale of 2023 and 2024 and after that I wanted to add 2025 in the time , some models take in consideration the next year , others not ! Is there any of you who faced this issue before ? If yes can you provide me pleasewith the solution. For me : I doubt that the problem…
Copy a branch to another Parent.
I want to Copy a branch to another Parent. The hierarchy is 5 levels and i want to copy an item at level 3 and all its children to another item under level 2. All suggestions are appreciated!
Activity : Filtering and Displaying Hierarchical Data
I want to create an interactive anaplan module that allows user to select an item from a hierarchical list and dynamically display associated items from the next level in the hierarchy Lists : P1 Product Family ( LVL 1) P2 Products ( LVL 2) P3 Products SKU ( LVL 3) Requirement : When a level 1 item is selected , display…
Driver Line Item for Action Button
I have condition in card where user can input negative value. But when the value is negative, the button will disable to click. I have data Product as Context Selector, Time Period Month in Column, and Line Item to input Order Quantity Review in Row. User will input number of order quantity review, but when the value is…
Summary: SUM , Time Summary: Average ERROR
Hello, Is it possible to set two different summaries at a time? This is what I am currently trying to achieve in the following module, "Forecast - Cost per Layer" and "Actual/Forecast - Target Cost" line items: However, in both cases I get this error: Is there any workaround to this? Many thanks, Luca
"Screen Selector" and "Context Selector" is not auto setting for all user (need to set manually)
Hello guyss, I need your help. So now on my project, I want to use below condition: If user select [ALL], then all product will show on the grid. But now on my ANAPLAN, this [ALL] selector does not show ALL the product, but only show the [Bottom], like below: when I check, I found that setting between the "screen…
How to bring values in Length of Service line item?
Hi All, I am really struggling to bring values in the Length of Service line item. Since the module is not big I had first tried to manually select items from drop down for all Reps but I realized that it is not the best way. Can anybody please suggest something? Here are my model Normal View and Blueprint view
Cmd + K/Ctrl + K Hotkey to open model search
Most modern websites use Cmd+K/Ctrl+K to open spotlight with quick actions or search. Anaplan uses Cmd+Shift+F/Ctrl+Shift+F. I believe that in future this window will be more than just a search so it needs to move from "search" hotkey to "spotlight" hotkey. It will greatly improve model building workflow and increase…
Excluding Ticked Booleans
Within a list, is it possible to create a list subset based out of formula to exclude ticked booleans from other list subset of the same list?
Order list action not working.
For example, Module A has SKU list and line item POS which has certain data in it. Need to reorder the SKU list with respect to POS line item data in descending order (Highest to lowest). Used Order list action to sort the SKU list. The hierarchy of list goes by Organization > Model > SKU. Order list action. Module A…
Is it possible to prevent Copy / Paste into a line item with a dependent dropdown?
Recently during testing, we learned that despite the dependent dropdown setting, users are still able to copy / paste data into the line item as long as it is a member of the list. Is there a way to prevent users from doing this? Risk is that we are using the input as the basis for mapping and we do not want data to be…
Current Year (time scale: not applicable)
Hello, How can I get the information contained in "current year - list" (year dimensioned) and put it into "current year"(non-year dimensioned)? Thanks in advance, Luca
FIRSTNONBLANK not working
Hello, I am trying to use FIRSTNONBLANK as a function to get the current scenario to match to the current year starting from module dimensioned as month. SOURCE MODULE TARGET MODULE As you can see it's not working, why is it? Thanks in advance, Luca
LOOKUP not working to change dimensionality of a line item
Hello, I am trying to change the dimensionality of the line item "layer yearly pt1" from: company, gr consolidation, scenario, year to: company, gr consolidation, scenario in line item layer yearly pt.2 My attempt was to lookup "layer yearly pt1" using a year to scenario mapping as in "WKK17 year to scenario mapping":…
Model will not populate certain cells
Hi all, Ran into an issue when I opened up a future year in my model. For some reason the the module in the picture below will not populate data for the new year (2025). I've racked my brain quite a bit but can't figure it out, any chance anyone here could help me through this problem? I'm sure it's a silly step I missed…
Text format validation
I would like validation functionality for text formats in Anaplan. When entering names of products or items in Anaplan and importing them into external systems, import errors occur if the input contains strings that the external system cannot import. Having text input validation functionality in Anaplan would facilitate…
Level 2 Spring 2 2.3.10 Baseline Forecast
I believe the problem has to do with my time range, but my 2nd year forecast isn't populating anything. This is my baseline Forecast formula: IF 'SYS01 Time Settings By Week'.'1st Forecast Year?' THEN OFFSET('DAT03 Historic Volumes'.Volumes, -52, 0) ELSE OFFSET(Baseline Forecast, -52, 0) The time range is fy19-fy20 to…
Module with no dimensions
Is it possible to build a module with no dimensions that will allow us to import a file with thousands of rows? The current file we receive does not have a unique code. We would like to import this file into an ANAPLAN module and then create a unique code using the data in the line items so that we could then create a…
Could you tell me how to check the number of Model Builders in a Tenant?
Our organization has not been tallying the number of Model Builders until now. However, we have received a requirement from a client asking for the number of Model Builders to enhance trust for obtaining projects. Could you please let us know if there is a way to check how many Model Builders are registered among the users…
Sales rep monthly Commission not matching with Anaplan 'Check Your Build' numbers?
Hi All Community Members, Despite putting a lot of thought and efforts, I am not able to figure out where am I going wrong. I have set all the Modules and formulae in place but still the numbers for the sales rep monthly commission is not matching with the Check Your Build numbers. Please find below details of my modules I…
Datatype mapping used for aggregation doesn't match any dimension of the source?
I am trying to pulling billings from a calc modules, the source and target modules are both dimensioned by country but I keep getting this error. Note: I am trying to pull in billings from CALC02 which is sourced from CALC01. CALC01 is pulling from a flat data module. Please advise…
Custom waterfall methodology
Author: Anya Skvortsova is a Certified Master Anaplanner and CoE Lead at Asana. Purpose: There is more than one way to tackle the waterfall calculations. I’d like to share one custom variety that proved to be especially handy for use cases of new asset depreciation and revenue recognition. Customers seems to like the…
Consolidating recursive modules
Hi I have 2 Lists and 3 modules as shown below. I want to build module 4 (details below) in the most efficient manner. Seeking ideas. Thanks in advance List: Employee ssL0Employee ssL1Employee ssL2Employee ssL3Employee Employee 1 Y Employee 2 Y Employee 3 Y Employee 4 Y Employee 5 Y Employee 6 Y Employee 7 Y Employee 8 Y…
Consistent Conditional Formatting Between Model Views and NUX Design
A view pre-built in the model with Conditional Formatting which is then published will not have the same look/feel compared to a card built manually in the NUX. As far as I am aware you are unable to edit the conditional formatting in a pre-built view in the NUX. I'd like the ability to have the same controls over a views'…
I cannot start Level2 spint2 learning
I completed the test with a 90% response rate. But I can't take the next step. What action do I need?
PSA: Deleted Models are no longer inaccessible to Workspace Admins
Anaplan introduced a new feature that allows for models that have been deleted to be restored by any workspace admin. This is wonderful for customers and partners to self serve when a model is deleted accidentally or needs to be restored and the hassle of going through Anaplan support/your BP makes it challenging or not…
Importing older classic dashboards into Anaplan apps
Question When one imports a dashboard, is the original dashboard in classic lost, or is it still available after the import? My preference is to have both and then, after tweaking, I can manually delete the older dashboard. Thank you
'Manage models' - ability to sort by Name / Date Created / Size
After each planning cycle or major model change, we make a backup of our models. This of course has led to a number of archived models which usually save in order of date created at the bottom. Please can we add the ability to sort by Name or Date Created or Size. This would really help in looking for a particular model we…
Time text format?
Hello everyone, I hope you are all doing well. I am writing today to inquire about the best formula to transform text from the format DD/MM/YYYY to DDMMYYYY. For example: 02/04/2024 should be transformed to 02042024. Thank you!
Introducing Improved Anaplan DX: a browser extension for Anaplan Modelers
We at valantic are excited to share our latest development: Improved Anaplan DX, a browser extension designed to enhance your modeling experience and increase efficiency. Please see below for more details. The extension is now available in the Chrome Web Store (can be installed on Chrome and Edge): For any feedback,…

Model Builder

Discussion List