Modeling

How I Built It: Waterfall calculation
We come across the need for waterfall calculations more often than we think! I’ve personally created this at least four times in different contexts, and I’ve helped colleagues who were trying to achieve something where a waterfall calculation would work perfectly well. First, let’s clarify what I mean by “waterfall…
TAR01 Detailed Sales Target module
In the description from '5.2 Model Build Specifications', we need to calculate the proportion of a country's total sales revenue by product family each account's product sales contributed. The TAR01 was created already in the model, it's dimentioned "A2 Account>Product#' only. However the first line item is to calculate PY…
Confused about Lag, Lead, Post, Offset
I got confused between these functions. It's unclear for me now. If any one can help me with simplifying this it would be very helpful for me. Is there use cases where Lag and Lead should be used instead of offset or post? Thanks in advance.
Level 2 - Sprint 2 - 2.3.9.1 Import DAT03 Historic Volumes module
I referred the community thread to understand my doubt while running the process. I am not able to figure it out. Attached are the screenshots .
Rep Count from Start date to End date (if applicable)
Hi All, We currently have a "Positions" module that is not time based. We show our current salaries, job titles, etc. that comes from our payroll data here. This "Positions" module also contains the Employee Start Date & the Termination Date (if applicable). I have created a line item that counts the amount of "Job Titles…
IMPORTANT!! Please Read! 2022 Recertification for Model Builders and Solution Architects
Community Friends. Just a heads up. To get recertified as a model builder or solution architect for 2022 you must take this 10 question quiz on new Anaplan Features by 12/31/2021. Don't worry. It's open book and you can use Anapedia (highly recommended) https://learning.anaplan.com/course/view.php?id=1536 Good luck!…
Problem aggregating values from timscale day to month
Hi all, I have problems aggregating values from a module dimensioned with day, to a module dimensioned with month. I am doing rent calculations in a module by DAY time scale. When I try to aggregate this to a monthly calc module it does not work. No values are pulled over. It is the last part of the formula below that does…
Multiple lists
Scenario: I created a module with 2 lists. List 1 as Pages List 2 as Rows Line items as Column I want to show only few items in List 2 if specific item is selected in List 1. Ex: List 1: 1,2,3, - List 2, 1a,1b,2a,2b,3a,3b if List 1 selected as 2 List 2 only shows 2a and 2b Tried making List 1 as the parent of List 2, There…
Import Data Module and List at the same time
Hi everyone, I have this concern of my current model, since the user will be the one to add/upload the data. I need a friendly dashboard for them to upload the file to a Data Module. But what will happen if there are new data even amongst the lists inside of that uploaded file? So I made this small test, where I create 2…
Display Module size in Bytes in the Module table
When analysing model size, the cell count field in the module tab is very useful. However it does not tell the full story as different data types use different amounts of memory. For example a number will use ~8x as much as an integer. The current setup works well for smaller models, but can be particularly challenging…
DEM03 Demand Forecast Module
Hello.Can somebody please me with this error. In DEM03 Demand module i am unable to get a data for Year 21,till year 20 all looks good to me,but from week1 FY 21 Baseline,default Forecast,Intial Demand Forecast all values are 0.I i have attached the blueprint too so i can get a better picture where i am doing something…
Ability to show and freeze Top level element on Grid (top/bottom and left/right)
As a model builder I want to have the similar feature to the Freeze cells (columns and rows) in Excel especially I want to be able to freeze top level element of the list used in a published module so no matter how I scroll the table it stays on the top or bottom of it and be able to select how top level elements of the…
Level 1 Import settings for Modules and Lists?
Is there someplace that shows what you need to have in each section for importing to lists and modules so I can attempt it several times and then find where I am wrong by checking what is right? I feel I am wasting an inordinate amount of my learning time trying to figure out by brute force, checking for people who have…
Time Scheduling with Optimizer
A system that allows optimized scheduling of dates / times over a period would be very useful (for example a finite capacity scheduler in production scheduling, rather than a scheduling of a team for maintenance interventions, etc ...) to broaden the functional coverage a supply chain model.
SYS14 Create Account>Product, Line Item "Data?" can't refer SYS12 and SYS13
I've create on Data Hub the module SYS14 Create Account>Product and looks like: But I am blocked by Data?(Boolean) filter to determine if ANY data for product SKU under the product * If you are using the Level 2 Data Hub model: reference the SYS12 SKU Details and SYS13 Account SKU filter. * If you downloaded a new Data Hub…
Level 1 Model Building Exam -- Activity 5
I thought I was pulling the data correctly but I guess I was not. Can anyone tell me if there is a problem with my formulas? Or maybe I should make some adjustments to my SYS08 Employee Details Module? Any Help would be much appreciated. Thank You!
Level 1 model building exam question 4
Hi guys, I'm trying to change the format of item list: Role, from text to list and the below message came up. Do you know how can I fix it?
Date Stamping the last time a Process was ran
Hello, I am aware that Anaplan does not have a Date Stamp ability and I have solutioned that; however, I am not sure how to apply a date stamp to the last time I ran a Process from the dashboard (e.g. If I run an Import today it should be stamped as 09/30/2022, or the last time it ran successfully). To do this, I was…
ETL - Summary for hierarchy
Hello! I am trying to build an ETL that will upload into a client's ERP system. They have some nuanced requirements, and I'm struggling to build one of those into our module. In the image below, I need to have the parent values displayed for the highlighted columns: This module uses L2 for account numbers, and the parent…
Set default roles access to none
As a model builder and workspace admin, i need newly created modules, lists and actions not to be accessible to any role except the full access role. This is necessary to follow security guidelines and best practices of "least privilege" (you only have acces to what your eligible to). Currently the opposite is done in…
New to the Forum
Hi Community, I am new to this Forum. I started e-learning Model Building Journey last year and I am happy to be now Certified Model Builder (achieved last week). I am working as Project Owner Support and I am looking forward to increase my Anaplan knowledge and enhance my building skills.
Hello All. New to this forum, go easy on me...
Hi all. New here but not new to Anaplan. I've been here nearly 9 years. I'm joining this forum to help out and spread knowledge. Will help create some content and articles - any suggestions, what do you need here as model contributors? Let me know what you need and what you want to see... Post your questions, there are no…
Model change has been rejected to prevent the workspace exceeding its size limit
Hi - working through sprint two of level two The module uses the lists P3 SKU and Accounts, Timescale is Week and Time Range is Model Calendar. Total cells is 34,721,544. Error message: Model change has been rejected to prevent the workspace exceeding its size limit Current model size: 417135690 Rejected model size:…
Convert list item to time period
We make a weekly copy of the demand plan to be able to calculate bias and forecast accuracy with 2 weeks lag. In a list we created versions : The last Property "Reporting Week" is formatted as Time Period "Week" The data is copied in a module with this list and the product list on the lowest level as dimensions : How can I…
Expand column width in Actions-Imports (and Import Data sources) or make it adjustable
The idea is very simple. The columns' width in Actions tabs are very narrow this always requires to Copy and paste to excel every time i want to check something in it. Would be great if we could adjust or simply have the default width much wider. @GeorgeDuckettMaybe your wonderful tool could have it in future release?
Delete from List using Selection must work differently for the nested list
My Idea: For the backward compatibility, add a check box in "Delete from List using Selection" action. When it's TRUE (default is FALSE) - running the action will delete all elements (leaf and parents) which have TRUE in the selection line item. This won't affect already excisting processes, but will allow to have one…
Upgrade Model search to ignore apostrophes (' or ’)
As a model builder i want to be able to search quickly through the entities of my model. Frequently I have to examine formulas which most of the time have references from the other line items and modules which have special symbols in naming (i.e. a dot (.) in module named '8.15 Transport tariffs options (Month)') So if I…
Select page link arrow position or hide it (>)
Idea: As a page builder I'd like to be able to choose there to locate the arrow next to the page link or even disable it. Usage: Talking about linear workflow it's not always that you (as a user) want to go downstream of the workflow. And looking at some cards can be confusing especially to the ones who are new to the…
Open referencing modules and related lists
As a model builder I want to be able to open modules which are referenced by selected module as a blueprint action. This is how I think it could look like: Also I want to be able to open list elements used as dimensions oth the module. (we could not have it in classic US as we could not open multiple lists but now we can!)…
Auto sorting subsets list when choosing Applies to or Format
As a model builder I have to search through "the list of the lists" to select necessary dimension in Applies to or a list for line item format. Most of the lists are ordered the same way as we put them in General lists and Line item subsets tabs using "Reorder..." button. But apart from that we have Subset which can be…

Modeling

Discussion List