-
Summary Methods Based On Line Items - Product as an example or Weighted totals
Hi All, I feel that the summary methods in Anaplan could be improved further by including more flexible options to use other line items (same dimensionality) to influence summary method. For example on a model I have been building recently, many of the summaries require the product of 2 line items divided by the total of…
-
Childs with same parent crossing in a same module
Hello all, Imagine we have a parent list Country (G1) and two child list attached to this list: Fisrt list => Regions (G2) and a second list Stores/Entities (G2 bis). We need this second list Digital Stores because for each country we may have 2 or 3 digital stores which may serve all regions of my country. For example, in…
-
Modelling from module "Line Items" view
The "Line Items" tab is a really handy view when reviewing a model and looking through multiple line items across different modules at the same time. You can currently access the formulas by double-clicking but I think the view would be so much better if you could access all the module modeling actions (i.e adding a new…
-
Formula Box Auto-Resizing/Docking/Undocking
Having the flexibility to have the formula bar in the new modeling experience expended at the top versus jump to the bottom. In addition having the ability to move the formula bar around similarly to undocking and redocking so that the window has an auto-sizing feature when you toss it to the edges of your screen or…
-
New Modelling Experience Button Turns OFF in normal browsing mode of Google Chrome and MS Edge
The New Modelling Experience Button/Switch/Toggle turns off automatically if a user logs out and logs in again. This behaviour has been recorded in Normal Browsing Mode of Chrome & MS Edge. However, it does not seem to happen in Incognito Mode.
-
User List in a module only assigns space to users who have access to the module
I think it would be a good idea if the user list would only create space for the users who are in a group with access to the module. In a scenario where a set of super users need to do their own variance analysis that involves lots of calculations, having all of the users who also don't have access to the module will lead…
-
New UX: Dynamic grid update based on filter settings
As a model builder I want to be able to setup a Grid which will be updated dynamically every time after a user wants to reselect any line item published as Field or Grid which are used as filters, but without the necessity of reloading the page. Current behaviour allows to have the same effect, but only if the User list is…
-
Totals position for formatted list items
It would be very useful to be able to adjust the behaviour of the totals when displaying a list formatted item. Within a module one can control where the parents appear; it would be good to give this option for list formatted items too. It is possible to "create" this behaviour using dependent drop downs or by activating…
-
Add Show Imports/Show Targets to Modules
Please allow model builders to view, from the current module, a list of all of the imports to the current module and a list of all of the targets (i.e. imports that use the current module as an import data source). The current process of resolving import issues from a module is tedious - from the current module a model…
-
Erlang A
From a callcenter planning perspective we currently have Erlang B and Erlang C, which allow customers to compute the SLA given an amount of calls and their staffing level. The industry is starting to look more at the amount of calls answered as a percentage of total calls (TCA) as a way to determine staffing. In order to…
-
Ability to define line item 'applies to' when adding that line item to a module
As a model builder, I would like the ability to define the 'applies to' of a line item when creating and adding it to a module. This enhancement could work by enriching the current box for adding line items and allowing users to set the applies to at this point The benefit of this would be the ability to add line items…
-
Disable 'Is Summary' by Default
Please can 'Is Summary' be disabled by default and require model builders to enable the setting. With the recent update to the blueprint view, this setting has become more hidden.
-
Option for setting standard totals positions on rows
Totals position on rows defaults to "after" for each new module. Would be good if one can set the default on model level.
-
Remove ability to edit Formula column on Line Items in Blueprint Mode
I've always been told as best practice to not edit formulas for line items directly in the formula column of blueprint view, instead to click on the line item and then activate the formula bar on the top of the page. However, we recently had a new model builder, who had not yet heard about this best practice, copy and…
-
Closing/Opening Balance Summary Method for Booleans
Simple request, please can closing balance and opening balance time summaries be made available to boolean formatted line items.
-
Ranges/allowable values for number input
It would be handy to restrict a number format. This will save additional validation checks/visualizations. e.g: - Number needs to be positive - Number should be an integer -The number should be within the range of 0-10 This is like a dependent drop-down list, however now restricting the number formatted input.
-
FIRSTNONBLANK() as a Function
Add a "FIRSTNONBLANK()" function that will evaluate each of the arguments and return the first one that is not blank. This would allow for formulas like the following to be greatly simplified and potentially better performing: Example 1: IF ISNOTBLANK( line item A) THEN line item A ELSE IF ISNOTBLANK( line item B) THEN…
-
Option to disable the model map
Description of the enhancement required: Please provide an option to disable the model map. An example of the enhancement: In the Settings tab, there would be a section for User Preferences, which would allow me to turn off the Model Map. How would it help the business process: I never use the Model Map, but it gets in the…
-
Assign Action - Disable unassign
Assign Action dialog window allows end users to assign new elements, but also to remove already assigned elements. In some scenarios it is not desired, as modelers are no in control here (we cannot put any validation if an element can be removed / unassigned). The idea is to add a configuration option (Boolean) to allow…
-
Usage of Lookup on Users
As we all know, We are not able to use Users formatted line item in Lookup to get particular user data. Can we have option to do the lookup on user formatted line item? It will help us creating consolidated dashboards on what-if scenarios by user dimensions.
-
Indication in blue print if a Line Item is used as DCA
There should be a column in blue print view of a module like "Referenced By" highlighting modules where a line item is used as a DCA
-
Sort Module Overview in Settings by Cell Count
I was wondering if it is possible to sort the modules by their cell count in the settings. At the moment there is only the possibility to export the model overview and then sort it in Excel for example. This extra step would be saved by having a built-in sorting function. For me it is important to sort the modules by their…
-
To be able to use an action to change the order of items in a list
Description of the enhancement required: To be able to use an action to change the order of items in a list. An example of the enhancement: I have a list, FRED, which is populated from a SQL query containing an ORDER BY clause. However, new items are always inserted at the end of the list (or rather, at the end of the…
-
Copy model from point in history
Description: Take a copy of the model from a point in history, based on the model History ID. Impact: This would allow investigation and audit of production models without affecting the source model. But there could be concern about this affecting storage, if people begin to create more copies. Example of enhancement: I…
-
Move Format column to before Formula column in Blueprint mode
Description of the enhancement required: I would like to submit an enhancement request in regard to the Blueprint Mode of modules. I would like to move the format column before the formula column. An example of the enhancement: When you are creating new line items in Blueprint mode, the first column that you see from left…
-
Sorting items by code or name in number lists
Description of the enhancement: New items are added at the bottom of a list or at the bottom of a node when there is a Parent. How this enhancement will improve you processes: Re-ordering or sorting a list is a one-by-one manual operation that can be time consuming.
-
Drill Down View Enhancements
Drill downs in Anaplan Modules should have a feature for checking what each part of the formula written does. For example if there is a If condition with a nested loop with multiple formulas and conditions in it, then there should be a provision to select what each condition does regardless of the condition being True or…
-
Hide items on the model map
As we put headings as empty modules, these then appear on the model map. Could we not include zero cell modules on the model map, or give the builder the ability to exclude.
-
LastUpdate Function to retrieve timestamp of Data entry
We need a function which can give us timestamp on last data entry for a specific cell. This will help us to compare that time stamp with our custom date in some specific use cases. example: Todays Date: Line item to capture today's date via daily data refresh Order Date : User entry Line Item Time(Day) formatted Ordered…
-
Allowing Time Sum function to accept 1st argument a function
I would like to ask if you may give timesum function ability to accept other function within timesum parentheses [ex: Timesum(previous(revenue),start period, end period)]. The main reason I asked this, I would like to calculate the average 3 month based on previous figure. [Excel example] In meantime, I would also like to…