-
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…
-
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…
-
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…
-
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…
-
IRR function to operate on a specified time period ranges
Hello team I would propose an idea of IRR function enhancement to operate on more dynamic environment and respect Anaplan time dimension in the same way as TIMESUM function. Why it is necessary? For IRR calculation when the sign of the cash flows changes more than once, for example when positive cash flows are followed by…
-
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…
-
Additional modes for Formula Scope
Whilst the current method for formula scope encompasses the existing options (Actual, All Versions, All Versions Except Actual and Current), there is sometimes a need for formula scope to be applicable to specific versions outside of this scope - For instance, side loading of a budget. Whilst Add Version Formula covers…
-
Dynamic Cells Calculation (DCC)
This feature would allow to selectively switch between "Calculation" or "Manual Input" on a specific LineItem. Much like the DCA, the DCC would be based on a boolean. When True, the formula would apply but when False the user would be allowed to type data. This would allow to make Anaplan much more dynamic and greatly…
-
Anaplan Time Range Limitation
I was very surprised recently when I discovered a limitation to Anaplan's permitted time range. It may surprise others to know that Anaplan is limited to supporting only 70 Years (20 past and 50 future) and the maximum number of years possible is 90 (using a time range set, as of writing, to 1981 with 90 periods). I did…
-
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…
-
Version on List
Currently, we cannot have versions on a list. It is a limitation that customers run into every day. Below is an example from Red Hat, Inc that demonstrates the challenge that this limitation creates and how having versions on a list could be a tremendous benefit! Account Hierarchy: L1 Geo L2 Group L3 Region L4 Sub-region…
-
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…
-
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…
-
Dates in Timesum
Timesum formula currently works with time periods. When the granularity of the data is Days, the formula cannot return anything (although it does not generate an error). The idea here is to enable Timesum to also work with Dates so that we can apply this formula to more granular use cases.
-
Time Range < 1Y
Hello, would be great to have Time Ranges functionality linked to the Current Period & for less than 1Y, e.g. moving two-Q range linked to the current period of the model. This for sure will optimize AN models in terms of speed & workspace size. Best regards Kristina
-
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.…
-
Order List Action for End user
Hello, do you consider enhancing the Order List Action functionality by making it accessible for the non-admin users? It would be really great the end user to be able to apply such an order whenever he consider it useful. Thank you Best regards Kristina