Model Builder

Import values from previous period into current period
Hi, I am trying to build an import which should take the values from a month to the next one, in order to create a baseline the user would then modify as he pleases. Once he's done so, he should then import the new values into the next months. The import seems to work, however, it deletes the value from the previous month.…
Is it possible to check capacity for each Module?
So I want to change my module. But I want to know how much capacity before and after implement new changes. Current now I only knew that we only can see the capacity for a whole model. Please someone, could you tell me about this information? Thank you!! 😄 BR, Dian Suci
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,…
You Have Been Removed From the Talent Builder Program
Dear Rahul, Our records show you have not completed any courses in the last 30 days of the Talent Builder program. Your account has been removed from the program due to inactivity, and your access to an Anaplan workspace through this program has been revoked. Please, DO NOT CONTACT Anaplan support teams as they do not…
Line items
Hi Anaplan Team, Model builders could work more quickly and efficiently if we could display the list of filters and import actions. When we attempt to delete a line item, Anaplan shows the referenced line items, but it does not indicate which line items that specific line item is using in filters and import actions.
Replicate A+ for Anaplan Functionality in New UX
Hello, With the New UX, A+ for Anaplan Chrome extension no longer works. I am wondering if there is any current extension developed that can replicate any of the functionality of the former A+ for Anaplan Model Builder Edition Chrome Extension? Specifically, I am wondering if there is the ability for "Improved Colors" that…
NEW Community Q&A Challenge — join the discussion and collect a badge!
In the Anaplan Community, we believe that success stems from members connecting, sharing, and helping one another. As we witness members supporting each other daily in forum discussions, sharing ideas and best practices, and showcasing their expertise across various content, we are excited to introduce a new challenge that…
Line item with Month Format, need to repeat for all the period after it is calculated
Hello, I have a line item with Month Format (Maternities Month M_paid leaves calc) and need to repeat it until another line item with boolean format is true (Maternity). Tried with lastnonblank formula. Thank you for your help!
Dimensions that don't exist yet
I need to dimensionalize a report in Anaplan by Regions we currently don't use. They aren't in Anaplan at all. We have the accounts we need but the Regions in Anaplan are different that the Regions needed for this report. I know I can create the Regions but the only issue is that I do not have the data needed to input the…
Anaplan training resources and tips from a Certified Master Anaplanner
Author: Hem Maan is a Certified Master Anaplanner and Director at Bolt Consulting Group. Anaplan is a fantastic platform that not only allows businesses to achieve their objectives, but also the flexibility it offers also allows model builders to fully utilize creative problem-solving skills. It’s important to be on top of…
Assigning List item based on Text line items and looking up - COMPLEX
Hi Community, To give the backstory of this - I have a module, where I first import one data file into, with Loan-Hedge ID List) and line items as the dimensions. The second file I import is a similar one, also with Loan-Hedge ID (List) and line items as the dimensions. When importing the first file, these Loan-Hedge IDs…
Stock Projection (Stock + Input - target)
If anyone can help me with this: I need to perform a stock simulation by inputting values, as you can see in Mar 24, I do not have enough to reach the Best Estimate (what I need is 261 to reach). But if I input 1000 in Feb-24, I would have 146 + 1000 = 1146. I need to subtract the target for February, which is 261, from…
Prior Year Value: Page selector?
How can I view the actuals for a previous year, regardless of the current year? For example, if if July 2023 is selected, I want to see the full year 2022 actuals. Similarly, if July 2024 is selected, I want to see the full year actuals of 2023. My current logic is only working for 2022 actuals. Actuals = Amount [Lookup:…
Having more than three dimensions in the pivoting of modules
Hello, Is there a way to have more than three dimensions as rows or columns when pivoting a module? Maybe it is easier with an example, I have to create a report that requires 3 categories on top of the line items, but I am only able to add 2 categories, because the pivoting cannot exceed three dimensions in rows and…
can we have a multi select filter as a page selector in Anaplan?
similar to what we have in excel filtering…can we use page selectors to select multiple boolean formatted line items. Snapshot attached
Add a list item from a module
Hi all, I am struggling a bit to find a way to add a new list item from a module. So, I have this module in which I let the user insert the product, the product code and finally the customer group; the final result are three new list items I need to add to the relative list, that is ps01 product (which is a numbered list…
Community perspective: How to vary model inputs using optionality
Sandi Duffy is a Certified Master Anaplanner and Senior Finance Manager at Challenger Limited. With Anaplan, it is easy to run multiple scenarios within the same model by using optionality. A common use for this would be during the budget setting process. Say, for example, you have a budget model but would like to see what…
Add a button to a dashboard
I have dashboards built out for budget owners in the model layer not app layer of anaplan. I would like to add a button that essentially gives the budget owner the option to add an additional FTE to their headcount and plug in the respective salary of the new hire and see the financial effect of adding one additional…
Button on Dashboard not working
The picture above highlights the problem, every time i use the button Add Sub-GL/Vendor Item, the chart to the right should update with the name, GL account, for each department. I tried to add a new vendor expense under admin finance and legal called "anaplan", the gl account i choose was called software/subscriptions.…
How can we create action to load Existing items line item to Applicable Products line item.
This is the screenshot of the module containing both boolean line items.
Filter not working in UX
I added a time filter for this module expecting the card to populate in the UX. I only want FY23 and 24 as options for selection. It works on the model builder side but the card keeps populating FY22 in the UX despite me saving the view.
Level 2 Sprint 3 3.3.6
Hi, I'm having difficulties in the Shipping Cost and Final Shipping Cost line items. The formula I used for both: Shipping Cost: Final Shipment Amount / 1000 * 'TRA01 Shipping Metrics by Week'.'Cost per 1000 Units'[LOOKUP: 'SYS08 SKU Details'.Product, LOOKUP: Shipping Method] Final Shipping Cost:…
How I Built It: Integrations using CloudWorks
Author: Gokul Selvam Sadasivam, Certified Master Anaplanner and Senior Manager, Business Platforms at Okta. Hello Anaplanners! I’m excited to share a video that I created as part of the ‘How I Built It’ video series — diving into Integrations using CloudWorks. In the video, I give a live demonstration of how to use the…
What is Data Integration , any example scenario?
what is the difference of SUM ,LookUP, Select
What are the best Practices for model building , how can i list out. I am in training level.
Level 2 Sprint 3 3.3.5.2A Beginning Inventory, Forecast Demand, and Suggested Order Line Items
I am using this formula 'DEM03 Demand Forecast'.Final Forecast to pull final demand forecast value, but I am not getting any values.
Use formula to integrate data at multiple levels of list hierarchy
Hello, my model has a list hierarchy of "FND01 Fund" and "FND02 Series". FND01 has a top level of "All Investments." The model also contains three modules with data values at each level of the hierarchy - Total, Fund, and Series - and I want to integrate this data into a unified report as shown below: I need to write a…
Quickly duplicate cards on page without having to save them as template
Currently we only have a option to save card as template which is great. But there are many instances where I just need to duplicate a card/grid/etc and not need it saved as a template. Its cumbersome to have to either resetup the grid with specification or to create a template then use and delete it. Thanks!
Modeller's Forum EMEA dates 2023
Hi Please advise calendar of dates for 2023 when one can attend these sessions? Ravinder.

Model Builder

Discussion List