-
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…
-
update source model default
In the model settings -> Source Models you are able to edit a mapping and change the source to e.g. the production model rather then the development model. For some of our models we have recreated multiple development models (copy of production) this resulted that as source model there are a lot of non existing models…
-
Formula Bar Changes Color When It Is Active
It would be helpful if the formula bar changed color when it is active. As an indicator, This could help people avoid clicking around on different line items and entering in incorrect formulas. See the screenshot below as an indicator of what this could look like.
-
VARIANCE command
When we define an item we can set the number Format to Numeric and tag if an "Increase in Value" is Good/Bad/Neutral. Why do we not have a VARIANCE function to utilise that increase in value indicator? So if we have three different Versions ("Actual", "Budget" and "Actual vs Budget" and 1 item called "Sales" (with an…
-
Day time period format
We currently cannot have Daily as a Time Period format for a line item Use Case: Mapping from a fake daily timescale to Real time. Issue: Currently we have to use a date formatted line item and to map from a Fake Daily timescale in the format 1 Jan 2019 to a date requires a lot of text and string manipulation
-
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…
-
Is there a way to set a numerical goal and track its progress throughout the quarter on a Dashboard?
I am looking for a way to communicate a sales goal by product and channel on a monthly basis. Please let me know if you have any ideas, Thanks!
-
Please fix opening a menu from the drill-down view (i.e. to open the source module)
Hi, Currently, if you drill down through several layers of modules and try to open the menu of a module to open the source module it appears as if the menu has not opened. I have learned from experience that the menu does actually appear, but seemingly in a random position further up from the drill down tabs, and floats…
-
Make the round function work as intended
Description of the enhancement required: The ROUND Function is not working as expected. An example of the enhancement: Make the ROUND Function work as intended. A story for why they want the enhancement, (how would it help their business process): It has been documented on Community…
-
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…
-
Default Settings for new Line Items, Summaries, for Model and Modules
There are two other ideas that exist already one that are by default set sums to off and another that is to set defaults by module. Why limit to just as a whole product or module, why not give a default for builders or similar added to the Model Setting. All models are set to default none for all summaries and line item…
-
Selective Module reordering
I often find that I want to re-order modules within functional areas, but using the ascending/descending order, re-orders all module, not just the ones selected. It would be great if the sort, could be restricted to the highlight modules The following shows how it could look Note that the other modules are not included in…
-
Restore Open Dashboards and Modules Tabs when Model is closed accidentialy (or due to login timeout)
I'd like to see an option that we re-logging into Anaplan - I can re-open my most recently used model and any correspoding tabs (dashboards, modules, etc.,) that were open. Sometimes the model is closed automatically after login time-out, other times the model is accidentially closed by selecting the Anaplan logo at the…
-
Allow OFFSET calculation in version formula
Description: Allow OFFSET to be used on summary line item formatted as Formula. Impact/Benefit: I am trying to calculate a percentage change from prior year or prior quarter at the summary level. For example, year-over-year % changes using a formula at the aggregated level: Total Growth in Net Sales / OFFSET(Net Sales, -1,…
-
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…
-
Breakback function by selected Line Item
Hi Team, It will be great to have an option to select the Line Item which will be taken as a source to calculate phasing for Breakback function. At the moment split is done based on the items, in which I input amount. Unfortunately in some business cases it's required to use another metric for phasing. This can be useful…
-
Select parent level
I would like to see a formula similar to parent but "inverted". When I have an unbalanced hierarchy and need a parent a similar level I would like to choose level from the top instead. example: invparent(item,3) which would always give the level 3 item for all parts of the list instead of trying to find our a way to get a…
-
automatic backup
It would be very good to have the possibility of executing an action or process that makes an automatic backup of the model.
-
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…
-
Customize Branch Copy Action
Branch copy is a very powerful action, widely used in what-if-scenario analysis. It can also be used to copy, for example, promotion events. The problem is, when we create a copy of a completed promotion event also the status is copied indicating that the newly copied event is also completed, which obviously is not the…
-
HyperBlock Performance Improvement: TRUE-->TRUE change
The Anaplan platform leverages a patented in-memory, Java-based, planning engine for calculation called Hyperblock", as we can read in the CIO Guide White Paper on anaplan.com. The engine allows to rapidly calculate billons of cells. It is also important to understand that it recalculates only what needs to be…
-
Defaulting filters in Assign Action Screen
Assign functionality can be used, for example, to add products to customers. But how will we make sure, that only active products will be added? We can define a filter in assign actions (we can't use Boolean as a filter, but we create a list formatted property for that purpose). The main problem is, that when we open the…
-
Performance of line items calculations with cell count 0
Anaplan platform gives to modelers great flexibility in terms of how it is used, once in a while leading to situations, where modelers design solutions, which were never considered by Anaplan Platform developers. One example like that is usage of a single element list with subset as a module dimension - to turn on or…
-
In blueprint view, show if a line item is used in a filter
In blueprint view, we can see if a line item is referenced by a formula, but not if it's used in a filter. When cleaning models, we can end up deleting items used in filters and breaking filters with no warning.
-
Provide model builders a "Model Cleanup View"
Our model is rather large, and over multiple development cycles and many different developers we have a large amount pieces of the model that may now be obsolete. The trouble is with a large model it is incredibly cumbersome to locate safely remove clutter without the fear of causing major issues in the model. The only way…
-
ACTUALVERSION()
We currently have the functionality to retrieve the values from the Current Version using CURRENTVERSION() Please can we have ACTUALVERSION() to do the same for the Actual Version This provides consistency and will simplify the modelling experience David
-
Provision to input code while inserting elements into a list
While inserting a elements into the list, currently the UI only accepts the name, not the code. Can you please make Code and Name available while inserting elements into the list.
-
Quick way to open referenced Line Item or List Property
It would be great to have a quick way to open a referenced Line Item or List Property from an existing formula. It can be very tedious & time consuming to hunt through the modules & lists, then again through the line items & properties to locate the reference, especially when there are multiple levels of references to…
-
Create Function for ADDWEEKS
Please could we have ADDWEEKS as a function to work the same as ADDMONTHS and ADDYEARS the current workaround is to convert the weekly time period into a date then add or subtract 7