Idea Exchange

I am requesting the ability to use a generic 'me/myself/self/here' reference in functions that require a Line Item.   An example: Original:  PREVIOUS(Total Average Balance) + MOVINGSUM(Total Average Balance, -11, -10, AVERAGE)  New:  PREVIOUS(Here) + MOVINGSUM(Here, -11, -10, AVERAGE)   The benefit of this is: if the Planner wants to reuse this formula on other Line Items they can just copy/paste.  Currently they have to copy/paste outside of Anaplan, use a search/replace to switch the Line Item reference to the new Line Item, and then paste back into the formula of the line item.     ... View more

As an Anaplan user/model builder, I find the white can be a little too much some times and not too easy on the eyes.   It would be great is there was a night mode or dark theme that swapped the colour palette for something not as bright.   This may also help with accessibility Thanks! ... View more

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 to have an alert when typing a formula (based on line item formatting, module structure, etc.) that helps us rewrite or reconsider the final formula before trying to push it through and watching the model 'spin' for a while.   Example of Enhancement: When line item formatting is inconsistent with the end formula/reference, the border of the formula bar will remain red. This should pick up on basic errors such as mismatched lists or typos. Once the red border is eliminated, the model builder is assured this formula will be processed correctly.   Benefit/Impact: The benefit here would be to reduce time waiting for errors to populate and would help guide all model builders in writing formulas correctly. ... View more

I ran into the issue when I needed to pull the data from the module with a timescale as a one of dimensions to another module that also contains timescale as dimension. I used time formatted line item in the source module for aggregation but it's been ignored in the Result module and error message box has been appeared.   Example:   Source Module                   Timescale / Line Items FY10 FY11 FY12 FY13 FY14 FY15 FY16 FY17 FY18 Value 1 2 3 4 5 6 7 8 9 Mapping Item FY20     FY23     FY19                                             Result Module                   Timescale / Line Items FY19 FY20 FY21 FY22 FY23 FY24 FY25 FY26 FY27 Expected Value 7 1     4         When I set a formula for Expected Value = Source Module.Value[sum:Mapping Item] Anaplan shows " An error has occurred on the server. The model has been restored to its state prior to the last submission."   In order to avoid that I need to create intermediate line items with excessive dimensions. It consumes space and isn't efficient.    It would be very helpful to add ability to aggregate the data using Time Formatted Line item. ... View more

I think it would be very useful to have a function to return the number of leaf items present in a standard or numbered list.   Example:   QUANTITY(x)  Where 'x' is the name of the list, also selectable from 'General Lists'.   Reasoning: This would serve as a cleaner way to get the number of items in a list, instead of doing something like dimensionalizing a module by a list, creating a line item with '1' as the formula, setting the summary method to sum for that line item, then referencing that line item in a separate single-dimension module with one number formatted line item. ... View more

Current behavior: Create a Saved View within a Module, navigate to that Saved View, publish to a dashboard. Then, close the Saved View and add a new Line Item within that same Module.   You will find that the newly created line item is present in the published Module Saved View.   Requested behavior: Module Saved Views would retain only the Line Items that were showing when the Saved View was created. Therefore, within a source Module if a new Line Item is created, all Saved Views would have new Line Items hidden by default.    Reasoning:  This would prevent having to edit any already published Saved Views on dashboards / within Modules if additions would need to be made. This is especially desirable when multiple people are working on an Anaplan modeling project. Overall, would save time for Model Builders. ... View more

Hi Anaplan community,        Based on clients needs, I wanted to figure out a way to print out the line items' source --> Target mapping through the Anaplan API. This is when a model builder is doing an import and gets to manually map data from the source file to the target line items but here we can quickly have an array or list of mappings that can be printed on a website/dashboard.    Much Appreciated! ... View more

We use ISO calendar split. This mean that a year contains about 52 calendart week and about 63 shared weeks: when a week is located in two months at the same time. This is the only way to move back and forth between Months and Weeks. Currently we have to maintain false Time hierarchy in order to have this option. ... View more

As a model builder and auditor I would like to limit the history export on 'hours' to enable a more precise search in the history log.   This is particularly important for our Data Hub where a 'Last 24 hours' selection creates a 4 GB log file. Excel can't handle that, so it requires analytical tools like Tableau or Spotfire to open and analyse it. A filter on the Last 1 hour, 2 hours etc. would make it easier. Particularly because you mostly know the time frame that a certain incident happened.   An even better solution would be of course to have proper audit tooling integrated in Anaplan. ... View more

When my line items reference list items for a drop down it moves the results over the the left. There is no override for to make list items right aligned or right justified. Please provide a right align, center, and left align override within modules. ... View more

There is currently no way no easy way to identify whether data is numeric or not. The workaround for X is to check the following set of conditions: NOT (VALUE(X) <= 0 OR VALUE(X) >= 0) Currently this is certainly not a consistent approach and there is always a risk that the comparison operators ("<=" and ">=") will start behaving differently which will lead to errors. ... View more

It would be useful to be able to change the format of numbers making it easier for senior stakeholders to see. if we have 56989 units of goods - we have to export data files into excel and reformat to display 57 as an output. It would be useful if Anaplan would be able to display 1,000s' in the same way.    ... View more

Currently the aggregation functions only work towards list data type. This disallows to fully replace VLOOKUP function in Excel. Please add at least some additional functionality: for example to search for FIRSTNONBLANK using text data type. That would allow to more easily deal with data without need to maintain excessive lists. ... View more