Modeling

Pro tips on troubleshooting large Anaplan formulas
Author: Andrew Barnett is a Certified Master Anaplanner and Director at Allitix. The Planual serves as our guide for building things the right way in Anaplan. But let's face it, the real world can sometimes be a bit messier. Anaplan environments often consist of a series of models shaped over time by different people with…
Level 2: Model Builder - 3.3.5.2 Inventory Ordering Module Formulas
Hi everyone, I am not getting the results as expected. Does anyone of you know where my mistake is? for the first Row "Beginning Inventory" I am only getting values for Week 1. For row "Shipping Time Weeks" I am getting 0 as the result. But expected is the value 4 (for Week 1). Here are my formulas: Thank you. KR Tobi
Is there a way to reset the List Ids to reorder it correctly?
Hello everyone, I am building a date range filter to allow a use to select weeks and then have it filter to the days belonging to each week. I did this by having a report days being a child of Report weeks and using an Time calc to set up the range. It is working like I want by showing the correct list items. But they are…
February 23rd Model Builder Forum Follow Up
Hi everybody, Following the Model builder forum on Friday February 23rd, I wanted to provide a build along example that is more specific to higher education. I have put together an example of position planning as it relates to budget development and split funded positions and recorded a video walking through it (here is…
Time Filters and Time Context Selectors
Hi, My page has a time context selector to filter a report and the user can select half years or full years if they want a full year total. I also have a table of supporting editable data that the user wants to filter by half. It is frustrating for them as they need to select the time from the context selector and then the…
Summing a line item with a formula summary method
Hi I have a module that is calculating correctly for each line item when I apply the Formula summary method as its based on the dimensions listed in the context selectors. I need to return the sum of this line item (highlighted in yellow) in another module but it obviously returns zero. I am sure I am missing something…
How do I import only 1 occurrence without errors?
I have a DATA module with a line item named "Scenarios." I need to import this line item into a list also named Scenarios list. The data module is dimensionalized by a different list so I cannot use the isfirstoccurence() formula. What's the best practice when it comes to importing this line item into a list as to not have…
Show calculation time directly in model
Would be very beneficial for the model builder to see the calculation time (e.g. from model open) of the individual line items with formulas. The current cell count is a great help when it comes to optimizing the model and identifying how to reduce the size hereof. However, the calculation time of the different line items…
How to get Range of Values between two Booleans that are time formatted?
When the user select Two Boolean Check the range is defined so I want to get the range of values respective months.
Anaplan Time Range Limitation
I was very surprised recently when I discovered a limitation to Anaplan's permitted time range. It may surprise others to know that Anaplan is limited to supporting only 70 Years (20 past and 50 future) and the maximum number of years possible is 90 (using a time range set, as of writing, to 1981 with 90 periods). I did…
Dashboard to show occupied space by building blocks
Anaplan must have an option to show actual occupied space in MBs by objects e.g. line-items (rolled up by modules), list items, versions etc. This is area which needs extra calcs OR sometimes builders (including SA) struggle to find the reason of actual model size.. A leap in this direction will help the builder community…
Top 25 Anaplan features released in 2023
Author: Misbah Ansari is a Certified Master Anaplanner, Anaplan Community Boss, and CEO/Founder at Miz Logix. Within this fast-pacing world it is important for technologies to move even more faster. Anaplan — being a leader in the Connected Planning world — released a plethora of changes and/or updates in 2023 to almost…
Drive dimension selectors from undimensioned module
Hi, Is there a way to drive dimension selectors from a module that has no dimensionality? I have 2 modules: Select Dimensions no dimensionality, just line items that are formatted by dimensions entity and department, etc Income Statement dimensioned by entity and department. End-users would like to make entity and dept…
SOS : A modeling question
Hello Everybody , I have two lists in Anaplan , let's name them countries with all the countries in it and a second list called products with all the products that a company have. I want to give the possibilty for the user if he check a country , he will see only the products in his country. So my question how we can do…
Summary Calculations With the User List
Even though the Users list does not have a top member assigned to it, with the release on April 24, 2021, model builders will be able to use the following summary functions with the Users List: SUM, LOOKUP, ISFIRSTOCCURRENCE, CUMULATE, ALL, ANY, AVERAGE, FIRSTNONBLANK, LASTNONBLANK, MAX, MIN, RANK. Lookup First, let’s look…
How to reduce huge dimensions
Hello, I'm having a lot of issues with workspace size, with models going above 150/200gb in size and I'm not sure how to reduce it, to give some context, I have three main lists (size considering subtotals): Products (~1,5k) Countries (>100) Customers (>270) The issue is that if we apply all of them to a module what we get…
Clickable Image Links
We would like to put an image on the UX dashboard, which can be clicked on to navigate to a specific link. Is this possible to do?
Remove 10 million item limit from the ISFIRSTOCCURRENCE function
Brief description of the idea Remove 10 million item limit from the ISFIRSTOCCURRENCE function Expected benefit/impact Removing this limit would allow imports to be ran into large hierarchies that are referenced in ISFIRSTOCCURRENCE formula. Currently they fail with an error message.
Insert multiple Items to a list from UX
Old UX had capability to add multiple items to a list from any published module grid. This capability is missing in new UX. UX only provide option to use Form type action but only allows adding 1 list item at a time.
Allowing Documents (pdf, excel, word, ppt) attachments in Anaplan
It will be helpful if there is capability to attach Documents (pdf, excel, word, ppt) in Anaplan. Many planning decisions/inputs need supporting documents as attachments.
Mapping modules dimensioned differently
I want to be able to pull over my Snapshots from SYS: Snapshot Lookup into my time module via lookup using my Week Number and the Code since they are both text. My lookup module isnt dimensioned by time but it shouldn't have to be, what am I missing?
New Model Experience: Re-open last closed tab
Often when you are model building or analysing an issue, you close a tab (be it a dashboard or a module) and realise you should have kept it open. Often that then means having to go away and search for the object again. It would be really useful if like on internet browsers like Chrome, you had the option to re-open the…
Black Box Timesum Drilldown
One of the best things about anaplan is the ability to drill through the model to see where values come from. sadly, anaplan is now quite limited in how you aggregate over time. at some point changes were made that more else require you to use the timesum function to aggregate over time specifically (SUM: does not work).…
Global Find & Replace
I would like the ability to perform a model wide find and replace of a word. I should have the option to include text boxes, dashboard names, module names, line item names, action names, help text, tool tips, and literally ANYWHERE else in the model this word or string occurs. It should basically behave like Excel's find…
Adding specific number to imported data
What's the best possible way of adding '0's to imported data? Eg: Data > Required Data 156 > 00156 23 > 00023 62797 > 62797 0 > 00000
Failed to retrieve field list from the selected data source. Please check your import settings and
Hi I'm received this error and it took a while to work out what it was. In the "Source Models" it was pointing to the wrong environment, this is confusing because I could still see the "Saved Views" to click on, it would bail out straight after that with the error. The complete error is: "Failed to retrieve field list from…
Show the last date and time a process was run on a dashboard
We have a process to import live orders, and it takes a little time to import the data, it is used up to 7 staff members, and as they are working from home a great deal they sometimes all run the process one after each other, which can be draining on the system and my mood It can be run 40 times a day and only needs to be…
Eliminating Sparsity
Summary: Sparse cells within an Anaplan model are cells that do not contain and are not expected to contain data. The platform still needs to allocate memory space to these cells even though they are not used. The trick is being able to identify and combat these cells in existing models as well as preventing them when…
Designing models that scale
Author: Arun Thakar, Certified Master Anaplanner and Vice President in the banking industry. One of the aspects which determine whether a model will meet the need of the business is how well it can scale. Whether the constraint is balancing numerous concurrent users, or having dimensions with high indices, or both and…
Dependent Dropdown Issue
Hi, I have built a dependent dropdown but its not functioning properly. I have a hierarchy which follows the certain order: Entity>Segment>Product Below is my segment hierarchy Below are my line items which are list formatted When I am selecting the top level of Entity, my segment dropdown is showing entity list and on…

Modeling

Discussion List