Modeling

Optimizer - Approach
Hi All, I am trying build optimizer for assignment of products into lines. Below is the scenario: 1) calculated the capacity of each line ( Dimension by Factory Lines) 2) Created Production plan for each SKU ( Dimensioned by SKU) 3) Then Have a mapping module between Factory lines and production which helps to decided…
Forecast Function in Anaplan
Hi team, Can i know if we have an equivalent function for forecast() from excel in Anaplan. In Excel we have Excel FORECAST function The FORECAST function in Excel is used to predict a future value by using linear regression. In other words, FORECAST projects a future value along a line of best fit based on historical…
LiS for Export module
Hello Comunity, I am trying to build a LiS on order to have a selection of the Forecast and the Type of the FTE. The problem I have is that when I try to build my LiS on my Forecast Model, the FTE Type is a subset List put in pages. So I won't be able, in my LiS to have the Forecast by each FTE Type(the selection is not…
6.11.1 Activity: Add Version Details Module
While creating the versions module the budget doesn't show up why? Help me here plz.
sso selection is not visible for our models
Just noticed our models are not showing "SSO" option selection in Users tab. I am workspace admin/tenant admin, so not sure what I am missing here?
Native Time must shift with snapshot period
I have native time and snapshot period as my dimensions, I want the data to populate when I select (snapshot period as a page selector) Snap - Feb 23, the native time on the grid below must show from Feb 23. Created module with Snapshot period as a dimension to use that to show the forecast months, it is of no help as the…
Model change best practices (Sept 2023 Community Challenge recap)
Author: Julie Ziemer is a Certified Master Anaplanner, Anaplan Community Boss, and Solution Leader/Business Analyst at Akili. There were so many detailed answers to the September Community Challenge — it was a challenge just to sort through all the great information! To help the Community, I thought it would be helpful to…
How to show UserID in the Target module for the user created list items?
Hello, Employee Details is my source module, in which Users (Manager Role) manually transfer employees. Manual Transfer ID will be created for the employee's vacant position. Current Month filter applied on the page. Running an action creates list (TBH) with Manual Transfer IDs and also loads the data into module…
Top five most useful recent updates and features
Author: Kathleen Sullivan, Certified Master Anaplanner, Solution Architect, and Manager at Cervello. Anaplan is constantly releasing new features to the modeling experience and to the user experience. These spark so much excitement for all Anaplan users because it increases usability for everyone, administrators, model…
How to convert an annual amount to a monthly amount
I have 2 modules, both dimensionalized by the same list and time (1 is by year and the other by month). I need to take the annual amount in module 1 and spread it over the monthly amount. I've tried spread(Annual Amount, 12) but I'm not able to get anything to populate in the monthly spread module. Any guidance would by…
Dimension Help for Equity Waterfall
I am new to Anaplan and am currently doing a project for fun. I am trying to recreate a equity waterfall that is commonly used in Private Equity. I am currently stuck on an issue on setting up dimensions that will be used for the waterfall calculation. Attached are screen shots of what I am trying to recreate in Anaplan.…
Need help to avoid hardcoding SELECT
Hello, Need some guidance on how I can avoid hardcoding. Let say I have a module A that applies to Country and Product (Coke and Pepsi) and line item as sales I have another module B that applies to country and I want to create two line items Sales - Coke and Sales - Pepsi which I then want to compare variance. This is the…
How to make Total Final Allocation as 100% ?
Allocation% will be loaded into this module which is dimensioned by Channels and Country. For some channels, Allocation% shall be Held or Overridden. Here required output is to get Total Final Allocation% as 100%. But, I end up with having Total Final Allocation% same as Total Allocation%. (Here 74%) The below snapshot…
Host Images Directly In Anaplan and Display on Dashboards Like Data and Files
Hi Anaplan! It would be great if Anaplan could store images directly and host them on the platform to dashboards. This would allow for easier hosting and one secure location. Also if there was a process assigned to uploading images this could help use cases for uploading multiple images at once in a bulk upload. Thanks,…
Level 1 Model Building EMP02 Employee Expenses Module Dimensions
Hello, I am currently in the process of going through the Level 1 Model Building course. In section 10, I was instructed to create a module with the dimensions: #E2 Employees, Active?, Time The problem is that I don't see Active? anywhere in my model, except maybe as a line item in a separate list or module. Regardless, it…
Search Option for Filter Line Item to Find
Hello Community, I would like to give one suggestion/idea on to provide search option while applying filter on module. This thought came when I'm scrolling to find my filter line item out of n no.of line items in the module. I hope this makes easy modeling/avoid scrolling a lot while applying filter.
Model sync error due to time scale and time summary
Hi all, I would really appreciate your help with a weird error. I'm trying to synchronize changes I made in my development model to my production model, but I'm getting the attached error. I did make changes to timescale and time summary, not brought forward property. What puzzles me is that I get this error while the…
Data Copy Model to Model
Hi, I want to copy the data from one deployed model to another deployed model, what would be the best strategy to complete it with using minimum import actions? Thanks, Anmol Sarna
NEW UX HOME PAGE - Set background and themes to suit organisation
Hi Anaplan, I have just started using the new UX HOME screen and thought of some developments to make it more customisable. The UX HOME screen could benefit from more customisation options to suit customer themes then being generic. - Set the HOME screen theme colours of banners and icons / tiles - Set the HOME screen…
Add / Customise Company Logo to Anaplan Navigation Bar
Hi Anaplan! It would be great if you could add a company logo to the top Anaplan Navigation bar, Many clients have asked for this. Thanks, Usman
How to move or copy an excel spreadsheet without loosing connection
I'd like to merge 2 excel files. Both have anaplan connections. How can I move or copy excel spreadsheets to another file withour loosing my anaplan connection?
Statistical Functions Package: Normal Distribution
Concept: Include basic Statistical Functions in Anaplan Description: I miss some basic statistical functions among the available functions. These formulas are extremely useful when it comes to calculate chances or risks, which is a common and useful bit within the forecast calculations. A good example is the lack of a…
Financial Consolidation
Hi everyone! I'm trying to explore Financial Consolidation - IFRS app by Anaplan. I see this app as a source of supreme value for one of my clients. However, I'm a little bit confused of its complexity. As for now I understand the general logic of the model, but I'd like to get enlighten into step-by-step user experience…
Remembering to keep the F.I.T in your model retrofit
Author: Taryn Townsend is a Certified Master Anaplanner and Senior Manager at Deloitte Consulting. As technologists and planners, our reflex is to look to the future. We strive to keep up-to-date on the newest and most optimized solutions for our clients and users. This can often lead us to opportunities to give our legacy…
Changing production models: corporate psychology vs. customer satisfaction
Author: Jared Dolich is a Certified Master Anaplanner and Partner and Founder at Retailitix. Consider this cartoon from Clowncurls. Maybe a bit exaggerated but sadly not too far from how Anaplan change requests come in. The question is how should you respond? Long ago I was a service desk manager for a 5000-store retailer,…
How to turn on file upload toggle on classic dashboard or NUX.
I have created and import action of users through CSV file but unable to find same toggle in classic dashboard action to upload a new file and run action again to update my user list.
IMPRESSIVE! Community Q&A Challenge recap
Earlier this month we launched our inaugural Community Q&A Challenge, where we presented an Anaplan-related question to our Community to answer and share their perspective. We asked, “As an Anaplan model builder, what steps do you take to ensure that changes you make to an existing module don't create unexpected results in…
3.3.5.6
Have been trying the Shipping cost variance formula but could not crack it. Help?
Cumulate a moving target
Hey Anaplanners! Hopefully a fun one and not just my own short-circuiting. I'm working through a capacity allocation rankcumulate, where my list items(SKUs) have a target for a month, and multiple sites that can produce units towards that target. My issue is that the cumulation is correctly grouping by SKU group (family)…
Dynamic Cells Calculation (DCC)
This feature would allow to selectively switch between "Calculation" or "Manual Input" on a specific LineItem. Much like the DCA, the DCC would be based on a boolean. When True, the formula would apply but when False the user would be allowed to type data. This would allow to make Anaplan much more dynamic and greatly…

Modeling

Discussion List