-
Blank dates should not be taken into account when a line item is date formatted and the summary ****
Description of the enhancement required: Blank dates should not be taken into account when a line item is date formatted and the summary method is set to "minimum". Anaplan should designate the lowest applicable date when this summary method is chosen An example of the enhancement: If there are three child nodes under a…
-
Ability to more broadly reference Versions in Anaplan functions
Description of the enhancement: Ability to more broadly reference Versions in Anaplan functions At present, Versions are restrictive to work with functionally. There is no ability to use the Version dimension as a list format, or to reference a version such as IF versions.Q3 Forecast THEN xyz
-
Enter formulae in data entry cell
I want to be able to enter formulae in data entry cell, e.g. (100+30+40)% and pressing enter shows the result
-
Allow the Users list & Selective Access to be used as the source of an Import action.
Description of the enhancement required: Allow the Users list & Selective Access to be used as the source of an Import action. An example of the enhancement: When selecting the source of an import using 'Connect to an Anaplan Model', the Users list should be an option for the data source. A story for why you want the…
-
Prevent customers accidentally creating an excessive number of line items
Description of the enhancement: Can a limit or warning be implemented to prevent a user accidentally creating so many line items via a blueprint import? Business reason for requesting this enhancement: We have had multiple instances in the past, of importing a file into blueprint mode, which we actually intended to import…
-
More rounding options
Description of the enhancement required: More rounding options An example of the enhancement: ability to easily adjust summaries between whole dollars, thousands, millions.
-
Comparison reports formulas show ID rather than names
When comparing two models, if you download the comparison report it shows when a formula has been edited. If this formula references another line item/property/list item/etc, it shows the ID rather than the name of the object To reproduce, Make a model devM, add a module Mod, add line items a, b, c set the formula for a to…
-
Better User Auditing of Who Uploaded Data
Description of the enhancement required: We wants easier tracking of who uploaded data, within the list or module itself (as additional cells is an idea). We want the name of the person who uploaded/created an item of the hierarchy to be recorded in a cell. We would like the following included: * Email ID/Name of uploader…
-
Ability to manage different summaries in a different way for different levels
If the user has Quarters, Half Year, and Year summaries, they want to be able to set the summary method for each summary. eg, for quarters set sum, for half set none, for year set sum. Currently you can only set the same summary for all levels
-
Predefined Time Filters
Description of the enhancement required: TIME FILTERS We created a VIEW with only CURRENT QUARTER data and published it to a dashboard. Now next quarter, we need the dashboard to refresh automatically for NEXT QUARTER data. To achieve this, we had to create a TIME FILTER module, add line items like CQ, PQ etc and define…
-
Manage Summary Type in Dashboard
We would like to be able to manage the Summary type of a line item from within a dashboard. Currently this is managed via the module's blueprint view only.
-
Switchover for End Of Year
Description of the enhancement required: Be able to have switchover throughout the year. This would allow a version to match actuals for line items with time, but have separate information in other line items. An example of the enhancement: Admins could select FY as a switchover time period for a version, and then that…
-
Remove time mappings that rely on fiscal year
Description of the enhancement: Remove time mappings that rely on fiscal year from import dialogue when model time setting 'Weeks General' Business case -why this would help the business process: As a user, I expected I could import file with a time format of weeks in numbers (e.g. 201712) while my Anaplan time settings…
-
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.
-
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…
-
Problem with specific tenure?
I am looking for the best solution how calculate/distribute an amount within specific tenure once it was triggered by a variable. Example: 1 million of revenue will be recognized equally over 24 months once the project is completed. The 1st month of the recognition starts on the following month once the project completed…
-
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…
-
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:…
-
Additional week formats
Description of the enhancement: We would like to have a Week format that will combine the number of the weeks in period and the period associated with the week. For example, for week 50, we'd like to see Wk 2 - P13 FY14. I imagine this is a concern for retail companies as this is the way most retail companies look at…
-
Drilldown displays formulas without parenthesis, and cannot be copied back into line item
Description of the RFE: Users are copying and pasting formula from drilldown dialog, which isn't possible because parenthesis are removed. This is an RFE to retain the parenthesis, or at least provide that option. Use case: Drilldown formula is removing parenthesis. This is causing come issues for us working with a large…
-
Syntax for a variable Line Item in a formula
Hi I'm building a module where I want to pull values from a subsidiary model, but the line item I want to pull from varies according to the member of a particular dimension. For example, if I'm looking at dimension member "APPLES", I want to get my data from the line item "line_item_a", but if I'm looking at the dimension…
-
Find the common parent of two list members
I have an Entity list which contains the entities in my organisation. If, as the result of another calculation, I have been returned two entities in the Entity list, how do I determine their lowest common parent? Some combination of PARENT and FINDITEM seems likely... but they might be at different levels.
-
How do I sort a list?
In excel, order the list members (members only, not parents, etc, just the members as they appear in the list in Anaplan) in the order you would like it in Anaplan. Then copy just the list members. In Settings->List->Grid View (not Tree view!) of the list, click Insert, choose Start as the ‘position’, paste in the list,…
-
Count the number of sparse cells in the MODEL
Hi There, Can anyone lemme know if we can count the number of sparse cells in our Model? Basically, we want to know the number of blank/non-zero cells in a model (Or) can we count the number of cells which has data in it? ( as per my understanding, if we get the sparse/non-sparse cells we can subtract this from the Total…
-
Line Item (List) link into a module
Hi everyone, i have a module with several line items. One line item is a List, another one is a number. After i have selected a value and entered a number, i want to link the value into a module which has the List as in the rows. Any idea how to link the data ? I would like to have the value number entered only appear on…