-
Data dependent locking of cell data
A boolean property on a list; if the boolean is checked, data for that list item is locked throughout the model. Need to define how/who can unlock it. Could be very useful for custom task flows & locking mechanisms. Useful for custom workflows.
-
Allow time functions on regular lists
Allow a model-builder to do functions like cumulate, previous, and next on regular lists. Currently this is only possible on the Time dimension. Many use cases for this, e.g. in a tiered compensation or bonus compensation plan.
-
Version Subsets
Ability to create subsets of the versions list Benefits: This will allow versions to be used much more versatile way, as the model-builder will be able to specify which versions will show up in which modules. For example, use forecast & actuals in some modules, but use V1, V2, V3 for scenario planning in other modules.
-
Versions as list format
Make Versions available as a list-format. Benefits: Allows the end-user to select the version they want to look at from a drop-down making for better variance reporting. Allows you to map from a normal hierarchy into a version dimension *Excel add-in needs to support & support with filters
-
RANDOM() function
Function that will generate random numbers, between specified min & max values. Excel has two functions to provide random numbers: RAND() generates a decimal value between 0 and 1 RANDBETWEEN( x , y ) generates an integer >= x and <= y It may be worth considering an extension to these functions such as: RANDOM( x , y , z)…
-
Custom groupings - As an admin I want to organise my model objects, such as lists, into groups
Similar to functional areas for modules, but allow admin to easily create custom groupings and assign objects to them, so that their settings objects are organized. This should be included everywhere we currently have 'Re-order', as it will need to be incorporated. For example, set of line items for UI data, calculations,…
-
Selecting 'All Periods' does not display all Time periods
Description - Model has a timescale with 6 years and 'Total of All Periods' enabled - Open the dashboard 'Time only dashboard' - Synchronised rows is enabled for the grid 'Time only' (Time on rows) - Select 'All Periods' from the time page selector on the dashboard Expected result - The grid updates to show all time…
-
Special characters
Ability to handle special characters in the code field.
-
Allow the native search function to search any part of a string, not just from the beginning
Description of the enhancement required: Allow the native search function to search any part of a string, not just from the beginning of the string. How would it help the business process: Having this option would make it very transparent to users when filters have been applied. Would also help model builders to configure…
-
Allow for line item subset to be more than just number formatted
Description of the enhancement required: Line Item Subsets are often used to build filter modules, as an alternative to using the Show/Hide functionality. Using a Boolean against a Line Item Subset on a filter module makes it very easy to select which columns should be shown or hidden on a dashboard. An example of the…
-
Add Versions as a native option for a line item/property format.
Description of the enhancement required: Version as a format An example of the enhancement: When uploading a planning file (budget, Q1 forecast, Q2 forecast) from excel, a number of identifiers for my transactions are uploaded as text and later on in the transactions module turned into line items based on a list so I can…
-
Add a custom formula for summary that doesn't necessarily apply to rest of cells in that line item
Description of the enhancement required: The ability to add a customized formula for the summary that does not necessarily apply to the rest of the rows within that line item (currently the formula for the line item becomes the formula for the summary if you are to select the "Formula" summary option). How would it help…
-
Abkhazia not on Map Chart
Country Code for Abkhazia is not in the "Map Regions & Codes" downloadable, and subsequently won't show up in Map Charts. Please provide the country code for Abkhazia
-
No subtotal for Weeks: General time setting
Description of the enhancement required: In the timescale settings add Total of All Periods for Weeks: General timescale How would it help the business process: For example, looking at the travel and tourism industry, which is highly seasonal (e.g. different destinations, hotels, and services are in demand in the summer vs…
-
Increase Code character limit in List
Description of the enhancement required: Increase Code character limit which is currently max at 60 characters. An error window will appear if character limit is reached. How would it help their business process: Customers have data values that exceed 60 characters when they try to import data into their List. When they…
-
Move Format column to before Formula column in Blueprint mode
Description of the enhancement required: I would like to submit an enhancement request in regard to the Blueprint Mode of modules. I would like to move the format column before the formula column. An example of the enhancement: When you are creating new line items in Blueprint mode, the first column that you see from left…
-
Editable hover-over text on cells
Description of the enhancement required: The Hover-Over Tip function: Allows the user to hover over a cell, table, module, model, dashboard or buttons which then shows a short description or identifier for the object. An example of the enhancement: User wants to see a short background description without having to drill or…
-
Search grid data
As an admin/end-user I want to search on data as well as column/row labels
-
No way to get last month of quarter in one line item
As an example, if the first month of the Fiscal Year is Mar 15, I want "May 15" returned because that's the last month of the quarter. This is my formula (on a line item formatted as Month and no Timescale): FINDITEM(Time, NAME(PERIOD(END(PARENT(TIME.'Apr 15'))))) However, this returns 'Apr 15' due to this in Anapedia:…
-
To be able to use an action to change the order of items in a list
Description of the enhancement required: To be able to use an action to change the order of items in a list. An example of the enhancement: I have a list, FRED, which is populated from a SQL query containing an ORDER BY clause. However, new items are always inserted at the end of the list (or rather, at the end of the…
-
"Edit From" and "Edit To" in "Versions" don't prohibit users from importing values to that time peri
Description of the enhancement: The RFE would be to disallow users from importing into a timescale that they cannot edit. To reproduce: 1. Create a module with "Versions" and "Time" as dimensions. 2. In "Settings"->"Versions", change the "Edit From" to "Feb 16" on the "Actual" version. 3. Back in your module on "Actual"…
-
Convert time period to a date
Description of the enhancement required: As an extension or alternative to the DATE function
-
Option to disable the model map
Description of the enhancement required: Please provide an option to disable the model map. An example of the enhancement: In the Settings tab, there would be a section for User Preferences, which would allow me to turn off the Model Map. How would it help the business process: I never use the Model Map, but it gets in the…
-
Allow order of CUMULATE function to be defined by the user
The CUMULATE function when used against a list, currently accumulates in the original list order even when the list has been reordered. Anapedia states this is how the function is meant to work, but I would like it to take into account if the list has been reordered, and cumulate in the new order. Description of the…
-
Filtering Line Items
Some way of filtering line items; Use case is that users are on pages, and different users wanted to see a different set of line items. We were using a line item subset, but since it only could include line item that had numeric values, it could not hold all line items. Current behavior: Line item can only be filtered on…
-
Ability to create a budget version, copied from another version, with values that don't change
I want a version that contains values from another version, but doesn't rely on lists/formulas/etc. Changes to the model should not affect this version copy. Description of the enhancement required: I want to be able to take a copy of a version which is just a copy of the numbers, so once you agree the budget it is copied…
-
NOW Function
Use case: As a user, I want to display the current time (e.g. 9/12/2018 5:00AM) in a cell. This should behave similar to the "NOW" function in Excel. Business case: When a user presses a button, we want to display the last time the button was pressed.
-
Enhancement Request for the ability to assign list items to a subset using a formula
I would like the ability to populate a subset based on a line item attribute in another import module that contains the full list.
-
More granular forumula scope for versions
Description of enhancement: Ability to set formula scope for selected versions rather than just the limited options of All/Actual/All except Actual/Current. Business case: This would give us the ability to control what versions applied to a given formula. Would allow us to create snapshots. Would allow us to work in two…
-
LOOKUP does not work on list parents and only leaf items
When a LOOKUP is done on a parent item in a module, the result does not resolve to the column with that respective parent. Subsequently the value shows 0. To reproduce: 1. Create list with leaf item and parent 2. Create module with column 1 as "Data", column 2 as "Parent", and column 3 as "Lookup", using list from 1. as…
