-
Find last month of the Quarter
Create a Boolean formatted line item in SYS Time module at month level. In the formula bar write the " PARENT(ITEM(Time)) <> NEXT(PARENT(ITEM(Time)))" That's it😉
-
Multi-Substitute formula
Hi everyone, It could be very nice to have a new formula to allow replacing several values by others instead of only one with the substitute function. For example, to replace "," by "." and " " by "", the current way is : SUBSTITUTE(SUBSTITUTE([Text], ",", "."), " ", ".") The new way could be : SUBSTITUTES([Text], ",",…
-
Improve the Search bar
Can you please improve the Search bar engine in Anaplan? The Search engine should reduce by itself the ' ' (primes) Also Ending/Starting Space bars which happens in copies should get reduced automaticly or ignored in the search. I always have to modify at first the search string before the search is intelligent enough to…
-
Median function/ Median summary method
Please can we have a median function or summary method. I appreciate that you can get around this limitation using Rank() but in my experience the work around is exceptionally computationally heavy and you cant Rank() over time which further complicates matters.
-
Configure Default Number format for an Anaplan Model
As a Model Builder, I would like to select a Number format for an entire model ("Global Default Number Format" ?). This could be very helpful for us to save time. This can work like the selection of the "Global Default Gride Style" in the Dashboard Settings.
-
Reporting/ Hierarchies/ Modules
Afternoon, I wonder if somebody could help. Issue: We currently have our volume planning pages (& subsequent summaries) set up in the hierarchy SHOP > CUSTOMER > PRODUCT (E.g., Shop 1, showing customer A with 100 products, made up of 70 of product Y, 30 of product X) We have been requested to create a report customer first…
-
Search Icon missing in the beta version of new module inventory
Hello Everyone, I see that in the beta version of new module inventory, there are two issues: 1) The Search icon is missing, which is there in the earlier version. 2) When we use the find option (Ctrl +F), it only searches the module names present in the current screen and not from the entire list of modules. Attached the…
-
Allow User Dimension Subsets to work with Dynamic Cell Access
The addition of being able to subset and add a top level to the system User dimension was a fantastic addition! That said, it would be great if the ability to use those User subsets to manage Dynamic Cell Access in modules & line items would be a great addition.
-
Add XOR formula
Title says it all, a XOR formula would be really helpful and reduce formula length when trying to test an exclusive or. For those unfamiliar, here is the logic table for XOR. It acts as an OR however if both inputs are TRUE, then XOR returns false.
-
Using LOOKUP and SUM with Formula summary method
A detailed description of the enhancement that is being requested. We would like to request an enhancement that would allow to use LOOKUP and SUM with Formula summary method. Currently Anaplan doesn’t allow to do so, although in many cases it is needed and doesn’t break the math. If available, could you please provide a…
-
Function for Contribution
There is no simple way to calculate contributions all children levels to the highest parent level - for product levels, time levels and location levels. The lowest level should be considered the value to express as a contribution of a level you need to select. Examples: Week 1 to 4 belongs to Month 1, which belongs to Year…
-
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.
-
Allow Time Ranges shorter than a year to be created
Time ranges are a useful feature in Anaplan which can often help to reduce sparsity by allowing modellers to create modules just covering the time ranges needed. However, they are currently limited to being a minimum of 1 year long. We are seeing customer use cases which could benefit from being able to have much more…
-
Search box in 'Model Management' Dialog Box
Hi, When we click on 'Manage Models' dialog box, we get an option to select a workspace. When we select a workspace, we get a list of models to choose from. But in case there are numerous model in a workspace, then it becomes tedious to search for without a search box. Can we have a search box to filter ? Thanks, Aravind M
-
History Check & Roll Back for NUX Pages
Hello Anaplan Modelers, I would like to suggest an enhancement/idea on NUX, checking nux pages history like we are checking for model history. This would be helpful for a team to identify who did what Chages for what page on what day. Also like we are restoring/rolling back our models wherever we need, the same way if we…
-
Cloudworks Integration Flow & Run from dashboard
Just like you can run a Cloudworks integration from a dashboard, we would like to be able to run a Cloudworks Integration Flow from a dashboard. This will really aid us in connected planning.
-
Stop system from processing changes.
We need the ability to stop this. This has gotten out of hand recently. It is impossible to work with this. I make one simple mistake and I have to wait 20 minutes…. This is unacceptable and makes working Anaplan impossible. This needs to be fixed asap. Top priority.
-
Add Folders for Modules and Lists
Similar to the idea posted here, but with this idea could be a possible solution? * Add folders to object contents (e.g. module, list, and actions). * Allow the creation of sub-folders. It goes without saying, but this would really improve model organisation, especially for larger models. The functionality could be similar…
-
More advanced Grouping, Sorting and Filtering of the lists of Modules / Dashboards / Actions etc
During Anaplan training a user creates 5 or 6 modules / dashboard etc. Easy. Our model has a staggering list of actions, modules and dashboards. In our model are we have: * 593 Modules * 248 Dashboards * 1767 Actions Model builders need a more robust wayto manage this. Having the ability to filter these lists by a type…
-
Ability to add Folder structure to Lists, Modules, Actions etc
Being able to keep a model clean and well organised is really important in allowing model builders to understand and work with the model going forward. Often we find that as a model grows, the number of lists, modules, actions etc grows quite large and can start to become difficult to manage. This enhancement idea is to…
-
PREVIOUSITEM() formula which is like PREVIOUS() but references a list item instead of time
Hi Anaplan, I was searching for the use of the PREVIOUS function but on a list item but it is not currently possible. @peter_mcanena has suggested this but only in a discussion thread. So as his idea suggests: PREVIOUSITEM(x, y) where * x: Any expression * y: List The expression x must be based on the list y.…
-
Display warning message when deleting a line item which is being referred as a filter.
Hi All, In Case if we are using any line item as a filter and if we are deleting it a warning message should pop up similar to when we delete line items which are being referred in a module. It helps maintain the saved views as most of them will be created based on specific filter or condition.
-
Allow hashing out of lines in the formula editor
Issue: As a model builder, we sometimes need to alter lines of code in the formula of a module. It would be really helpful if there was a character (e.g. hash symbol "#") that Anaplan can ignore so that model builders are able to quickly remove certain lines of code from being used in the calculation without having to…
-
Pages in a model - adding a category column
My idea is to have the category column of a page of an app show up in the pages menu e.g. page, category, app….. columns This makes it easier to identify pages related to each category without having to explore each page by clicking on it. Very useful, especially when there are lots of app pages.
-
Can choose CF line items across applicable modules.
Greetings Model Builders, I would like to suggest an idea/enhancement to the current modeling approach that we are doing it for CF's. We need an option to select a line item from different module (that has same dimensions as target) but not only in the current module while applying a CF. I feel through this we can ignore…
-
Ability to copy a process
It would be nice to have the possibility to copy a process. This will save some time when developing, because you can easily amend a simular process instead of collecting all actions again.
-
Users native list to have a list subset for logged on users
Now that the Users list supports subsets. I would like to have an option to have the ability to have a users subsets list based on logged on users. Background: Most modules with users dimensions are used to support personalised reporting filters. In general, if users are not logged on these modules should not include the…
-
Show calculation time directly in model
Would be very beneficial for the model builder to see the calculation time (e.g. from model open) of the individual line items with formulas. The current cell count is a great help when it comes to optimizing the model and identifying how to reduce the size hereof. However, the calculation time of the different line items…
-
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…
-
Variable Rounding
It would be helpful to allow the use of variables for the rounding direction and method, instead of only permitting hard-coded value. I'm working on a use case where for a certain planning scenario, there is a need to round up for certain product/country intersections, but round down elsewhere. I have a workaround, but…