-
Add a custom formula for summary that doesn't necessarily apply to rest of cells in that line item
Description of the enhancement required: The ability to add a customized formula for the summary that does not necessarily apply to the rest of the rows within that line item (currently the formula for the line item becomes the formula for the summary if you are to select the "Formula" summary option). How would it help…
-
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…
-
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…
-
Create a "Date Last Modified" column in Modules to let Admins see when line items were last changed
I would like the ability to interrogate when a Module has received changes to specific line items to help in troubleshooting bugs. For example, when someone changes a line item's summary type, or formular, or data type, or name etc. this should ideally change the "Date Last Modified" for that line item. I could see this…
-
An NPV formula that calculates as Excel's does
Description: To have an NPV formula function that calculates NPV exactly as Excel's period-based NPV formula does. Benefit/impact: Current NPV formula returns results as Excel's XNPV formula does (using elapsed days instead of periods). We are in a position of having prospective customers and existing customers use…
-
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…
-
Attribute Module for Inbuilt Users List
Suppose I have a module with Inbuilt Users list as a dimension (No other list should be used as a dimension in that module). Now if I can create a line item which will pull the attributes from Users Command of Anaplan into this module. Just click and refer. For example If I want to see what is the model role of the User I…
-
Add Automated Line Item Reference if a Field is used in an Import/Export action
It would be extremely beneficial and time saving if you could add a reference to a line item that states if it is being used in any import or export action and what that action is. This would be similar to if a line item is used in another line item or module.
-
Bulk Copy in Versions through Actions
Hi Team, We get request from customers where they have multiple versions of Budget like maintaining it quarterly. Like Budget should be open like * Budget V1 : Jan Onwards * Budget V2: April Onwards * Budget V3: July Onwards * Budget V4: Oct Onwards However, When we switch between the versions we should be able to copy 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…
-
Make Users List import available for Deployed Mode Models
Description of the enhancement required: It should work in the same way as for Standard model, could you please make available Users List import for Deployed Mode Models? Currently user access settings can be amended manually only. A story for why they want the enhancement: We have one list which includes 10596 items. This…
-
nth occurrence text function - finds nth time a character occurs in a string
I would like the ability to use a function that allows me to search for the nth time a character or string of characters occurs in a concatenated key. Currently, we import text string keys from source systems and derive business information from these strings. For instance, we might have the transaction key…
-
Import into new User subsets
Super excited about User Subsets. However, we will need the ability to import into the user subset to make it useful. Another potential workaround would be the ability to use roles to auto populate the subset.
-
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…
-
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.
-
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…
-
Applying DISCO labels to Model Map
I would like to apply the DISCO-methodology to the Model Map. The most efficient way would be to label the Functional Areas to the DISCO. The model map could then be visually sequenced based on the DISCO steps: https://us.v-cdn.net/6037036/img/PLANS_DISCO_33530.jpg?small?v=1.0&px=200 This could improve the value of the…
-
TEXT function to have the option to convert the displayed format
Description of the enhancement: Currently using the TEXT function it will convert the underlying number. For example, if you have: Line Item 1: Number format, set it to 5 decimals - value: 0.0000005 Line Item 2: Text format, Formula: TEXT(Line Item 1) Result: 5-E07 Desired Result (in TEXT FORMAT): 0.0000005
-
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…
-
Add back the 'Used in Dashboards' reference for Modules (with NUX)
With the NUX in place and being the standard for dashboarding, it would be good to have the ‘Used in Dashboard’ reference working again within the Model. This would be good for the transparency/auditibility of the model, for all users. With the Classic UX, it was easy to see when a Module was used in any of the Dashboards.…
-
September 2022 releases and October sneak peek - View Modules Used In Pages
The release this month is helpful but I think it missed expectations. What would be more helpful is to be able to see what UX pages a module is published on in the exact same way the "Used in Dashboards" column is in the Modules. The update would more or less be "View Pages Used in Modules". I used the column in the…
-
NMX - Make it easier to enter edit mode when opening the new formula editor
Now that the New Modeling Experience (NMX) has launched the 'preview mode' functionality whilst working with a formula, users have to explicitly click the 'Edit' button to be able to edit the formula. This idea is requesting the ability to enter edit mode more quickly with the new formula editor open in preview mode (for…
-
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…
-
Enhancement to RANK function when dealing with tied rankings
It would be really useful for certain cases if the RANK function could generate a sequential output when dealing with tied data. Currently, the RANK function can deal with tied entries in 4 ways, MAXIMUM, MINIMUM, AVERAGE and SEQUENTIAL and all handle tied data in a slightly different way but do not generate an output in…
-
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.
-
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.