-
Quick way to open referenced Line Item or List Property
It would be great to have a quick way to open a referenced Line Item or List Property from an existing formula. It can be very tedious & time consuming to hunt through the modules & lists, then again through the line items & properties to locate the reference, especially when there are multiple levels of references to…
-
Create Function for ADDWEEKS
Please could we have ADDWEEKS as a function to work the same as ADDMONTHS and ADDYEARS the current workaround is to convert the weekly time period into a date then add or subtract 7
-
Use Time Ranges in formulas: Make the Time Range a named member in the Time Dimension
If Time Ranges were true named member in the TIME dimensions we could easily control formulas and filters based on a time range. It would also allow for YoY changes in formulas to be maintained easily w/o having to create multiple line items. Many companies need to save off older versions for compliance reasons. Adding the…
-
Formula Error Log
As a model builder and workspace admin, formula errors can be costly. My idea is to add an error log that tracks formula and calculation errors. This will help document who was doing what when something goes wrong. It will also help with enablement as you can review the error log and use it for training - ensuring that the…
-
Formula to pull dates from History log - Cell Updates
Hi! I would like to be able to pull information about the date/time when a cell is update. Example: If I tick a Boolean field called Final Position to mark a deal as ready to be contracted, I'd like to have an associated Final Position Date automatically fill in with the date that this cell for the deal was ticked
-
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…
-
Save user roles globally across models
I have a couple of common user types that I always create for every module. It would be useful if these could be saved as default choices and used across all models in the workspace.
-
Increase in more than 1 million times for Breakback line items
Proposal : Increase in more than 1 million times for Break-back line items Benefits : perform large inputs in break-back for initially very small, but non-zero values, excluding the step of force zeroing values by each cell before break-back.
-
Add to Line Item Subset Items from different modules with the same Name
Being an Anaplan builder, I would like to pick line items with same name, but from different modules into one Line Item Subset. The behavior of items in LI SS in that way will be like in numbered list. Benefits: preparing reports, combined across big number of similar metric without creating and fake Line Item SS and…
-
Copy/Import Line Item Formats
To provide self-service modeling we need to allow users to not only add new line items to a module but also to change/update the formats. It would be nice to be able to import line item formats as well. Line items can be imported but then only a model builder can change/set the format. For example: I want to give my users…
-
Extend Date format to include Time (hh-mm-ss)
Description: Being an Anaplan Builder, I would like to be able to have a date format with Time in it (hh-mm-hh) Some of our planning tasks are connected with work with exact timing (Date + Time). Currently, we have to upload this data as text and use RIGHT(),MID(),LEFT() functions to extract values. If we have a customized…
-
Increase the limit of characters in Notes section
HI Team, It would be really helpful, if we can increase the limit of characters in Notes section of a module. Currently it has 250 as a limit. I got stuck here when I tried to copy paste one lengthy formula cos I don't want delete the formula instead I might take that for my future reference. Let me know others thoughts on…
-
Ability to sort the order of views on a module using Ascending or descending options
Currently when you click Manage Views on a Module you can move a view up or down to change its order. It would be easier if we could have the option to sort in the same way for other objects with an ascending and descending order option or a top or bottom option. In addition you can only move a view once in either an up or…
-
SUMPRODUCT function
Analogue of SUMPRODUCT function in Excel
-
FIND list items by property value
Currently you're only able to use systm properties: Name and Code to identify List elements. Please add an optional argument in a FIND functions that would allow to use any single exact property in the selected list as a reference.
-
Code property
ITEM is not an occupied system property while CODE is. This makes the formulas ITEM and CODE not equivalent and thus inconsistent for Anaplan modelers. Since CODE() and ITEM() are very similar formulas, it would be nice to make their syntax similar. The practice that we use to keep formulas simple is creating “item”…
-
LOOKUP towards a line item that has less dimensions
Please add an option to use LOOKUP function towards a line item that has less dimensions. For example: I have a line item that has three dimensions: * Client * SKU * Month I try to get some masterdata from Region, Month level that doesn't have SKU dimension. When I try to use [LOOKUP: Client.Region] towards this line item…
-
Synchronize to Specific Level of Hierarchy
Ability to select a level of the hierarchy to show and have synchronization based on selection. Ability to have separate tables built out for a hierarchy to drill down into without creating separate modules. If we could select the level to show in addition to having synchronization based on selection it would eliminate a…
-
More options for TEXTLIST
There is currently no way I can use TEXTLIST function with both unique values AND mapping. * Either you can use parenthesis function with UNIQUE property * Or aggregation function with mapping but with entries repeating. To sum up both use cases are incomplete. Please add option to turn on both features at the same time: *…
-
Ability to use Concatenate (&) in a Select Function
I would like the ability to add an Concatenate to Select Function. For example SELECT: VERSIONS."Budget "&NAME(Current Year). As we have multiple Budget Version, the current version in play and the future version. So in our variance reporting module it would select the correct version as budget. Similar with forecast ……
-
Hide List Property Columns when view is on Dashboards such as the 'Parent' or 'Code' or propety
Hi Anaplan, It would be really helpful if it were possible to hide the 'Parent' 'Code' or any property columns on list views published on dashboards. This is to prevent any destructive inputs such as changing the hierarchy by accident. Thanks, Usman
-
Prompt to open list when creating
I am adding a new list, it would be useful to either open the list immediately afterwards (or prompt for opening). This could work in the same way as creating a module. The logical next step to creating a list is to add members to the list. It would be more efficient to be able to add members to the list as part of the…
-
Open a Module in "Line Items" tab by selecting a line item (not just a module)
When I can't remember where I saw a particular line item, I go to Settings ---> Modules ---> Line Items and search for it. When I find it, it would be very natural to just click "Open" in the header. However Anaplan only allows this open button to work if you have the MODULE name it belongs to selected. So I have to scroll…
-
Poisson function
My customer needs to calculate the POISSON cumulative results to find out the lambda value that goes above a probability treshold. In a maintenance use case, this is useful for him to statistically determine given a target service level and the past average of incidents how many incidents should occur in the future, and…
-
Customize Model Filters
Consider allowing customers to customize the filter categories. App, Geography, Planning Cycle, Environment, and Business Function do not fit our use cases or model categories.
-
Default Home Page to list view
We would like the ability to default the tiles screen to the list view for all of our users. This view is a lot more user-friendly than the tile view, we have had an abundance of requests for model access when the users do not realize that they just need to scroll to the right to see additional pages of tiles.
-
Custom Format for Lists
Currently all list items default to text. It would be helpful to add them as dates, numbers, etc.
-
NULL Number Format
Null option for number format. Currently when a number in undefined, it will populate the module as a 0 instead of a blank. A work around is required to convert all of the numbers into text, and then make undefined numbers "N/A". The ROUND(TEXT()) function also causes a large number of unnecessary decimals.
-
Keep Dashboard Tables Anchored
When making inputs to large tables, the dashboard will scroll back to the top after making an entry. The ability to have the dashboard stay anchored while entering information would save time for users. We are having to use the maximize feature for each table to input data.
-
Automatic Sum in Drilldown View
Ability to select multiple cells in a drill down window and see the sum on the back end, as you can on a dashboard.