Model Builder

Export Function
Hi Anaplanners, Hope you all are doing good! I have one question regarding export. Lets say we have module dimensioned with 4 dimension . And we cannot add 4 dimension in row. I have added time dimension(Year) in Page selector. While exporting I dont want time to be displayed in export file. Is there and possibility in…
Imported cell history include with source Module name
In as much detail as possible, describe the problem or experience related to your idea. Please provide the context of what you were trying to do and include specific examples or workarounds: When we are importing from different list items/ one module line item to line item import and when we see up the history we done get…
Quick 5 minute Test : ADO Navigation - Share your insights !!
We are looking to capture your feedback on the new navigation system compared to the old one. With a quick 5 minutes un-moderated navigation test. You don't have to currently use ADO to participate — if you have experience with ETL Tools, Data Warehouse Tools, or similar systems, we’d love to hear from you! We currently…
Need help finding a possible error in SYS01 Time Settings by Week and INV01 Inventory Ordering
Hi all - I have been trying for days to figure out where there is an error on my own, and I have not found the solution. I believe the error is somewhere in the SYS01 module as my formula for Beginning Inventory (which I've confirmed is correct, as far as the Anaplan Community is concerned) just resets every week that…
Moving a model from Classic to Polaris
Author: Mike Henderson is a Principal Solution Architect at Anaplan. There is growing interest in taking existing models that operate in the classic (Hyperblock) engine to Polaris. There are a variety of reasons motivating the move such as workspace optimization, accommodating natural model growth over time, and…
Still stuck on "Confirmed PO Delivery" and "Confirmed PO Receipt", something isn't adding up.
I'm honestly not sure what to say about this one because I thought I had nailed down all the formulas, and then the corrected formulas, but here we are. I think I can narrow down where the errors are taking place, I just don't know how to correct them. In all truth, I could really use a review of all the formulas in…
Need help related to custom Time Dimension
Hello Everyone, Want to create module which captures data days wise, but the challenge is the data should be Displayed in two ways. So, If current forecast day is 6th Aug, so 1st Column named "Till Date" will be showing Summation of 1st Aug to 5th Aug and remaining days will be displayed in further columns which will sum…
How to roll back a production model to recover lost data
Author: Jessie Zhao is a Solution Architect and Certified Master Anaplanner at Anaplan. Working with a model in ALM has a lot of benefits. These include building new features in a development model anytime without affecting production users, securely managing production lists by identifying structural data that needs to…
Line Item Sums per applied dimension
It would save a lot of space if you could specify the sum option in the Line Item based on the applied dimensions. Especially on hierarchical dimensions this would have effect. Sometimes a sum is only needed for one of three dimensions. This would safe space consumption a lot. This feature could added in the sum options:
Using Network cards for dynamic org charts
Hi, We came across org charts (Hierarchy Charts) which are a great functionality. However, we want the client to be able to do scenario planning on the hierarchy and by Month. E.g. John could report to Smith in Jan, but in Feb , he report to Molly. Since Org Charts cannot refresh dynamically unless you incorporate time…
Straight Line Depreciation spread issue
Dear Model Builders, As per attached screenshot of my Straight Line Depreciation code, I am not able to get depreciation to calculate and spread for all subsequent months from Date in Use to Useful Life of the asset. All I am getting is a depreciation for a month of Date in Use but not for subsequent months. I have even…
Opening Capex Code not referencing Closing Capex correctly
Dear Model Builders, Please refer my attachd Opening Capex code which I believe not referring to the previous month's closing capex correctly. Appreciate your help on finding the cause of error and possible solutions. Thanks
How to convert month to text?
I am needing to convert month to text as we have a specific nomenclature we use for our company (i.e, if the current month/pay period is May but the pay accrual month is April I am needing to have a text display for May 25 as AprilPayMay25). I've done a lookup table in the past but was hoping for a formula that could do…
Add a Data setting for Waterfall Charts to select any line item as a bar go from Zero to Value
Would like to see an additional Chart setting to select a line item as a the last "Total"bar in a waterfall chart that goes from Zero to Value. For example, the EBITDA bar in the below screenshot is going ~6k to ~14k. I should be able to manually select the line item, telling Anaplan to override the bar's y-axis values…
L2 Model Building - Sprint 3 - confirmed PO delivery
I am stuck with building the formula for "confirmed PO delivery" In case line item "PO submitted" is 1 for week x, it should show 1 in line item "confirmed PO delivery" for week x + offset. The offset number is depending on the shipping time shown in week 1. I used formula: IF PO Submitted = 1 THEN OFFSET(PO Submitted,…
Question about Boolean line items
Scenario My rows include 3 items - REC1, REC2, and REC3 my columns include quarters - Q1FY25, Q2FY25, Q3FY25 and Q3FY25 Line item - 'Select' which is formatted as Boolean. Desired Output - If I check any one Boolean among REC1, REC2 and REC3 for a particular quarter, the remaining two rows should automatically be disabled.…
Is there a way to get a timestamp automatically added to an export file name
It would be super helpful to have the timestamp as part of the export file name in Anaplan, especially when clients run reports every day during the budget season. Is it possible to do? And do automatically?
Dynamic Subtotalling for List item subset based on user selection - Module Size Optimization
Hello, Apologies for the long post, I tried to be descriptive enough! I've a module in production which has close to ~3 billion cells, (this module alone occupies 25GB of space). I'm trying to optimise this module for space and make it scalable. The reason for the size **** up is multidimensionality and extreme sparsity of…
2025 Recertification update
We're working on enhancements to the certification program, focused on further elevating the quality and credibility of our certified professionals. These improvements will highlight the expertise of our super users to provide a distinct advantage in the competitive market. We expect to share more details this summer.…
How to reference a Time Period in an IF statement please?
My PRACTICE module has time dimension as Months 2019. I want to create an IF statement in the RESULT line item that says IF Time Period < Jul 19 THEN TEST 1 ELSE TEST 2 How do I reference the Time Period in the IF statement? i.e. how do I write the IF statement so that in the RESULT line item there is 250 from Jan 19 until…
Model Integration details
Hi Anaplanners, I would like to know what are the different ways to fetch information about the integrations (versions, type of integration etc) that are present in my model? Are there any direct API calls using postman or I can find this information somewhere in the model itself? Regards
Functionality to Delete a user account at Tenant Level
In as much detail as possible, describe the problem or experience related to your idea. Please provide the context of what you were trying to do and include specific examples or workarounds: Use Case: - Functionality to Delete a user account at Tenant level does not disable. Problem: - For system integration in any…
Update subsets for the lists with Selective access
Hello, could you please help with following situation. I have the flat list of positions for which Selective access is set (according to the access of the user, so that HRBP of the Facility 1 has access only to applicable positions). All the major calculations are made on this list of positions ir order to save space…
Last 52 weeks Calculation
I have a requirement to show the last 52 weeks value. I want to create another line item which has to sum last 52 weeks total hours e.g.: 03/08/2025 should show the last 52 weeks data this should be dynamic and 52 weeks should change based on the week. Thanks in Advance.
How to SUM the last three months
In the line item "last 3 months sum", I'm trying to sum the last three months. I tried using timesum but wasn't getting the right numbers. Any help appreciated, thanks!
Converting Text to Date and Date to Text
Author: Julie Ziemer is a Certified Master Anaplanner, Anaplan Community Boss, and Solution Leader/Business Analyst at Akili. While Anaplan has specific functions to convert between data types, converting Text to Date and Date to Text are two commonly searched topics on Community and they require the use of several…
Done with L1 and L2. What next?
Hello Anaplanners! I recently completed my L2 certification for Anaplan. Unlike L1 and L2, there are no courses in the Anaplan Learning Center for starting or enrolling in L3 certification course. Can anyone let me know the next steps towards getting an L3 certification and an eventual Certified Anaplan Model Builder…
L3 User Story 2.4
Hi Community, In L3 User Story 2.4 requires the comments to be seen by others. Who should see the comments? That Country Sales Manager's ? and do we have to create a link or add an line item for comments associating with all accounts and then publish it do UX so end user can add comments along side of the accounts…
Function that locks the specific models
I would like the function to lock specific Models at "Model Management" so that they can't be easily deleted.

Model Builder

Discussion List