Modeling

Standard Solution for Iterative Calculations
There is a need for Anaplan to have standard Iterative Calculation Functionality. The model that I’m building for the client includes multiple circular references. I need to calculate the amount of the Cash Available for Investments that depends on the Ending Cash Balance (amongst other line items) for the period. Ending…
The summary methods in INV01 Inventory Ordering line items didn't match
In '3.3.5.3 Check Your Work' Level 2 Model Building : Sprint 3, I succeeded on comparing the INV01 module that I've made with the first and second example above (on SKU level) without changing the summary method. Then, I change the summary methods (in the picture below). I also succeeded on comparing it to the third…
Show/Hide Production List
Hi, I want to show or hide production list. This is original table. It has Country List(Like France). When I show only Japan and Thai Items in TEST APP, there is France Item in Prod APP. We should not use show hide function, should use filter function? Or there is another way to show/hide production List?
Top 25 Anaplan features released in 2022
Authors: Misbah Ansari (@Misbah), Certified Master Anaplanner and CEO/Founder at Miz Logix and @WajidAli . Within this fast-pacing world, it is important for technologies to move even faster. Anaplan, being a leader in the Connected Planning world, released a plethora of changes and/or updates in 2022 to almost every…
How to fetch unique value using textlist function from child level to parent level
Hi, I need help to get unique values using textlist There is System module SYS01 at child level dimension with List A, I need fetch text value from line item X in SYS01 to Line item Y in SYS02 . The SYS02 module has dimension B which is parent of list A. While using Textlist function Im getting error: 'SYS01'.Parent is not…
3.3.6 Activity: Test the Shipping Cost Formulas
Why am I not able to get the check box for Override Shipping Method?
Within Excel Add-In having an ability to customise elements on the fly
I'd love to this feature become available is an ability to create individual dimensionality intersections, similar to that of TM1 or Jedox. This is where the various element intersection points can be typed into the excel sheet and so long as that sheet is connected to Anaplan, will pull the data into Excel. This is also…
Dropdown-formatted line item with default as one of the list items and restrict turning as Blank
Hello Everyone, Is there anyway we can make alteration in Dropdown-formatted that having a list item as default and blocking user from making that as Blank? User can able to add new list item in that module where i am using that dropdown-formatted line item If not i will add that default list item manually TIA
Level 2 Conclusion DEM04 Demand Export
@Misbah Could you tell me what I am doing wrong in this formula. Demand = 'DEM03 Demand Forecast'.Final Forecast[LOOKUP: 'SYS08 SKU Details'.Product]
How to prevent edits to a version
I have set the edit from/to fields to 'None' However, for data inputs where there the time scale is set to Not Applicable, users are still able to edit the data inputs. Is there any way to prevent this?
Errors while running process.
Hi, I'm getting below error while running for all process in the model which were running correctly till last week, each process involves imports from multiple models(1 -5), what can be reason for this error? what is workaround? error -> Error Message : "localMessageText": "Import connector: Failed to retrieve data from…
2022 IDC EPBF Market Scape Key Takeaways - Anaplan leads the way
Anaplan is a recognised leader in the first-ever MarketScape for Worldwide Enterprise Planning, Budgeting & Forecasting (EPB&F) Applications by IDC. As with the Gartner FPS MQ, Anaplan is a clear frontrunner. Anaplan was instrumental in moving the market from EPM to this new EPBF category that highlights and rewards…
L1 Model Building Activity 6
How would I go about adding Department and Role to SYS08? I don't believe that was a part of the exercises which I followed step by step. This is what I have for my SYS08: I have Department and Country...
How to convert Month to year (Ex: Apr 22-Mar 23 to FY 22as year)
Hi Everyone, Is there any method that we can convert month to year, as i have scenario like timescale was APR 22 to Mar 23 as text formatted line item and we need to get a time period format as year and value would be as FY 22. Any Advice. Thanks
How to merge two models into one?
Hello Team, Would like to check on the following : There is Product standalone report exists in two models. I would like to merge into one model for space optimization. what are the steps to be followed? An leads or advise on how to proceed this? Thanks in advance.
Enhancement Request for the ability to copy text (w/ line breaks) from one source cell to one target
Summary: Currently, customer is facing the issue that the lines are divided into multiple cells. Can we fix the behavior the line breaks in the source cell are interpreted as cell breaks when pasting? I expect line breaks should be line breaks not cell breaks. Description: ・Customer Requirement Customer has lots of cells…
Two approaches to ragged hierarchy
Author: Taichi Amaya, Certified Master Anaplanner, and Financial Planning and Analysis Specialist at Pasona Group, Inc. In Anaplan, we consider it a significant feature that lists are hierarchical. Hierarchical structure allows for smooth and meaningful connections from the parts to the whole and gives flexibility to the…
[Updated] Level 2 Sprint 2 DAT03 Historic Volume
Hello Experts, On DAT03 Historic Volumes my volume line item don't match with the values for FY20 but does match with Offset volumes for Fy20. I used the following formula: IF 'SYS01 Time Settings By Week'.'1st Forecast Year?' THEN OFFSET(Volumes, -52, 0) ELSE 0. also in DEM03 demand forecast pulls only FY20 data not FY21,…
L2 - Sprint 2 - Activity 2.4.7.1 Create Demand Forecast Grid UX saved view
Hi, Can somebody please help me with this formula?
Dynamic Cell Access
Hi, The dynamic Cell Access - learning app doesn't show in my Workspace although I have download it three times. Please guide me. Thanks, Mark
How to use “LOOKUP” with summary elements
In the following article, I would like to discuss a common case of model building: the LOOKUP function doesn’t work with summary elements of hierarchical lists. Among other things, this forces model builders to use SELECT and not configure Production Data for some lists. I want to present to you an alternative approach.…
Level 1 model Building Activity 5
Hi @JaredDolich i Have stack with how to update the formulas for my Line Items in my Module EMP02 Employee Expenses. This is the formula i am using IF Employed? THEN Salary * 'EMP03 Employee Drivers'.Bonus %[LOOKUP: 'SYS08 Employee Details'.Department, LOOKUP: 'SYS08 Employee Details'.Role] ELSE 0 i have read other…
3.3.5.4 Update INV01 to Allow Override of Order Amount
One of the Product Supply Manager user stories for this sprint included the ability to override suggested order quantities. Update the INV01 module with additional line items to provide this functionality. In the INV01 Inventory Ordering module, add the following line items: Line Item Format Purpose Override Suggested…
OEG Best Practice: The model design process
The process of designing a model will help you: * Understand the customer’s problem more completely * Bring to light any incorrect assumptions you may have made, allowing for correction before building begins * Provide the big picture view for building This process includes the following steps: * Understand the…
How to keep Data in a Version "Locked" when Source Data Changes
Hello, I have an interesting challenge I am trying to solve. Background: * We have 4 Forecast versions. * Version Forecast (3+9) means that the forecast has 3 months of Actuals and 9 months of forecasted data. * Actuals data is loaded from a source system. The Challenge: How can we ensure that all data in the Forecast…
Module Content Panel - Header separators instead of empty modules
As an architect, I would like to have the ability to add bolded headers directly within the modules contents panel to separate a model's modules. Currently this is accomplished via empty modules with delimiter based titles. For example an empty "------ Systems ------" module created above all SYS modules. Having the…
DYK S2 - WEEK 10 (RANK)
Learn how to use RANK in different ways. Watch this video to know more https://youtu.be/q_c-pmw6u78 Thanks, Misbah Miz Logix
DYK S2 - WEEK 9 (Multiple UX Features)
Watch this video to know about three latest UX features. https://youtu.be/_7j6vQ2GG_A Thanks, Misbah Miz Logix
DYK S2 - WEEK 8 (Auto Complete)
Auto Complete - Watch this video to learn how Auto Complete helps you write the formula in the most efficient manner. https://www.youtube.com/watch?v=JiX0jko1uuw&t=143s Thanks, Misbah Miz Logix
DYK S2 - WEEK 7 (Naming Convention)
Naming Convention within models - watch this video to know more https://www.youtube.com/watch?v=o2d9zcwMILw&t=527s Thanks, Misbah Miz Logix

Modeling

Discussion List