-
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…
-
Alert Model Builders of Incorrect Formulas/References Prior to Testing
Description: As a model builder, there are plenty of times where formulas or references to other modules are incorrect either by mistake/typo or due to lack of understanding formula syntax. Based on our model size, we have to allow ample time for Anaplan to return the error summary, even in test models. It would be great…
-
Isfirstoccurrence - Argument for whether to consider Case-Sensitivity
I think it would be a better option to have as a model builder. Currently, Isfirstoccurrence deals with Case-Sensitive data as separate occurrences for eg. NA and na would both be seen as separate occurrences. There are many cases where, as a model-builder, You don't want this to happen. So, having an argument to confirm…
-
Update Subsets dynamically - Formula driven Boolean
It would be nice to have the subsets updated dynamically using a formula driven boolean linking to the subsets as a formula, just like how we have the option to link Display Name to a formula in a module. This would certainly eliminate much needed efforts of running the action every time when we have to update the subset.…
-
Generate Code for Assign function - similar to display name attribute
It would be nice to have a functionality which can generate code / auto-populate code, just like how a display name is populated. A property, specifying the code attribute could be useful and reduce the effort needed to create actions and line items to generate code. When we create an item using the assign functionality,…
-
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.
-
Pre-calculation check for duplicate line items
I am sure the acute pain felt when locking-up the model for simply creating a duplicate line item is felt by many model builders. Please could we have a simple check (this already happens elsewhere in the model e.g. actions) that ensures there are no duplicate line items before the model is calculated/refreshed? It only…
-
Custom Blue Print View
A simple suggestion to help with the organisation and maintenance of models (and I assume a really simple suggestion to implement): Allow model builders to save blueprint views (in the same way it works for regular views) and even change the default model blueprint view for all modules so that we can change the order of…
-
ALLPERIODS Value function
We currently have time functions to return the MONTHVALUE, QUARTERVALUE, YEARVALUE etc... it would be helpful to add a final function which will return the Time.All Periods value, this would enable developers to avoid having to add summary methods to determine the all periods value. It may be there is a work-around but ran…
-
User List Top Level
The users' list should have a top-level for calculations. Currently, the users' list can't be used for inputting data as there is no top-level so errors occur when referenced by a line item without the user dimension.
-
Select a specific version when creating lookup formulas
Hi, It would be great if we could have formulas where we can specify a version (like it works for actuals) or if we could apply any line item to a specific version.
-
Make Versions a Format (DataType)
Make Versions a list format so we can use with LOOKUP logic based on user selections. Would prevent the need for versions mapped to a pseudo-verison list with IF/THEN logic, ultimately reducing complexity and increasing ease-of-build.
-
Version formula to work on single Line Items
Allow the usage of a Version formula in the Blueprint view of a module to work on single line items, as compared to the current state of working with a LISS. The usage of a LISS makes it more difficult to maintain if i need only one calculation to abide a specific logic, and creating a LISS for one formula change and…
-
Prepare Sets of Dimensions and Subset Intersections of those Dimensions
As a model builder dealing with combination master data (Cost Center x Cost Element, Revenue Categories A x Revenue Categories B x Revenue Categories C), I want to be able create pre-defined sets of dimensions, the intersections of which I can subset, so that I can easily apply these sets to a module and save space by…
-
Make sorting lists easier
It would be nice to sort lists alphabetically with the same button used for sorting modules.
-
Allow Multiple layers of Conditional formatting with more flexible color options
Let conditional formatting options be stackable in layers (similar to MS Excel). In my current model we have a table that uses color across all cells based on the development stage. At times we also want to color cells that have an error to a particular color of red, however this is not possible without stackable…
-
Add module's name to the Line Items grid in the Modules section
It'd be great to have a module's name in the Line Item's grid. Especially when I extract it to Excel
-
Group/Ungroup Hierachy Items in Module
Not sure if this has been posted earlier but it would be awesome if we have group/ungroup feature in Anaplan on dimensions within a module. Basically Tree View of Modules which will help in grouping & ungrouping of list items based on the parent nodes. This should be applied only if the list is in rows or columns
-
Specify Resulting Value for COMPARE Function
It would be helpful if the COMPARE function could be modified to specify different resulting values. Currently, the formula returns 0 if there is a match and -1 or 1 if there is a match. Ideally you could specify any values, but returning 1 if there is a match and 0 if there is not a match would provide a useful…
-
Ability to create Version subsets allowing to have many different versions without impacting size
Hi Anaplan, As Anaplan grows users will require to create multiple versions allowing them to look at historical information without creating many archived models. The solution to this is to have many versions and be able to subset version lists, therefore saving on space and being able to view historical information…
-
Formula for current user
It would be useful to have a formula to determiner a user from the users list so I could write lookup statements to source data from modules with users list in dimensions
-
Button to Add another / new dimension after creating the module
As a model builder it would be nice to have a button to add dimension to the module and also to the line item after one has created the module. At the moment we can add the dimension to the module through the applies to section of the blueprint. It would be nice to have a window of dimension screen that is shown when we…
-
Search Selective Access List
It would be SUPER helpful if, when giving a user selective access in the user section, that you could search for the list item that you want to give the user instead of having to scroll through a long list to find the item. I know this can be avoided by doing an import, but if you don't know the exact name of the list item…
-
Introduce sequential lists (Array or Linked list)
As model builder I would like to make use of sequential lists (Array or Linked list) to avoid circular references. This can be useful in many calculations.. Native functions like PREVIOUS() or NEXT() could only be applied on line items which are on the time dimension. Such functions should then also work for the sequential…
-
Conditional Formatting for Swtiched Over Cells
Using Native Switchover functionality when the forecast data gets overriden by the Actuals can we have a color code functionality which will highlight Actual Data in Forecast version. As of now it is just editable vs not editable.
-
Ignore boolean flagged items/periods when using the AVERAGE function
Description: As a model builder, I would like to be able to include an additional parameter in the AVERAGE function which is to be used to exclude flagged items or periods from being included in the calculation of average values. Use Case: There are numerous circumstances where I have been required to exclude certain items…
-
Error message generator
Hello, could we have an optimized error message log solution during building process which notifies us of the error? The current blue text box is an absolute time killer during development which could last up to 5 minutes. Bet regards Kristina
-
Anaplan Model Calendar - Roll-up Weeks to Months
Anaplan's model calendar rolls up days into weeks and months into quarters but does not roll up weeks into months. As a result of this, June 2020 has 5 weeks: w/c Jun1, Jun 8, Jun 15, Jun 22 and Jun 29. However, w/c Jun 29 has 2 days in June and 5 days in July - and the entire week gets included in July instead of June.…
-
Curated tips section on Anapedia
I think it could be a good idea to have a curated tips section at the bottom of each Anapedia page. These will be things people have found work but are not specifically stated as working in the entry in Anapedia. These could then help for the basis for Updates to the entry in the future. These could be based on entries…
-
Ability to Define Custom Weeks pattern for Each Quarter differently in Model Time
Currently Anaplan allows only to select one Week Pattern from 3 available to apply across all quarters in a Fiscal Year Time Calendar (https://help.anaplan.com/anapedia/Content/Modeling/Dimensions/Weeks_4-4-5,_4-5-4_or_5-4-4.htm) Example - Pick any one week configuration pattern from 4-4-5, 5-4-4, or 4-5-4 for all…