-
Ability to exclude zero values from AVERAGE calculation
A common requirement we see on customer implementations is to be able to calculate the average of a set of values but exclude zero values. For example if we have the following set of values (10,0,0,8,0), the average excluding zeros would be (10+8)/2 = 9. The current AVERAGE function cannot exclude zeroes and so gives an…
-
Time Ranges Notes
I would like to have Notes available to be able to record comments against a Time Range so as to give more clarity as to what the Time Range is used for and whether it needs to be rolled forward at a Year End as in some cases there may be no need to change the start year of the time range for instance but without knowledge…
-
Automatically re-open modules after a session timed out
Hello All, As a new model builder I have experienced some frustration with tracing back where I was at if my session times out. This is especially true during the development stages and the solution is moving fairly dynamically and several developers are working on it. It would be a nice improvement if Anaplan could cache…
-
Increase the size limit of notes
A description of the enhancement required: The notes on line items is 250 characters which isn’t enough. A story for why the enhancement is required (specifically, how would it aid the business process): When you write a note on a formula, you have to explain WHAT is does, WHY you did it, HOW it’s used etc etc, 250 isn’t…
-
Add a tab for saved module views in Model Settings -> Modules
Description of enhancement: To add List of modules' views in the Model Settings menu. It would be great if it can include: View name Model name Actions’ names then view is used as a source Dashboards where used An example of the enhancement: It may be very similar with the Modules list. A story for why they want the…
-
Ability to copy a process
It would be nice to have the possibility to copy a process. This will save some time when developing, because you can easily amend a simular process instead of collecting all actions again.
-
FEATURE REQUEST: Universal List that can be used in all Models
Currently, the process to use same list across different models is a complicated process of importing lists from one model to another. If Anaplan really plans to be the a Connected Planning tool, they should have a feature of having a Universal List that can be used across all models without doing import. I am proposing…
-
Ability to add folder structure in model management
Description of the enhancement required: Create folders and keep the models in various folders How would it help their business process: We have about 15 modellers working on different models. Wed like to be able to organise them better. Sometimes we might forget the names of models they are creating. In windows, they can…
-
List cell "Contains" Typeahead
Description of enhancement: List cell input typeahead to work by "contains" typed text, not "starts with" (or make this a setting in blueprint format options). Example: The test list contained regions EMEA, APJ and NOAM. There's a list formatted line item in the module and if I type in the letter A, user wants all the 3…
-
Ability to group actions by functional area
Description of the enhancement required: Create Directory/Grouping functionality for grouping Actions An example of the enhancement: Actions would be able to be grouped by function/area, similar to functional areas. How would it help you business process: I currently need to make a fake action to create a line in actions…
-
Automatic ordering of dimensions within modules/line items
Description of enhancement: When re-dimensioning a module/line item by using the applies to dialogue box, it would be very useful if the order of the "applies to" was automatically ordered from the largest to the smallest. Business case for wanting this enhancement: Consistency of the dimension orders has a big impact of…
-
Custom groupings - As an admin I want to organise my model objects, such as lists, into groups
Similar to functional areas for modules, but allow admin to easily create custom groupings and assign objects to them, so that their settings objects are organized. This should be included everywhere we currently have 'Re-order', as it will need to be incorporated. For example, set of line items for UI data, calculations,…
-
ITEM function cannot be used on composite lists with Summary of "Formula"
To reproduce: 1. Create a parent list and a composite child list. 2. Create a module with 1 line item with formula "ITEM(Child List)" and list formatted to "Child List". Applies To should be "Child List". 3. Change Summary to "Formula", the following error is shown: The formula for 'mod1'.'item1' is invalid: 'item1' =…
-
Allow for line item subset to be more than just number formatted
Description of the enhancement required: Line Item Subsets are often used to build filter modules, as an alternative to using the Show/Hide functionality. Using a Boolean against a Line Item Subset on a filter module makes it very easy to select which columns should be shown or hidden on a dashboard. An example of the…
-
"Edit From" and "Edit To" in "Versions" don't prohibit users from importing values to that time peri
Description of the enhancement: The RFE would be to disallow users from importing into a timescale that they cannot edit. To reproduce: 1. Create a module with "Versions" and "Time" as dimensions. 2. In "Settings"->"Versions", change the "Edit From" to "Feb 16" on the "Actual" version. 3. Back in your module on "Actual"…
-
Alias Names for Time, Versions, Modules, Line Items and Dashboards
Hi Anaplan, It would be great for Anaplan to allow users to create alias names for: time, versions, modules, dashboard, list and lineitems. Thanks, Usman
-
Increase Code character limit in List
Description of the enhancement required: Increase Code character limit which is currently max at 60 characters. An error window will appear if character limit is reached. How would it help their business process: Customers have data values that exceed 60 characters when they try to import data into their List. When they…
-
Summary Method per List
In DISCO we create CAL modules that are purely for caulations and turn Summary Method to NONE. There are though many times where to be most efficient you may want to only have the Summary method apply to one list. e.g. you want it to SUM on product only because you can then use it in an Output module which doesn't need the…
-
New Function To Convert Date Format to Text Format
It would be very useful to have this functionality rather than convert to numbers through DAY, MONTH, YEAR and back to text through TEXT function. Best practice would dictate to split these functions out but this increases clutter and causes unnecessary calculations in models.
-
Include Process Within a Process
Description of the enhancement requiredAbility to create nested processes (i.e., process within a process).An example of the enhancement:A separate process to import a saved view to separate lists that can be combined into one overall process that can be run by the end-user (one click to run multiple processes)A story for…
-
Allow the same action to run multiple times within a single process
Description of the enhancement required: Allow the same action to run multiple times within a single process How would it help your business process: There are many situations in which this would be helpful. One example Setting a production plan based on prioritising SKUs. i.e. The capacity of a production line is…
-
RANDOM() function
Function that will generate random numbers, between specified min & max values. Excel has two functions to provide random numbers: RAND() generates a decimal value between 0 and 1 RANDBETWEEN( x , y ) generates an integer >= x and <= y It may be worth considering an extension to these functions such as: RANDOM( x , y , z)…
-
September 2022 releases and October sneak peek - View Modules Used In Pages
The release this month is helpful but I think it missed expectations. What would be more helpful is to be able to see what UX pages a module is published on in the exact same way the "Used in Dashboards" column is in the Modules. The update would more or less be "View Pages Used in Modules". I used the column in the…
-
Add Folders for Modules and Lists
Similar to the idea posted here, but with this idea could be a possible solution? * Add folders to object contents (e.g. module, list, and actions). * Allow the creation of sub-folders. It goes without saying, but this would really improve model organisation, especially for larger models. The functionality could be similar…
-
More advanced Grouping, Sorting and Filtering of the lists of Modules / Dashboards / Actions etc
During Anaplan training a user creates 5 or 6 modules / dashboard etc. Easy. Our model has a staggering list of actions, modules and dashboards. In our model are we have: * 593 Modules * 248 Dashboards * 1767 Actions Model builders need a more robust wayto manage this. Having the ability to filter these lists by a type…
-
PREVIOUSITEM() formula which is like PREVIOUS() but references a list item instead of time
Hi Anaplan, I was searching for the use of the PREVIOUS function but on a list item but it is not currently possible. @peter_mcanena has suggested this but only in a discussion thread. So as his idea suggests: PREVIOUSITEM(x, y) where * x: Any expression * y: List The expression x must be based on the list y.…
-
Show calculation time directly in model
Would be very beneficial for the model builder to see the calculation time (e.g. from model open) of the individual line items with formulas. The current cell count is a great help when it comes to optimizing the model and identifying how to reduce the size hereof. However, the calculation time of the different line items…
-
Anaplan Time Range Limitation
I was very surprised recently when I discovered a limitation to Anaplan's permitted time range. It may surprise others to know that Anaplan is limited to supporting only 70 Years (20 past and 50 future) and the maximum number of years possible is 90 (using a time range set, as of writing, to 1981 with 90 periods). I did…
-
The ability to add a dynamic sub total to a grid
I would like the ability to add a dynamic subtotal to a grid, so when rows are filtered out the total is updated on the fly
-
Pivoting with more than 3 rows
Description of the enhancement required: Need to be able to pivot more than 3 rows How would it help their business process: Reporting many cases of views needed with multiple dimensions with more than 3 lists in rows. Most recent case 1) A module with many dimensions 2) Need to be imported to a flat list 3) Filtering…