Modeling

NUX Forms: Exception handling when duplicate code entered
When using forms to add to a list (where the code can be entered), users can accidently re-enter an existing code which triggers a model roll back, as it's considered a duplicate. There's also no notification the model is rolling back so it looks like the app is spinning its wheels. This leads to confusion and potentially…
I can't create a model
Hello everyone, I want to create a model but when i click "manage models" , the error below shows up. If anyone has faced this issue before , I need help to resolve this. Best Regards,
End Users being able to see all Users in a User dimensioned module
When you've got a module dimensioned by users only if you're a workspace admin can you see the whole list - not very helpful if you're pushing out user-level DCA to end users to manage themselves. Now I can have a separate "user list" that's can be interacted with but it should be the case that end users can see the whole…
Delete Multiple Users from the Model in one shot.
Hi, Is there a way to delete the multiple users in one shot from the model. Thanks, Ashoka GK
Text to Column feature in Anaplan
Anaplanners, Is there a way we can convert a text to column like how we do in excel. Example below: You can see Column A (member name) and Column B (Projects Involved/textlist). Using Texts to Columns we can convert column B dynamically to different columns. As its dynamic some members have 3 projects while some may have…
Ability to sum based on boolean
Description of enhancement required Ability to allow to aggregate using Boolean mapping. Currently mapping can only be applied over List elements. It would simplify many formulas if we could simply SUM/PRODUCT over TRUE/FALSE Boolean values. An example of enhancement - See example below *List called "Client" with 3 items.…
Hi Everyone, I am reaching out to the community for some help with a formula.
I am looking for a way to automate the Batch Index column with a formula. Any help or advice would be greatly appreciated! Thank you!
ALM Question - How to setup Imports and Import Data
ALM Newbie here. Implementing my first ALM for a model. I understand the difference between Production and Structural data. I have categorized my list as production vs structural data based on my understanding. I currently have some import actions that loads new members to my production list and load data into data module.…
RANK within Multiple Hierarchies
Hi, I'm trying to use the RANK function within a Module with multiple dimensions with hierarchies. As explained in Group option in RANK Function by @DavidSmith I've created a Group By list but however when you're on a parent in a hierarchy this 'Group By' line item will result into blank. Changing the summary method to…
ISNUMBER function
There is currently no way no easy way to identify whether data is numeric or not. The workaround for X is to check the following set of conditions: NOT (VALUE(X) <= 0 OR VALUE(X) >= 0) Currently this is certainly not a consistent approach and there is always a risk that the comparison operators ("<=" and ">=") will start…
How I Built It: Combining two custom time schedules
Author: Moriah Reyes is a Certified Master Anaplanner and Manager at Lionpoint Group. Hello Anaplan Community! I’m excited to share my ‘How I Built It’ tutorial with you all. This video shows how you can cleverly use an index list and text list to combine two custom time schedules. Building a custom time schedule can be…
Community perspective: Version compare and dynamic module line item description update
There are times when we need to generate output modules with the ability for version comparison. Although Anaplan has its own version comparison function, sometimes we need to build a dynamic scenario creation and comparison function. Please see Planual instructions for versions before proceeding with custom versions, as…
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

Modeling

Discussion List