-
Insert Line items – Format settings
The reason behind the ask is because Anaplan is not letting the model builder even to add dummy line items (Divider with None as a format) if the model exceeds the size as it takes the 'number' as default. I hope to resolve this concern, probably Anaplan can let the developer choose the format of the line item before…
-
Add option to search for data anywhere within the table of a module, not just the rows dimension
Pretty self-explanatory but I want the ability to search for data or text or part of a formula anywhere within a module, not just the rows column. Identical to what Excel does with ctrl+f.
-
VARIANCE command
When we define an item we can set the number Format to Numeric and tag if an "Increase in Value" is Good/Bad/Neutral. Why do we not have a VARIANCE function to utilise that increase in value indicator? So if we have three different Versions ("Actual", "Budget" and "Actual vs Budget" and 1 item called "Sales" (with an…
-
Is there a way to set a numerical goal and track its progress throughout the quarter on a Dashboard?
I am looking for a way to communicate a sales goal by product and channel on a monthly basis. Please let me know if you have any ideas, Thanks!
-
Select parent level
I would like to see a formula similar to parent but "inverted". When I have an unbalanced hierarchy and need a parent a similar level I would like to choose level from the top instead. example: invparent(item,3) which would always give the level 3 item for all parts of the list instead of trying to find our a way to get a…
-
Provision to input code while inserting elements into a list
While inserting a elements into the list, currently the UI only accepts the name, not the code. Can you please make Code and Name available while inserting elements into the list.
-
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…
-
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
-
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…
-
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.
-
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…
-
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…
-
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”…
-
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 ……
-
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…
-
Right-click a part in a formula ---> take me to that module / List / etc.
Similar to some other feature requests I've made... 1. Open From Drill Down (delivered) 2. Open From Filter View it would help model building workflow if I could right-click a module or list that appears in a formula and it give me the option to open the module, or show the list. Again, this is so I don't have to leave…
-
Right-Click on an applied filter ---> take me to the module
When Opening a filter, It would be really helpful if I saw a filter I wanted to dig further into and be able to right-click and open the module it's coming from. Currently a user has to back out of the filter view, and go there manually. When there are a few filters I have to screenshot this view temporarily because I…
-
Pre-emptive alert for Anaplan function constraints based on total number of cells to be processed
A pre-emptive alert for Anaplan function constraints based on the total number of cells to be processed would be useful to detect issues early in the ALM data transfer process avoiding the synchronization unproductive time until the error or warning message regarding the same kind of effect pops up.
-
LAG function constraints don't allow for some valid scenarios
I would like to submit an enhancement request for the LAG function to be used between time ranges that are not the same but have valid overlap. The constraint that disallows the use of LAG between any line items that do not have the same time range gives the function minimal utility. I understand disallowing instances…
-
Line breaks in free text fields
Please add the feature to enable line items and data with free text, with all characters including line feeds. Ctrl+Alt+Enter creates a line feed while entering the data, but it is lost when the data is referenced.
-
Day level calendar setting
Is it possible to have a 'day' level setting in the calendar type. We need to plan at a greater level of time sensitivity than is currently available. At present, we use Anaplan for weekly and monthly - it would be great if we could do the same for daily too.
-
Apply module defaults for timescales
I would like the option to use the "-" setting for time settings in the module blueprint, as per the Applies to Since I rarely use subsidiary views, if I need to change the time from, say week to month, I then have to apply this change to all line items, whereas using a default would save time
-
Advanced Search: Allow use of Boolean Operators etc. in model search
I use the search functionality in Anaplan a lot because otherwise it's difficult to find things. It would be helpful to use operators (like in a google search) to find things. Here's an example: Pretend I have a dashboard named "David's XYZ Extravagant Dashboard - Cost Sheet" When searching, if I miss a single character…
-
Option to allow the system to automatically set the datatype for a line item
It would be really helpful to me when building complex formulas if I could build it up in pieces without creating lots of line items to do so. Ideally I could build it in pieces without getting plagued with "wrong data type" errors. I'd like the option to let the system adjust the datatype for me instead of just rejecting…
-
Show first 100 rows in Drill Down
The message received when trying to drill down onto a cell which references a large list is as below. Instead, can there be a enhancement to add the grid filtered down to the first 100 rows so that users can continue troubleshooting in the Drill Down window? Thanks! Cannot display grid for line item <sample line item> too…
-
Line Item Format from module
It would be useful to see attributes of a line item without having to revert to the blueprint view I often build formulas in the normal view because I can see the results immediately. It would improve efficiency if I could see the list format, for example, without opening the blueprint view Maybe through a hover over or…
-
Wizard to help Anaplan business end-users to write-down formulas and create objects on models
Wizard to help Anaplan business end-users to write-down formulas and create objects on models. This wizard such as an Avatar could be the AnaFriend indicating the best function or best way to use a specific function or Anaplan models objects such as list, subset or module.
-
Compare Values Incorrect color for negative version amounts
For a line item that has a saved value that is negative (take net income for instance), a less negative or positive value to compare to should be green, but is highlighted as red when you use color coding with the compare tool in Anaplan. Has this issue been identified before? Seems like it would be an easy fix since in…