-
Allow un-balanced hierarchies on composite hierarchies for child hierarchies
As a model builder, I would like to be able to add "parent" elements into the child hierarchies (Level 2, 3, etc.). As for now, in a child hierarchy is allowed only to add leaves elements (elements without children) because as "parent" are allowed to be set only elements from the parent hierarchy. As for now, the unbalance…
-
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…
-
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
-
Add 'Does Not Contain' as condition when performing a filter on a text formatted line item
Many of our users would find it helpful if when filtering on text formatted line items, there was the option to use 'Does Not Contain'. There is a 'Contains' condition, which has proved helpful, however a 'Does Not Contain' would also provide a lot of value.
-
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…
-
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.
-
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!
-
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…
-
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.
-
Dependent dropdown - Based on line items
HI Team, Just realized that the dependent dropdown will work only based on the property that the list has. As we are following the best practice not to create properties in a list, can we make the dependent dropdown based on line items. Agree/Disagree or Any comments? Regards, Kavin.
-
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…
-
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…
-
Merged: Ability to Enable / Disable a button based on a formula
This discussion has been merged.
-
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…
-
Use Time Ranges in formulas: Make the Time Range a named member in the Time Dimension
If Time Ranges were true named member in the TIME dimensions we could easily control formulas and filters based on a time range. It would also allow for YoY changes in formulas to be maintained easily w/o having to create multiple line items. Many companies need to save off older versions for compliance reasons. Adding the…
-
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…
-
Formula Error Log
As a model builder and workspace admin, formula errors can be costly. My idea is to add an error log that tracks formula and calculation errors. This will help document who was doing what when something goes wrong. It will also help with enablement as you can review the error log and use it for training - ensuring that the…
-
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
-
Formula to pull dates from History log - Cell Updates
Hi! I would like to be able to pull information about the date/time when a cell is update. Example: If I tick a Boolean field called Final Position to mark a deal as ready to be contracted, I'd like to have an associated Final Position Date automatically fill in with the date that this cell for the deal was ticked
-
breakback when using average
consider adding ability to use breakback when the summary method is set to average (number entered into the summary period is entered into each of the lower time members). seems like a no brainer. would be used a lot for many % line items that are used in modules. thanks.
-
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
-
Dynamic List Management Access
Being an Anaplan user, I would like to dynamically set list management access without admin license. Similarly to WorkFlow and DCA, it would be great to have an ability to dynamically limit add/delete/copy actions on the list for the users, who have write access to it. As per now, taking, for example, Workflow: Imagine we…
-
Create export with all Saved Views in Model
It would be really useful if there was a way to export all Saved Views present in a model - currently, they can be viewed in the Contents Panel on the left side of the Anaplan window, but text can not be copied from that section. There is also the Contents area of the Model Settings that is able to be copied and has an…
-
Using LOOKUP and SUM with Formula summary method
A detailed description of the enhancement that is being requested. We would like to request an enhancement that would allow to use LOOKUP and SUM with Formula summary method. Currently Anaplan doesn’t allow to do so, although in many cases it is needed and doesn’t break the math. If available, could you please provide a…
-
Add to Line Item Subset Items from different modules with the same Name
Being an Anaplan builder, I would like to pick line items with same name, but from different modules into one Line Item Subset. The behavior of items in LI SS in that way will be like in numbered list. Benefits: preparing reports, combined across big number of similar metric without creating and fake Line Item SS and…
-
Increase in more than 1 million times for Breakback line items
Proposal : Increase in more than 1 million times for Break-back line items Benefits : perform large inputs in break-back for initially very small, but non-zero values, excluding the step of force zeroing values by each cell before break-back.