-
Bulk Copy Action - Line Item Input
Great addition this past weekend with the Bulk Copy Action so that it can be tied to a process. As another enhancement to this feature - it would be great if the model builder can set line item values to drive the input - similar to the update current period action released prior.
-
Monte Carlo Simulations
Monte Carlo method is an algorithmic technique used to understand the impact of the variability of a set of drivers in a forecasting model, using a probabilistic approach. It is widely used in environments where the number of drivers involved and their volatility is high and documented, especially in market finance. It…
-
Add MEDIAN Function to Anaplan
As we expand our use cases within our org, we are faced with more and more times that we need to calculate a Median within a data set (ex. Revenue, Median Deal Value, Median Salary, etc.). There is a quite elaborate workaround that is posted on the community, which has been a lifesaver, but it takes up to 13 line items to…
-
Subset of Versions
Can we have a subset of Versions so that whenever needed, we can use single version member in the modules? Currently I can think of one use case when we have to drive opening & closing of periods for users to enable data entry only for a specifically opened period or set of periods. There may be better use cases as well…
-
Function to Count Booleans
There are occasions in a model where I want to count the number of True or False boolean values. Currently the only way to achieve this is to have another line item with an IF THEN function to create a 1 or 0 and then sum the line item. It would be great to have a function to do this automatically.
-
New Line Item Text Format Type - SmallText
First, I would like to address that I do not know how the back end of Anaplan is built, so I am unsure as to the possibility or ease of implementation of this idea. The idea is taking a concept from SQL Server. SQL Server has the following data types for storing integer values: bigint, int, smallint, and tinyint. The below…
-
Allow ISFIRSTOCCURRENCE to search against time
IFO returns true for the first occurence of a value against a specific list formatted dimension. i would like the possibility to validate against the time dimension as well.
-
An Anaplan Hash Function
There are times when a code needs to be generated in Anaplan and it would be really handy if we could use a simple hash function to do this (especially as Anaplan's code limit is 60 characters). The Hash function could be a simple one that allows input of text and generates a code limited to 60 characters or less. it might…
-
List subset from formula
I'd love to have the ability to create a list subset from a formula. That would give a great way to pre-filter and limit sparsity in modules.
-
Time Subsets
We would like the ability to create time subsets for more granular time ranges (days, weeks, months), that may not match the current model Time Scale of Years, Quarters, etc.
-
Enable Keyboard shortcuts in NUX
Currently, the quick search (Ctrl + Shift + S) to look for an item in a grid from the old UX is not working in the new UX. Would be great to have that working again, as our clients are using that a lot.
-
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…
-
Drag & Drop Manage Views
The current process for managing saved views for modules is a bit time consuming. If you have a lot of saved views for a module and you need to sort them out. You need to click each saved view and either click "Move Up" or "Move Down", then it would still take time for the system to refresh. So imagine if you have 10 or…
-
Breakback for line items with Boolean format
As a model developer, I want to have option to set Breakback for Boolean input line items. This would be great especially for filters, using multi-level filters based on one Boolean line item can become easier. It should work if summary is set as "Any" or "All", and Breakback is ON for the line item, then clicking on…
-
IsLastOccurrence
We have Native IsFirstOccurrence functionality which helps us in a number of ways while modelling. I think having IsLastOccurrence will also be equally helpful in Anaplan.
-
Block line items deletion when used in saved views or actions
As a model builder i need to not be able to delete any line item that is present in a saved view and / or used in an action in connected models. With the growing number of connected models and their imports between models as the connection, any line item deletion, move or renaming can result in breaking the models import…
-
Filter what appears in the dropdown for a list-formatted line item with a boolean
Current state Currently, you can filter a list using the "Selective access" and "Dependent" checkboxes when you go to the Format property of a line item, or you can create a list subset. It may happen that you want to have more control over what appears in the list than the checkboxes allow... but applying a subset comes…
-
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…
-
When Adding A New Line Item - No Data Format
I would like to request that when a new line item is added into a module, rather than defaulting the format to Number as is standard, it defaults to "No Data". Immediate ROI: - Automatically won't toast the model if you write a formula without changing the format * In another post, someone asked what do you "always forget…
-
Default number format for line item
As model builder I have to change format settings for each number-formatted line item individually when it's created. Would be nice if somewhere in the system I could setup default number format to be applied automatically when new line item is created. In example below you can see that once created a line item has the…
-
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…
-
Ability to record timestamp of input as a separate line item
It would be extremely helpful from an end-user and a workflow perspective to have the ability to capture the timestamp of a manual input as a separate line item, instead of having to look through model/cell history manually. That way you could easily see when the latest input was entered.
-
Multi-Dimensional Sorting for Hierarchical Lists
We need a way to sort hierarchical lists by multiple dimensions. Currently, Anaplan's 'Sort Order Action' for hierarchical lists only allows sorting by parent or by child, which limits our flexibility. Problem Statement:Currently, when working with hierarchical lists, the sorting functionality is limited to a single…
-
Automate/Improve Resetting Next Item Index for Lists
Problem: There is no automated or pre-emptive way to reset the “Next item index” on a list without first clearing the list. Issues Caused: When using a data hub with a large data set that is refreshed daily, we regularly exhaust the item index. This causes the import process to fail and results in refreshing of all…
-
ALM - Calculate Model Size
It would greatly improve the Anaplan ALM experience if Anaplan was able to calculate the impact to the model prior to pushing a model sync. "Completing this sync would cause your workspace to exceed its size limit" It is pretty inefficient that model builders are forced to wait to find if completing a sync would exceed a…
-
Allow filters across multiple line item formats
I need to be able to apply a filter to my line items to show any line that is blank regardless of format. Currently if I use >0 it will hide all lines with text formatting. The ability to add 2 filters for is not blank or is >0 would also be an acceptable solution
-
Setup Number summary to none by default
Today, when we create a new line item, the number format is the only to be with summary "Sum" by default. We like to have none by default as for all other formats.
-
number settings
Currently number settings can be done only at Line item level. It is cumbersome to repeat number settings across all lines in the modules in a model. Like Time and Version settings, can we have the option to set up Default Number Settings at a model level. Similarly, Rounding of numbers can be set up a default across the…
-
Deactivate Formula Scope if Versions = Not Applicable
Hi, In a module blueprint, there is a field called 'Formula Scope'. For modules where Versions = Not Applicable, using 'Formula Scope = Actual Version' or 'Formula Scope = Current Version' will nullify the calculation of any formula in a line item. This is potentially dangerous, because: 1. If there is a formula + Formula…
-
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.