Modeling

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?
Dependent dropdown
I have one dimension "Employee" and want to assign two products A and B. Product A and Product B are two line items formatted as Product List. It is perfectly fine if employee is assigned the first product however, when the employee is assigned product B, then product A should not be visible in the dropdown as the employee…
Enter Saved View on Saved View Creation/Save
When creating saved views, it would be great if Anaplan enters the saved view immediately after creation. Currently, anaplan returns to the default view of the module. This can be a bit annoying if you need to make a quick change to the view, such as adding a filter or showing/hiding columns.
Date Conversion
Hi Guys, I have a simple one to ask. I am loading a Period with a Text format to a Year and Month with a Number format. Example: I loaded a date of Jan 13 to a Period column. Then I need to convert it to Month 1 and Year 2013. I tried loading it as Time period which is the right way but for some reason it is not loading…
Variance Analysis between versions without using select
Hi, I am trying to create a variance Analysis for users so they can compare price & volume between to Anaplan versions (i.e Budget & Forecast, Budget & Actuals). This idea is for user to select Version 1 and Version 2 to decide which versions they want to compare. Similar to: Select V1 : XX (i.e Budget) Select V2: YY (i.e…
Set default file to everyone
Would be really handy if Anaplan did either one of the following actions for import data sources: * Set the default file type as everyone or; * Permanently saves files regardless of default file type selected. This would really assist in debugging and remapping import files.
How to calculate cumulative results
Hi,everyone. I would like to calculate the cumulative result of a line item. I think I should use the TIMESUM function, but I don't understand how to use it. I want to get the cumulative result from the date of FROM to the date of TO. Could you tell me the best solution? Best regards. Taku

Modeling

Discussion List