-
How to create a comparative analysis model using lists?
Hi Anaplanners, I was looking into ways to create a model that allows end user to perform whatif analysis and compare the results (end user can choose multiple scenarios to compare). The user can select which version to compared via a list (list may contain members: Budget, Forecast, Forecast 1, Forecast 2, Forecast 3). Is…
-
Formula Summary
I have data formulas like this. How do you change SUM to Formula in summary. So Growth Calculate on Summary Level its wrong.
-
Quick verification of ongoing model health
My client is asking what checks their maintenance team can do to evaluate model health. I've come up with this list, am I missing anything? * Can you log into the model? (verify SSO functions and that the model loads) * Model load time and responsiveness (request model health report from CSBP) * Are users active in the…
-
LOOKUP does not work on list parents and only leaf items
When a LOOKUP is done on a parent item in a module, the result does not resolve to the column with that respective parent. Subsequently the value shows 0. To reproduce: 1. Create list with leaf item and parent 2. Create module with column 1 as "Data", column 2 as "Parent", and column 3 as "Lookup", using list from 1. as…
-
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…