-
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
-
Summary Default to None for Numeric Line Items
Can the default Summary for numeric line items be None rather than Sum. This way it's a conscious action to turn the sum on, rather than a need to remember to turn them off. I know there's another post to have this an option that can be set by each module, which would be advanced, but I continue to hear about sums being…
-
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…
-
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…
-
Show all references (full chain) from a line item in the model map
I would like to visualise a calculation reference chain from a line item as a starting point using the model map. This will help in maintainability of the model and in the ability to refactor model design or calculations.
-
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
-
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…
-
Save user roles globally across models
I have a couple of common user types that I always create for every module. It would be useful if these could be saved as default choices and used across all models in the workspace.
-
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.
-
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…
-
Re-Order Conditional Formatting Rules
Hi Anaplan, When you have multiple conditional formatting rules or you create a new conditional formatting rule you currently cannot re-order the conditional formatting rules. This can make it difficult when reviewing conditional formatting rules to understand what you have defined. It would be great if you could re-order…
-
Ability to view a module side-by-side with it's Blueprint mode
When model building I find myself regularly want to see a module AND it's blueprint mode simultaneously so I can scan formulas, change things in blueprint, and immediately see the effects without having to toggle back and forth. This would be like using split screen in Excel to compare two workbooks side-by-side Toggling…
-
Format checker
I want Anaplan to check if the FORMAT of my line item correspond the the formula i'm entering BEFORE starting the calculation and if the format doesn't match the expected result, i want Anaplan to hold the calculation until i can change the format to match the formula results.
-
Copy/Import Line Item Formats
To provide self-service modeling we need to allow users to not only add new line items to a module but also to change/update the formats. It would be nice to be able to import line item formats as well. Line items can be imported but then only a model builder can change/set the format. For example: I want to give my users…
-
Extend Date format to include Time (hh-mm-ss)
Description: Being an Anaplan Builder, I would like to be able to have a date format with Time in it (hh-mm-hh) Some of our planning tasks are connected with work with exact timing (Date + Time). Currently, we have to upload this data as text and use RIGHT(),MID(),LEFT() functions to extract values. If we have a customized…
-
Defaulting values for line-items (vs. modeling via override)
Abilty to have by default a 100% value in a line-item vs. modeling this behaviour with a line item of 100 and putting an override if you do not want 100% (e.g. redemption rates). The default should be able to have a formula behind it. (cfr STET functiona in competitive products) Benefits : 1) Huge UX improvement on…
-
Applies To for a module - would be nice to have a search option
Description of the enhancement required: Creating Modules or adjusting the "Applies To" it would be helpful to have a search bar/button. A story for why they want the enhancement, (how would it help their business process): In case you have a lot of lists, it becomes very inconvenient to reapply the module. This change…
-
Display the Action IDs in Actions list
Description of the enhancement required: Display the Action's IDs in Actions list so that Interface (Anaplan Connect or Rest API) can work with action's IDs (not with captions (Action Names)) A story for why they want the enhancement, (how would it help their business process): At the moment, to refer an action by ID we…
-
Increase the limit of characters in Notes section
HI Team, It would be really helpful, if we can increase the limit of characters in Notes section of a module. Currently it has 250 as a limit. I got stuck here when I tried to copy paste one lengthy formula cos I don't want delete the formula instead I might take that for my future reference. Let me know others thoughts on…
-
Ability to sort the order of views on a module using Ascending or descending options
Currently when you click Manage Views on a Module you can move a view up or down to change its order. It would be easier if we could have the option to sort in the same way for other objects with an ascending and descending order option or a top or bottom option. In addition you can only move a view once in either an up or…
-
SUMPRODUCT function
Analogue of SUMPRODUCT function in Excel
-
FIND list items by property value
Currently you're only able to use systm properties: Name and Code to identify List elements. Please add an optional argument in a FIND functions that would allow to use any single exact property in the selected list as a reference.
-
Code property
ITEM is not an occupied system property while CODE is. This makes the formulas ITEM and CODE not equivalent and thus inconsistent for Anaplan modelers. Since CODE() and ITEM() are very similar formulas, it would be nice to make their syntax similar. The practice that we use to keep formulas simple is creating “item”…