Modeling

Level 1 Model Building Exam - Activity 6
I am trying to calculate the phone costs for a department in December 2020 and medical costs for a department in December 2020. The formulas I am using in REP04 are producing numbers, but they are incorrect. Here is REP04: It draws from SYS08: I keep getting the wrong number whether I use EMP02 or EMP03 in the formula.…
Supplied by line item SYS08
Hello, in Level 2 print 3, for the country summary report there is a reference to a line item Supplied by which is supposed to be in Sys08. Maybe did I missed something in my previous sprints but it was not part of SKU upload file and if it is suppoed to be a formula I don't know how to build it (where should the data come…
Calculating line item based on diffferent values in the list
Hi Anaplanners, I have a module dimensioned with 2 lists, loc1 and sample. Sample has two line items Sample 1 and Sample 2. There is a line item called Transportation. I want to add another line item called Transportation Sample1 vs Transportation Sample2 which should be Transportation for Sample 1 - Transportation for…
Turn off suggested list/line item names in new modeling experiance
Is there any way to turn off this feature? I often just want add a simple correction to a formula, hit enter and move on. Instead of just the minor edit when I hit enter to close the formula editing it grabs the first suggested line item or list name. For example I just need to add an apostrophe and want be able to just…
How to Find Combination of List
I want to Find combination of List. I have relationship of Customer-Product and Product-Supplier. Then I want to find combination of Customer-Supplier. Now I don't want to make Lineitem which has "Customer*Product*Supplier" as Applies To because of memories. What kind of formula should I set?
Option to display code not name
As a model builder, I would like the option to choose whether a list formatted line item displays the code or the name of the list item. Depending on the purpose of the module, the audience and the number of columns being displayed it is sometimes more appropriate to allow a user to view and select the code of a list…
Formula Help (Condition Statement)
Hi, I need help on creating a condition where if one LI is lesser than another LI, then my intra-month growth amount must be less than my write off amount. Not sure how I can make this condition happen in Anaplan. Please advise. Thank you
Export - Data Source
Hi Community, I am thinking that would be very beneficial for model builders to have the possibility to view Data Sources for Export Definitions. For the large models with lots of external integrations and different export actions is pretty difficult to follow the source of a particular export if you can have dozens of…
Applications of Newly introduced process/action timestamp .?
Hi Anaplanners, Anaplan is has recently introduced start date and time update w.r.t each process/actions run which has been very helpful. Is there a way through which this timestamp can be published on DB or used in model building..? Thanks in Advance. ~ABhi
NMX rollout - 20th Feb 2023!
After a change to the initial NMX rollout date - keep your eyes peeled for it becoming the Anaplan default this month! Here in UKI the date that this will become default is slated for 20th Feb - check out this article and video for answers to FAQs and some insight into what NMX has to offer.
Hierarchy Filters
Hi, I have a requirement where in if user selects a Boolean(Show Ending Balances) then it should show only ending balances (which is a top level for L1 description types of list) along with Ending Balance line item. Currently I have built the logic but when I apply the summary as formulas it throws an error. But previously…
Make Versions a Production List
Enabling Versions as a production list would allow business users (not developers) to add flexibility and enable business users better management of versions. Consider the scenario where there is a variable amount of Forecasts that could happen in a year, or if a Forecast becomes current/next.
A+ for Anaplan (Model Builder Edition)
A+ for Anaplan (Model Builder Edition) is an add-on for Chrome that has quite a few nice features: Link Unfortunately due to the sensitivity of the data that I and other companies/users work with, I am unable to utilize this add-on due to the required permissions. I would love to see these features brought in-house, if…
Dark theme/Night mode
As an Anaplan user/model builder, I find the white can be a little too much some times and not too easy on the eyes. It would be great is there was a night mode or dark theme that swapped the colour palette for something not as bright. This may also help with accessibility Thanks!
Production Lists and Ragged Hierarchies Logic
Assume the following Non-Composite list, ragged hierarchy, needs to be set to Production Data. We need to refer to the ultimate parent to define the logic calculation. In the example, we have assumed that children of Parent 1 and Parent 3 need to return the 'logic 1' value from the constants module below, and those under…
Community perspective: Smart Data Storage
We’ve all been faced with that question: to version or not to version. The requirements you face, together with your previous experience, will be taken into consideration to make that decision for each new model. But whatever route you decide to take, I think we can all agree that versions shouldn’t be used as storage.…
Copy/Paste & Copy Across/Down in NUX
Hey All, One of our cards in the NUX will now allow copy/paste or copy across/down. The model is deployed, and that particular line item has a dependent list format. The odd part is this works find in the dev version both with and without dependency in the list format. My only guess is that it's a numbered list, and we're…
Page Selectors Best Practices?
Hi, Is there some common techniques when publishing page selectors to a page verses publishing to a module?
Anaplan script is failing while executing remotely
Hi, I am trying to execute Anaplan script remotely but its failing with below error. Absolute path to JAVA 8 executable not provided. Will attempt to figure out path from JAVA_HOME or Windows registry... JAVA_HOME is not defined, will attempt to fetch value from registry... Checking Windows Registry for Java Version...…
Dynamic Sum based on Multi-Select in Context Selectors
This is an extension of already requested options to select multiple items in a UX context selector (for reference, see that Idea here and here). I wanted to call out the specific request that it be possible to have dynamic sum based user-selected context items. The point has been mentioned in these Ideas here above but…
Color Differentiate the "Write", "Read", "None" access levels for Roles--> Modules etc.
On larger models, the list of modules, dashboards, actions etc. can become very difficult to sift through. When setting user role access for these lists in Roles-->Modules, Roles-->Actions etc. it is difficult to notice issues because the whole list becomes just a sea of blue words, all of similar lengths. It would be…
Dependent dropdown
How Can I add filter by country and filter by segment in this: Accounts are dependent dropdown set up on country. Thanks -Pooja
Load monthly data into weekly time setting model
Dear Anaplanners I have a dump question whereby I cannot get it over yet. I have a model whose time setting is designed as weekly (for later stage replenishment planning) While the demand forecast is still by month, so I have an import module to load monthly history sales dimensioned as below: My source csv file looks like…
Level 3 - 4.6.4 Sales Planning Model: A2 List
4.6.4 Sales Planning Model: A2 List In the Sales Planning model: Import data from the Data Hub model to populate the A2 Account>Product# list * For each list item (Product name) include the Account (parent), combined Account_Product code, and display name from the Product Flat list I have completed this but not sure my…
Copy Model also copies Audit Log History
When you copy a model, it would be nice if the model's full history log was also copied instead of being reset in the new model. A couple times in the past year we have needed to copy and deploy production models from existing production models in order to handle high-risk updates being pushed from our development model.…
Filtering and UX
Hi all, Here is my situation: I got a module (REP_01G) to calculate Version Variance, this module has other dimensions such GL, Project, Currency, Company, and Time scale is Month. And a list of line items as shown below: Reports with Time and Line Items on column will be build. The row could be project, GL, or company,…
When do your integrations require workspace administrator privileges?
Generally, you don’t need to have Workspace Administrator (WSA) privileges to run integrations; however, there are still some specific instances when they are required. This guide will provide an overview of when your integration user requires WSA privileges. Anaplan user types involved in integrations First off, let us…
INV 02 country summary
Hi team i have an issue with the country summary module In country summary, stock safety flag i have given a formula but its not showung Sku list in the module, and if inv01 safety count flag should be ticked but what should be ticked? i got sutck here please find the attachments and help me in sloving this module
Input values based on a Boolean formatted Time Period
Hi Everyone, I'm fairly new to Anaplan and currently self studying so please bear with me if this question seem basic. Is there a way for me to use a boolean formatted line item to serve as a basis to what specific months I should put my computed values? The formula will go like this: IF first month of Month Picker…
13.3.1 Level 1 - Unable to create Margin Summary page
While creating Margin Summary page, I am getting error as "A page with this name already exists" and unable to create the page. Please help, thank you!! However, I am creating this page for the first time. (I am on 90 days Free trial)

Modeling

Discussion List