Modeling

Filtering a list based on a property
When in a list grid view, enable a list to be filtered on a property. This is only possible by creating a module using the list and creating line item linked to properties.
Parent-level Commenting with Line Items Pulled from One Module to Another
I have a question about parent-level commenting with line items pulled from one module to another. There are line items in module 1, which are pulled into module 2 via subset and transposed into rows. In the screenshot, you’ll see ‘Salaries & Wages’ is the sum of ‘Salaries’, ‘Overtime’, etc. There’s a ‘Key Highlights’ line…
Search Option while Selecting Lists for Module Dimension
There should be an option to search lists while applying to modules. In our use case, we have too many lists/subsets to scroll and select the appropriate one. Changing a dimension is even nightmare when multiple lists are applied to the module. Ideally, It is should be similar to how we add actions to a process ( Click and…
Excel user defined functions
If my Excel model has user defined functions, ie multiline VBA functions that are called by worksheet cells, can Anaplan handle them? I could not find anything about them online thank you
Open modules using 'Referenced By' column
It would be really helpful if the 'Referenced By' column opened all modules associated to the line item (similar to clicking on a functional area name to open all associated modules). This could be achieved by SHIFT+LEFT CLICK to differentiate from selecting the cell rather than following the hyperlink. This would be…
Deactivate Formula Scope if Versions = Not Applicable
Hi, In a module blueprint, there is a field called 'Formula Scope'. For modules where Versions = Not Applicable, using 'Formula Scope = Actual Version' or 'Formula Scope = Current Version' will nullify the calculation of any formula in a line item. This is potentially dangerous, because: 1. If there is a formula + Formula…
how to change the order of dimensions in " Applies to" ?
Hi, I want to apply the best practice of ensuring consistency in the order of dimensions, as described in following article: https://community.anaplan.com/t5/Best-Practices/Dimension-Order/ta-p/32934. However, when I apply the steps to change the order, nothing happens. What am I doing wrong?
Error : EMP02 - Dimension of mapping used for lookup doesn't match any dimension of the result.
Hi Experts, Please help on the below mentioned issue while adding formula for Bonus, Car, Phone costs & Medical costs to the EMP02 Module. BonusIF Employed? THEN Salary * 'EMP01 Employee Drivers'.Bonus %[LOOKUP: 'SYS08 Employee Details'.Department, LOOKUP: 'SYS08 Employee Details'.Country] ELSE 0Car costsIF Employed? THEN…
First non Zero
how to get first Non zero number as summary if lineitem is dimensions with list
List Inheritance
Where lists are in a hierarchy, it would be really helpful if Anaplan natively understood the concept of inheritance. Here's an example. Consider two lists in a hierarchy: * L1 Countries * L2 Cities L1 Countries is the parent to L2 Cities. Within an attributes module, each L1 Countries list item is assigned a currency.…
Reduce row label right border
Please can the right border/margin be reduced in row labels. The current border cuts off text too far from the cell border, below is an example. Whilst minor, this would just be a very quick fix to implement and would (slightly) improve visuals. Here you can see that the words revenue are being cut off too early, even…
Improve List Item Deletion
Improve the list item deletion within Anaplan so that if a model builder selects 'Delete All' from the delete dialogue when there are vast numbers of list items the model builder is prevented. Doing so would prevent model and workspace lock ups. To explain this further: Consider a list with 1,000,000 items. If you attempt…
Add Sort Selected On Reorder Dialogue
Can a 'Sort Selected' group be added on the reorder dialogue, similar to the 'Sort All' group shown below. This would help with organisation in models, most notably where you want to order numbered modules, but only in a specific area of your module list. The group would have a similar function, but as indicated would only…
Question about the February 22, 2020 Upgrade - ALM Restore Points & Documentation
Hi everyone! I just reviewed the changes in the 2/22/2020 upgrade - thank you for these and for working Saturday to implement! I had a few questions. I was hoping someone could answer these. @VickiA maybe you can help. ALM Restore Points For the ALM restore points, I wasn't sure what was the change. In testing this out, I…
Can we send email to users who are using gmail using browser .
Hi , My User is not using outlook and they use gmail through browser only .So is there any way we can configure in Anaplan MAILTO function to send email to gmail account . Thanks .
Getting a comments (editable text line item) at summarized level
Hi, In a primary module, there are some summary line items (like D = A+B+C) where 'D' is the summary line item. I am using these line items as a line item subset in another secondary module as a list and pivoted as rows. Now the requirement is to enter a comment against each of these summary line item. Could someone please…
Timeline Chart Date Range based on Line Items
When you create a Timeline Chart you can set the time range (Axis Start and End Dates) for the display however this can only be entered manually and is not linked to any underlying data. I would like to be able to link this Axis Date Range to date formatted line items in a module in the same way that the bars start and end…
How to restrict access on line item which is list format
Hi , I have a module with number list as dimension and Country as line item . I want to restrict access of country to users (Cant use Selective access ) .For example ,one user has access to 2 countries ,then that user should see only 2 countries in drop down and should not see other countries if user from other country has…
Getting Invalid error in Logic
IF 'Headcount Capacity 2' 'Seatings.Less than 50 seats' THEN 'S' ELSE IF 'Headcount Capacity 2' 'Seatings.50-200 seats' THEN 'M' ELSE IF 'Headcount Capacity 2' 'Seatings.201 - 500 seats' THEN 'L' ELSE IF 'Headcount Capacity 2' 'Seatings.More than 501 seats' THEN 'XL' ELSE 'Headcount Capacity 2' This is refernce to…
IsLastOccurrence
We have Native IsFirstOccurrence functionality which helps us in a number of ways while modelling. I think having IsLastOccurrence will also be equally helpful in Anaplan.
Forward Weeks of Cover or Forward Weeks of Supply
Thought I would post this here as a method to calculate Forward Cover or Forward Weeks of Supply. A year ago @AnaplanIdeas posted an idea for this which is great. I'd like to expand on this idea and also incorporate @nathan_rudman backward-looking suggestion. Summary: In the supply chain horizontal you may be asked to…
Data Import from excel
How do I import an excel data grid with no unique ID and no unique combination of property? Note: Customer is looking for keeping anaplan as system of records and wish to generate a unique ID within Anaplan, but key thing is it has to be a import/ not insert using dashboard. Thanks Arun
Insert Line items – Format settings
The reason behind the ask is because Anaplan is not letting the model builder even to add dummy line items (Divider with None as a format) if the model exceeds the size as it takes the 'number' as default. I hope to resolve this concern, probably Anaplan can let the developer choose the format of the line item before…
Anaplan's New User Experience Designed for Optimal Planning
Have you heard? Anaplan’s user experience is evolving. With a laser focus on the customer journey, Anaplan's New User Experience (NUX) is designed to make users’ lives easier by helping their business to run more smoothly and catering to better planning and decision making. The NUX is currently available in the platform.…
Time Filter applies to specific month
Hi, I'm trying to create a time filter that will only ever return current month and December 2020. I've managed to create a filter for both using separate line items, struggling to combine and allow users to view. Any suggestions? Thanks.
Circular Reference when using a line item as input
I have a formula that needs to look a specific number of months back. The formula works when I type in the number of months as a hard code in the formula, but not when a use an line item containing the number of months. A screenshot is below. The Maturing Balance formula works. The Retained formula is the Maturing Balance…
Level 1 Model Building : Margin and Margin % in Rep02 Size Margin Report
Hello, I am reviewing REP02 Size Margin Report and having issues. The Margin and Margin % are not populating. Is there a reason this would be happening. Is it not supposed to populate? I have put in the formulas and the sums properly (see attached image).
Custom Time Dimension / Supply Planning on a daily basis
Hi, For a client of us we're looking into setting up a Supply Planning model where planners have the ability to plan with a telescopic view. Meaning they're able to simultaneously plan on a daily & weekly basis. Ideally we would work with the standard time but as weekends can not be taken into account we're looking into…
Sum Transactions Based on Properties Between Two Dates (Days, Weeks, Months)
An often requested output of a trade promotions use case is to understand sales between two specific dates— be it days, weeks, or months. The solution below has one dimension in it but would work equally well with additional dimensions, such as customer or supplier. Having loaded in the transaction detail following this…
Last Occurence
If line item is list formatted and if list item choosen is repeating , then how to get the last ocurrence of every list item?

Modeling

Discussion List