Modeling

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.
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,…
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:…
Convert time period to a date
Description of the enhancement required: As an extension or alternative to the DATE function
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…
Restrict Access of Line Items to Supplier
Hi, I have a dashboard, containing a module, with approx 20 columns of data, dates and text. We are sharing this dashboard with a supplier who have their own user, and role setup. In the dashboard, there are 6 fields that are updateable by users within the business The supplier needs to be able to see ALL the fields, BUT…
Synchronizing dashboard scroll bars
Anaplanners: I am thankfully almost done with my dashboard which is essentially composed of the same modules but I need have the up & down scroll bars synchronized; I tried to sync the rows but that simply collapsed the modules. Is there an effective way to synchronize the rows so that the user will have the same rows at…

Modeling

Discussion List