-
Filtering of subset based Module based on full list
If a module is based on a subset I would like to have opportunity to able to filter it based on the other modules which are applied to original lists. currently i need to create a new line item which will be applicable to that specific subset. an example of application is a dummy timescale (which contains for example 7…
-
Allow Multiple layers of Conditional formatting with more flexible color options
Let conditional formatting options be stackable in layers (similar to MS Excel). In my current model we have a table that uses color across all cells based on the development stage. At times we also want to color cells that have an error to a particular color of red, however this is not possible without stackable…
-
Ignore Timescale as a dimension if Time formatted mapping line item is used for aggregation
I ran into the issue when I needed to pull the data from the module with a timescale as a one of dimensions to another module that also contains timescale as dimension. I used time formatted line item in the source module for aggregation but it's been ignored in the Result module and error message box has been appeared.…
-
Display Hierarchy Codes against parent nodes in line item
When creating a module with a hierarchy dimension, if the code is used as a line item, the code will display as blank for higher level nodes in the hierarchy. This is not the case in the list screen for example and is very disappointing for business users used to other tools who do not like the workaround of including the…
-
Alert Model Builders of Incorrect Formulas/References Prior to Testing
Description: As a model builder, there are plenty of times where formulas or references to other modules are incorrect either by mistake/typo or due to lack of understanding formula syntax. Based on our model size, we have to allow ample time for Anaplan to return the error summary, even in test models. It would be great…
-
Increase the character limit of the MAILTO function
The MAILTO function currently has a limit of around 2000 characters and any greater than this will prevent the message from being opened in your chosen mail app. This is normally fine for standard English alphabetic characters, but can cause issues for non-English alphabetic characters. For example the Japanese character キ…
-
The ability to see entire Note, Applies to, Referenced By fields inside blueprint view
It would be great ot see the entire Note section in the blueprint view without having to copy and paste it into another tool, double click into the note section, etc. Double clicking into the note section isn't ideal in Standard (Non-Deployed) models, as it can lead to the accidental editing/deletion of the note field. One…
-
PROPER() Functionality
When we are dealing with Text formats in Anaplan it is case sensitive and it throws unexpected results if we don't do it exactly the way it should be. Although we can achieve this by amalgamation of LOWER, UPPER, FIND, LEFT & RIGHT functions. Having PROPER function would greatly reduce the need to do so.
-
Ignore Value Parameter for MIN Function
When using a minimum function, it would be ideal if we could exclude specific values, or a list of values, to avoid returning zeros or another value. For the aggregation function x[MIN:y] you may want to exclude zeros from the formula. Currently the workaround is to use a large number in place of zeros, eg: "IF x = 0 then…
-
As a builder, I need to implement more advanced workflows
Description: Would be great to add workflow functionality that includes * Submission and approval workflows * Trigger an event on an action or on approval * Use workflow status in formulas
-
Allow for users to breakback on time and not other hierarchies
I have a customer who wants to use breakback for time but not the other hierarchies in the module. They are planning for cost centers and require users to enter data at the lowest level. However, they want to enter data for annual periods and break back to the months. If we can separate the other hierarchies from time,…
-
Set Display Name in Line Item Subsets
I would like the ability to (optionally) set a separate Display Name for line items in Line Item Subsets. Whenever the Line Item Subset is used, this Display Name should show instead of the original names of the included line items. This would be really useful when collecting line items from multiple modules, especially…
-
Ability to create Version subsets allowing to have many different versions without impacting size
Hi Anaplan, As Anaplan grows users will require to create multiple versions allowing them to look at historical information without creating many archived models. The solution to this is to have many versions and be able to subset version lists, therefore saving on space and being able to view historical information…
-
Show Subsets in the General List area in settings under the List they belong to
I would love to see the subsets created under the list they belong to in the General List area in settings. It would make using them and maintaining them easier. And, when learning new models, it's really hard to tell the difference b/n a subset and a list and to what list the subset belongs to.
-
Improve FINDITEM() when used with Time
Similar to improving imports with time periods (Idea Link), it would be great if the FINDITEM() formula was tweaked when working with Time, to make the formula return time periods for strings like Jan-20. Reason for asking (lifted from my previous post in the Idea Link): The standard excel format for Month-Year is MMM-YY.…
-
Ability to drag and drop an Import action in a Process
Hi Team, It would be really good if we have a Drag and Drop feature of an Import action (in addition to Up and Down arrows) in Edit --> Process. For instance, if a Process has more than 40+ Import actions, then it would be difficult to move a newly added import action/ an existing action to the 22nd place. Thanks Sathya
-
Numbered lists to add display name by default
I think it would save a lot of time during initial model setup if the following actions happened when a model builder checks Numbered List within the general lists panel. * New property within checked list created called Display Name. * Display Name property format set to text. * (Potential) Set Display Name property…
-
Allow semi colon as a delimiter for emails as this is the default in outlook
As a user I should not have to configure Outlook to use commas as a delimiter for sending to multiple recipients as this option is not checked by default. The MAILTO function in Anaplan only accepts commas as separators for multiple email addresses. It would be useful if it also accepted semicolons.
-
Adjust Column Widths in Blueprint Mode
Being able to adjust column widths in Blueprint mode would be great. Rather than having to open an 'Applies to' menu, format menu, or copy and paste notes, and formula references, it would be great to adjust column widths in the blueprint mode. Alternatively, it would be helpful to have a "view" window or cell (similar to…
-
Introduce sequential lists (Array or Linked list)
As model builder I would like to make use of sequential lists (Array or Linked list) to avoid circular references. This can be useful in many calculations.. Native functions like PREVIOUS() or NEXT() could only be applied on line items which are on the time dimension. Such functions should then also work for the sequential…