Modeling

Planning whole units by a curve
Hi. We have a requirement, in which the customer wants to plan a given number of units to be sold by a monthly curve, in which you only have to plan whole units, i.e I have 45 units and the % of the curve in Jan 23 is 3.45%, so the units to be planned in Jan 23 should be 2 instead of 1.55 (the result of multiplying 45 *…
Product/Country Hierarchy list
Hi I have a list of Products that has its own Parent (Product Brand). Also I have a Country list with Region as Parent. Some of the Products correspond to certain countries, and some of them to more than one country: Product A (Brand A) -> Country 1 Product B (Brand A) -> Country 1 Product C (Brand B) -> Country 1 Product…
Anaplan Optimizer across time v2
Dear Community, I want to use the Anaplan Optimizer to optimize planning/capacity utilization across our supply chain. Got inspired by this link which shows that the Optimizer can in fact take time into account: https://community.anaplan.com/t5/On-Demand-Courses/Optimizer-Dynamic-Time-Setup/ta-p/74604 My challenge is that…
Community perspective: Version switchover management from UX Page with API
The Anaplan API offers many improvements to model management, which can help improve the data quality and make work more efficient by eliminating repetitive tasks, which are error prone. One area where I have found myself doing repetitive tasks is switchover management. Especially when dealing with multiple models it…
Need help for the logical formula of having a running balance
So basically I need help in the formula for arriving in the 'Final' line item. I tried using Previous formula but I am missing something in the logic. Thank you!
In 2.3.10 of Spring2use an intermediate module to align the source with the target
In Sprint 2, Create Demand Forecast, "Remember that Anaplan can automatically aggregate data upwards (from lower to higher levels) in the hierarchy, but in this case you will It is necessary to use an intermediate module to align the source with the target", for the second half, how to achieve it?
Is it possible to bring back the model that was deleted by mistake?
Is it possible to bring back the model that was deleted by mistake from the Manage models screen. Is there a way to restore it?
Collapse All Functional Areas Button in Contents Pane - NMX
In a model with lots of modules in functional areas, it would be nice to have a button in the contents pane to expand/collapse all functional areas. At the moment you have to collapse all of them individually or scroll for a long time.
"View-Only Workspace Admin" - new access type
I know this idea has been discussed but I don't find an Idea in Idea exchange that exactly corresponds. I have had some customers request a new technical user access that is a "View-Only Workspace Admin": users that can have the ability to view everything in the model settings (the models, lists, line items), but not the…
Check item present in list and return TRUE or FALSE
Hi Team, I am planning to compare list item from LIST A with lineitem Assignment code (text format) in same module. if item present in list A boolean line item in same module will return true else FALSE List A contain assignment code as follow: How can I achieve this? Please help. Thanks JJ
How can I make this LI go over time
Hi, I'm having trouble making this LI be spread over time. What is the best way to go about this? Thank you
IF statement with different hierarchies
Below, I have this module dimensioned by O2 Department (Level 2 in the hierarchy) and another list. My IF statement always returns FALSE when I have some start dates that do match the first day of the month. DAT03 New Hire Details is dimensioned by New Hires (Level 4 in the hierarchy). I believe I have a hierarchy issue…
Conditional Parenting
Hi all, I've got this situation where my region hierarchy is dependent not just on country but by the entity under which a sale is made. The table below is how I'd like the parenting to work. Region L3 entries then map on a 1:1 basis to Region L2 and again to L1. The entity specific region may roll up along with the…
Dynamically show list items in drop down based on a condition
Hi Team, Please refer the image below. The above image shows two grids on the page. Both have same list dimension. I need to build a logic that dynamically changes the items in drop down in the right grid's line item(list formatted called 'Stage') based in the status shown in the left grid item(list formatted called…
Level mismatch on common dimension
I know this question has been asked many times already but I'm not following the solutions without my own example. I'm getting this error with the following modules and dimensions. TARGET: To add "Total Hires" to the Headcount and Expenses module dimensioned by Employee and Pay Type SOURCE: Total Future Hires in the New…
Financial Planning
Is there any model by which i can learn financial forecasting Thanks In advance
Allow data labels to be scaled into thousands and millions
It would be great to add a feature to enable data labels the option to be scaled in thousands or millions. See screenshot below where the whole numbers look too busy on the graph.
Level 2 Sprint 1 List Import Errors
When I imported flat files for Sprint 1 1.3 I did not include a parent as instructed, so my country list has only a code, and my location list likewise (see image). However, when I then import this list into G2 Country, it now has no parent listed under region. When I try to write a PARENT(ITEM(___)) formula, I receive…
Anaplan Optimizer across time
Hello everyone, Want to use the Anaplan Optimizer across time, and have found out that I can not use a line item running on the native time scale in Anaplan. Hence I am on the quest to create a list of the months and have been following this…
Calculate headcount by time
I'm having issues counting the current headcount by month. I have employee hire date, leave date, and projected leave date. I've attached snap shots of my modules. I haven't figured out how to include "projected leave date" into my formula yet. I'm stuck on trying to get the current employees based on historical leave date…
Dynamic Number's Format for Line Items based on Italian/English standards
Hi all, don't know if it is possible within anaplan to dinamically change the Number's Format of the same line item based on a specific Country Standard format? Maybe based on the Users Language/Country settings? Since we have both Italian and English Users inputting data inside the same Input Module (and they have…
level 2 sprint 1
Hi, i have completed Level 2 sprint 1 exam first attempt score : 60% second attempt score is 90% , but the score is not updated and i am not able to access sprint 2 can anyone help me
Calculating the Average Per Cash Curve
Hi, I'm trying to Calculate what my average would be in a certain month using a rate curve. My rate curves are inputs that are located in a inputs module and I believe I would need to multiply them by my average to see what the average would be over time. The only issue I'm having is that my input modules with the rate…
Need Calc Help
Hi Community, I am working on this use case. Wondering if this is possible. DAT01 Emp Details Emp | Start Rate EmpA 15 EmpB 16 EmpC 17 SYS02 Zone Module Zone| Lower Range | Upper Range ZoneA 14 15 Zone B 15 16 Zone C 17 100 How can I identify which Zone does an employee falls in. Final result needed Emp | Zone EmpA Zone A…
DYK S2 - WEEK 5 (Text String & Text Joins)
Formula per Planual . Watch this video to know more DID YOU KNOW S2 - WEEK 5 - YouTube Thanks, Misbah Miz Logix
Model Calendar grayed out in prod model - client has ALM
I think I know the answer but need to verify... in the production model, the model calendar is grayed out. The client has ALM. The model calendar is not grayed out in Dev. Is it grayed out in production because ALM is set up? I'm guessing they need to make changes to the Dev model calendar and push it to production. I…
Dynamic chart using line item subset
* Problem statement * Solution approaches * Selection on the chart * Using line item subsets * Step 1: * Step 2 * Step 3 * Step 4 * Conclusion Problem statement A customer from the banking industry recently posed this requirement: "As a reviewer, I want to compare different metrics. Some are absolute, and some are…
Import is not working with saved view contains 6 dimensions or Lists
Hi, I am trying to copy the one line item data to another line item within same module by using an import action from saved view(Source) to module(Target) and it is not working in expected way.. Module and saved view have 6 dimensions or lists, due to this i could not bring all these lists into Rows section of pivot option…
Level 2 - Sprint 3 - 3.4.3 Activity: Create Country Summary Module
Hello all, I'm having trouble figuring out with this error that I'm getting. Can anyone help me out? My formula is this: 'INV01 Inventory Ordering'.Safety Stock Exception Count[SUM: 'SYS08 SKU Details'.Country Made In] Thank you
Dates Format
Can the dates be set to format as 00/00/00? (mm/dd/yy)

Modeling

Discussion List