Modeling

How to perform activities while starting as a beginner with no application on the system?
Could you please help how do I get to access the application hands on for practice and further to perform activities to answer the exam questions through my system LIVE. I'm a beginner trying to give L1 exam. I have completed entire course theory with certain practical activities yet to be practiced. Any help is highly…
Level 1 Importing Into Modules and Making Edits
I'm on Level Lessson 7 and there are multiple activities where I have to import data from csv file. Is there a way to make edits to mapping after data has been imported already or do you have to start from scratch? In general is there a way to undo mistakes in Anaplan? Tried ctrl z but it does not work.
4.8.2
I've been having an issue with locating my error in the model for the Parent Error I keep getting everything is mapped out correctly and I've literally lost 2 days trying to figure this out it's not because of lack of effort. But now I fear I won't have my lessons done in time to stay on pace to finish. I really need some…
Line Item Restriction
Hi Community, Can we restrict the user to enter only positive numbers in a line item? And if he enters anything apart from the it should also throw some text, displaying only positive numbers are allowed? Thanks a lot for your support 🙂
L2 Sprint 3 Distribution center capacity module
Hello Can someone please double check the formulas used for this module, its showing percentage for more than 100%. Is that normal? Please help me correct if there is any error in formula. Thank you!
ANAPLAN
what is the difference between OFFSET and POST ?
3.5.4.2 Create Distribution Center Capacity Module
Hi, I am getting the incorrect values even after putting the formula according to the purpose. please help if any mistake i have done in formulas. I getting the values greater than 100% in percentage full line item.
Format of mapping used for lookup doesn't match any dimension of the source
Hi all, I've looked through several of the queries/answers on this topic and still can't work out what I am doing wrong... I am trying to provide a summary of employee expenses by region and role in REP04; I am trying to use EMP02 as my source as this has employee expenses by employee and department. As there is no direct…
System Modules
Dear Community, @rob_marshallJaredDolich Why does most of the Anaplan Modules in the App Hub: Such as Long Range Planning is not using System module creation and directly jumping to data / input / calculation modules? It is going to impact the module sanctity right?, Your expert views would be highly appreciable. Thanks &…
Grid:_onSelection Change Error
Does anyone know why this error occurs? It is typically when I am building a formula then click on a different module.
How to use SUM and LOOKUP dynamically
I have Order module(Region, Order) Order(1,2...) comes from each Region. Order has Item and Amount. I want to aggregate item-amount by dynamic Region like this table. If Users chose the Europe, Item-Amount Table is aggregated by Europe. I tried SUM and LOOKUP but I couldn't. The point is I don't need Region List in…
Open multiple items from Search in NMX.
I am submitting this idea on behalf of Okta. When using the New Model Experience, we would like to be able to select multiple models from the Model Search panel. Right now, the process is that we use the Search, select the model, open it, and then have to open the search and re-type the search again to re-select a second…
Creating new line items for each year instead of using native time?
Hi All, I recently took over a few models that make use of a month list and separate line items for each year instead of Anaplan's native time functionality. I was told the models were built this way because end users didn't find the dashboards to be intuitive and this was a means to improve the user experience. Here's an…
Formula Logic Help
Hi guys, Got a question I need assistance with. I have a number of lists that follow a hierarchical list, account level 4, 3, 2 ,1. At level 4 each account also belongs to an accounting group (online, local etc) and has a signage value of either 1 or -1. The accounting group and signage are contained within a module called…
Formula - What am I doing wrong?
Best Practices for creating a formula dealing with SELECT
Hi, We are trying to create a formula that will subtract the sum of all the List Items, (excluding List Item 'Other'), from the overall Total of all the List Item totals added together. We were thinking of using the SELECT function to pull in the amounts for each List Items and then summing those all together in a SYS…
DEMO 03 Demand Forecast. Weeks(All week issues)
why all weeks are visible to me for 2020 . Rather than 4 Weeks ??? Thanks & Regards
Collapsable lists in page selectors regardless of list size
As of today a list published as a page selector dropdown doesn't offer the +/- expandable tree in a page selector when the list surpassed 1,000 items including parents, and this feature is disabled, much like the list settings page stops you from using a tree after a certain size. I understand this is a performance issue,…
Data Integration
Suppose any clients wants our view to automate integration .Which platform is good to start like mulesoft,dell bhoomi ,informatica or any ETL tools or REST API. Please suggest some pre-requisites or some basic question/information which we can ask to the clients.
Ratio of what % each child makes up of parent
Hello, I am attempting to calculate the % of a parent forecast each child makes up in a given time period. For example, a month has a 100 unit forecast in America. Texas makes up 60 units and California makes up 40 units (both children of America in a list). I am trying to show this: Texas 60% California 40% America 100% I…
Plan better, faster; migrate to the UX!
Provide your users with a seamless, intuitive, modern experience for them to plan more efficiently in a collaborative way, at their desks or on the move. Present and distribute pixel-perfect, visually appealing reports to stakeholders. The Anaplan UX (formerly new UX) has been with us for over two years now. Since it was…
Morse CF - Negative Formatting
Hey Anaplan, Anyone have a suggestion on how to use the morse conditional formatting to signify both negative and positive values are significant? Issue I have is that if I have: -50%, 0, 50% CF -1 (red), 0 (white), 1 (green) The problem I have is that -50% shows as a red dot, whereas 50% shows as a significant line. I…
New Modeling Experience Idea: New formula editor box to be avalilable in deployed mode
With newest UX for modeling I found the missing opportunity to see the pretty syntax highlighting in models being in deployed mode. The double-chevron icon is unavailable during deployed mode so i can't switch to "New intuitive formula editor so you can highlight syntax to improve accuracy and easily read formulas" which…
Ability to import a saved template card into Management Reporting Page
When creating a board or worksheet in NUX, it would be good when saving these as templates if the templates were available for import / use in the Report page for management reporting rather than having to rebuild them.
Report page : add card template library
it would be very helpful if we could have access to card template library when we build a report page, as it exists for boards. Report page : Boards :
OEG Best Practice: Time range application
If you have a multi-year model where the date range for different parts of the model varies (for example, history covering two years, current year forecast, and three planning years), then time ranges should be able to deliver significant gains in terms of model size and performance. But, before you rush headlong into…
New Model Experience: Not able to fully view formula bar when model is deployed
Hello, while I can open the formula bar in an ALM Dev model - I cannot do the same on any Test Environment (or the live environment). This is making very difficult to debug any issues on a deployed enviroment (need to check the formula in Dev which might have already changed) by another developer. Not too sure if this is…
Current Day
Actually we have a module that includes a column with dates, and we want that Anaplan identifies if a date from the column has passed or not yet. For that we have created a line item, and we would like the logic behind the formula to be something like this: IF the date (from the column) is prior to the date (current day)…
Most used Planning Models in an Organization
Hi Anaplan, @JaredDolich @Misbah @rob_marshall @MelanieM What are the most used Anaplan Planning models across different sectors, especially in the following domains: 1. Financial Planning and Analysis 2. Sales & Operations Planning So, will try to learn more about the same for execution. Thanks & Regards Badam
Remove the 'Edit' formula button within the new model building environment.
In a recent amendment to the new model building environment, there is now an 'Edit' button that needs to be selected before a model builder is able to amend an existing formula. This only appears when 'expanding' the formula bar. Whilst I could perhaps understand the reason for this addition in preventing…

Modeling

Discussion List