Modeling

How to maintain same order of "Reselect Items to Show" between multiple environment
Hi Expert, Please provide me with some advice and help my model building. The situation is.... 1. In Development environment, Production Data List (Custom Week, such as 2021 W01) as dimension is selected and rearranged by "Reselect Items to Show" on a dashboard. 2. This setting is imported to Production environment via…
Circular References - OFFSET
Hi, I want to create something like the below example, but Anaplan returns circular references. Could you please give me an idea? Example In the above example, I input below formulas Last month stock = PREVIOUS(Stock) Consumption = get from different module Planned Received Amount = OFFSET(Recommended Order Quantity, -1,…
Level 1 MB Lookup function issue
Dear, I am trying to apply a lookup formula to retrieve data but I always get an error message that is not mentioning what is the error. I think my data should be ok, as well as the formula I entered but still I get error messages. I attached the input of my formula and the error message i get. Many thanks in advance! kr,…
Search Functionality in 'Manage Models' Window
With mature Anaplan workspaces, there are typically dozens of models that would have been created during Foundations, development or for sandbox uses. As the list of models grows, it becomes hard to scroll through the list to find a specific model. This difficulty is especially evident in partners' workspaces, where there…
Extend the number of future years
For the purpose of calculating lease contracts in IFRS 16 it's sometimes needed to have wide time ranges in the model. Currently, the amount of future years is limited up to 50 years and past years up to 20 years (link). This means you have a maximum time range of 70 years. We experience that some lease contracts extend 70…
Anaplan Model Builder Line Item Diagram View
As a model builder, it would be great to have a "diagram view" available when reviewing code/line items. This concept originates from an actuarial modeling software called "Prophet". Basically a model builder would be able to enable/disable diagram view. If enabled, a precedent/dependent tree would appear at the top of the…
Creating Imports: Search for Saved View, Module, or List
When creating import actions that connect to lists, modules, or saved views within Anaplan models, it would be useful to have a “Search” button to assist in locating the list/module/saved view the model builder needs to select. This search feature is incorporated into other parts of Anaplan and, should it be added to the…
Old idea that needs attention: Tag a version as completely Locked
Possibility to tag a version as fixed, so changes in parameters and formulas do not impact the data anymore. This is really important for improving the reliability of the data for customers that want to be able to calculate multiple versions at the same time. If a formula change is needed in that case old versions also…
Function that returns a user's role
There are times I would like to show or hide data, allow access, etc. based on the user's role. For example, some data is sensitive, and I would like to use Dynamic Cell Access to allow someone with the user role "Admin" to read/write the sensitive information, while someone without the Admin role would see nothing.…
Recognise zeroes and blanks as different data inputs when using number formatting
Can we add a number formatting option (text fomatting causes issues for our users) with a default for the cell of blank (if blank then the cell is ignored) and then if a zero is input it is treated as a number. For example - the default calculation for sales volume generates 50 for January 2018, there is an "override" line…
Ability to view a column in module blueprint showing "Used in Filter", similar to "referenced by"
Similar to how a column for "referenced by" can show me other modules where a line item is used, and "used in dashboard" can show me where it's on dashboards, as a modelbuilder it would be helpfult to have a way to tell where a line item is being used to drive a filter.
View a module's blueprint view side-by-side with its data view
I would like to be able to see the changes I make while in blueprint view of a module affecting its data view in real-time. Currently when I change something in blueprint (ie. a summary method) and have to toggle back and forth to see its affect. Unfortunately, depending on how far down in the list of line items the one…
Need a way troubleshoot a formula by stepping through it piece-by-piece
Much like most coding languages or even excel's formulas, to aid in writing complex code / formulas, there needs to be some way for a developer / builder to see how the individual components of it resolve one by one. I'd like a way to step through a formula to see where it's going wrong, and see values of the components so…
Allow Admin to globally disable "Open Source Module" option based on user role
I would like to be able to set access to the "Open Source Module" option for users based on their role across a model. With this feature in place I could disable "open source module" for non-admin roles, while allowing those with 'Full Access' to open the source module as normal. Win-win. WHY: There are groups of users…
Allow the Create action to work with a numbered list that has no parent hierarchy
The Create action only works with numbered lists that have a parent hierarchy. My numbered list does not have or need a parent hierarchy so to satisfy this rule I have to create a dummy list (e.g. a List called All with a single member called All) and made that the Parent of my numbered list. (I also checked whether I…
Add formula drill down in NUX
Suggest to add formula drill down to NUX. When working with the NUX, there is no formula drill down option. This is a key feature for our users as they need to see how the numbers are being calculated when doing root cause analysis. At the same time, the specific values going into the formula should be shown as they are…
Picking up opening balance
Hi there I have two modules. Module A has by week time scale and module B has by month time scale. If module B want to pick up opening balance from module A, what formula should I use? PS, has set up the "The first week?" logic but don't know how to pick up the value from module A. Thank you.
List items maximun
What is the maximum list items, can I add in a list?
Value is not getting exported
Hi Friends, I am trying to export but only Time and Lists are getting exported. And no Line Items and their values. Please tell me, when it happens and what do I need to do?
Summary setting for module dimensionalized by years and fake months list
Hello, I have a module dimensionalized by years and a "fake" month list (and other dimensions) so I can see line items month to month, year over year. I'm pulling the data from another reporting module that's dimensionalized by time (month) so I'm using a line item to map months to years and using that as a lookup. This…
Ability to enter decimals without leading zeros via new UX forms
When we are using the forms in the new UX to create list items, the form with a number formatted line item is not letting the user enter decimal numbers without leading zeros ".05". When entering the number directly into the cell, it accepts it but when using the form, it gives an error saying it is not a valid number.…
How to hide summary item in dropdown list?
Hi Experts, I'd like to ask how to hide the category summary in lists. The screenshot is what I'm developing now. In this module, client set parent and child product for set selling. In this dropdown list, is it possible to hide parent category here?
Formula for Summary
I have a case, i want Monthly Amortization Line item can show Quater amount. but not show because on Summary have Sum,Time:Formula. Can give me a answer. Thank you. Help me
Level-2 Certificate
I have completed the conclusion exam of Level-2 and uploaded the model history also. Past 24
Active Child list members under a parent
Hi - Say I have a hierarchy with two levels: L1 and L2, L1 being the parent. Not all L2 members are at a point of time active under L1. So, we have a module that specifies which L2 member is active in a month (identified by a boolean). For disaggregating the data from L2 to L1, I need to ensure the volume is disaggregated…
Find formula
Hi Friends, Do we have any special formulas for the below calculation.
False Boolean Action
Hi Team, I have a Override Boolean line item in 1 of my Selective Access modules that I would like to create an Action for to set all the items to FALSE. This would be done when the Selective Access admin tasks are being executed and we wish to start with a clean slate I know that I can go into the module, set the Formula…
Filtering line items or lists by another list
I have a module of multiple different input line items, but those inputs vary by the elements in a list. For example the North region (list item) has 2 of the 5 inputs, and the south region may have all of the inputs. I want to be able to use a filter to only show those applicable input line items for its respective list…
Level 1 Model Building
Hi Team, On the 'Introduction to User Experience' slide, I am not seeing the 'Next' button getting enabled even after selecting 4 differences for 'Model Builder' and 'End User' views. And hence not able to progress in the course. Has anyone faced this issue? Thank you Gaurav
Formula help requested
Hi Friends, I am struck with a query. Need your assistance to proceed forward.

Modeling

Discussion List