Modeling

Rephrase action delete dialog so it is clear what is begin deleted from the model
A description of the enhancement requested: The customer would like the "Confirm Delete" message for deleting Actions in a model rephrased to not sound like they will be deleting all data within their model. An example of the enhancement: After selecting the Actions you wish to delete, the "Confirm Delete" message will…
Date comparison
Hi all, I've got a line item where I import date from AWS everyday. I also have a list called Split Week where I have two 'Date' formatted properties called Start of Week and End of week. Is there any way I can check if the Date of import lies within the 2 properties? Thanks in advance. Prateek
How to filter Line Items in a Page Selector
Hi, I have a module that is used to create a chart on a dashboard. The module has 10 line items and the line items are used as page selectors in chart on my dashboard however I want the page selector to show only 5 of the 10 line items that are relevant to the chart. How can I apply this filter on the line items?
Workflow applied to a line item update process
I like the basic concept of workflow and want to use it to flag progress against various processes that my model supports. Organisation is used throughout my model and so there are several processes I need to track by Organisation - the status of various assumption builds, as well as progress in signing off the overall…
Select different levels under different pages
I have a row of 3 levels' list (L1,L2,L3) as rows and two versions (forecast and actual) as pages. Under forecast page, I want to show details till L3. while under actual page, I only want to show L2. However, it seems that levels on different pages will sync, are there any ways to show different levels in different pages?
Comparison (calculate a difference) of two selectable parameters
Hi, Anaplaners I am expecting to compare two parameters (in the attached file, May vs April) which users can select. (Please see the attached file). I would like your pointers on how to acheive this. April, May, and Jun do not have to be TIME dimension, but may be a list. Thanks in advance. Regards, Greg
Summing Across Different Levels of a Hierarchy
Hello all, The model we currently use at my company currently does not have many hierarchical lists, however I am trying to sum a line item in a module with a hierarchical list as a dimension and it is doubling the result of the sum by adding up the parent's total as well as all of the children that belong to that parent.…
Copy Branch should have the option for list formatted line items that are copied to update to the co
Description of the enhancement required: When using Copy Branch, Anaplan should give the user an option about how it copies blue (editable) cells - particularly for List formatted line items. The user should have the option for list formatted line items that are copied to update to the correct list item automatically. This…
Model save activation threshold should be reviewed
Description of the enhancement: Currently, if a model has six or more users it will save after 600 seconds worth of changes, and if it has less than six, it will save after 60 seconds worth of changes. There are development-stage models with more than six users that would benefit from saving every 60 seconds. Example of…
Improved ALM Error Reporting
Description of the enhancement required: Add more detail to error messages for ALM sync failures An example of the enhancement: When there's a ALM sync failure the current message to the customer is "An internal error has occurred", however most of the time the specific cause of the failure is captured in the logs. You…
Allow admin to restore corrupt or unusably slow model from outside model
The scope is only to allow a workspace admin to RESTORE (not copy) their model to the necessary point before it was corrupted, without opening the model. Here are some requirements: * The model may have to lose other changes that were made, but we want to implement this change in a way that will minimize the lost changes…
Referencing Previous Row
In the attached file i've a column of data that goes up and down and in the 2nd column it's a more smoothed set of numbers. Essentially if row B is bigger than row A give me row A based on column 1. But what I want to do is if row B is bigger than row A give me row A but from column 2 so that where there's the 55 and 70…
Ability to export and import model time settings
Description of the enhancement required: We would like a way to take the 'time' settings from one model and add them to another e.g. allow an export of the time settings and import them to another. Example of enhancement: Have a model with time settings and allow to push or pull that data to or from another model.…
Request to 'tone down' Quick Sum Bar warning
Description of the enhancement: The mixed data types warning is confusing and distracting to my users. Can it be toned down? Example: The yellow looks too much like an error and could be viewed as there being an issue with the data selected. How it helps my business process:
How should I debug to see what's happening exactly in my formulas?
Hello, One of my client is operating some models which drives a connect Supply Chain Network, and they need a stepwise debug execution so as to see what's happening exactly in the formulas. Due to the fact that most of formulas are bid over complicated, step by step debug execution would be nessary. Any ideas and comments…
Calculating the IRR for a subset of cashflow
Is it possible to use the IRR function to calculate only a subset of the cashflow? For example, in Jul 18 I'm looking to calculate the IRR of the cashflow from the beginning to Jul 18 and then on Aug 18 it will be from the beginning to Aug 18. In excel you can simply have the formula as IRR($H2:I2) and apply that across…
Dropdown (Time dependent)
Hi community, we currently working on a anaplan project and can't fix one major "Dropdown/Selection" problem. Background: It's for a HR Planning Tool So we have our module "position planning" where Employees were assigned to a position. Therfore we just made a Drop Down, where we can assign them. But now there comes the…
Creating a formula to directly change a User's "Model Role" as well as read/write permissions
I have created and set up Model Roles, Selective Access, Content Access, Permissions and a defining value applied on the lowest level of the list heirarchy for what I would like security permissions to be. I have 4 levels of security with the highest being Full Access, and the lowest being No Access. The inbetween levels…
Need help in Formula
Hi, guys! I'm doing a logical formula in my module that says if a Unit (Line Item) is classified as Current (List: Sales Type) then it will perform a certain calculation otherwise if it is Non Current (List: Sales Type) then it will display zero. Can you please recommend me a formula for this? Note: I have uploaded the…
Align Dashboard Columns
Attempting to publish 2 views to a Dashboard but just different versions so to be able to visually compare the 2. I hid the Department List column on Published view 2 so you would only see: Department, Column 1 results (Version 1), Column 2 results (version 2) The issue that occurs is the column 2 results will not align…
Unavailable Action Help
Hi I have a Button/Action on a dashboard showing unavailable, and if i look in contents i can not tick it, then comes the fun of trying to find which action, module, dashboard etc etc is the cause. I have been looking for an hour now and still no joy, is there a way this 'unavailable' could be more useful?
How many modules should be in one Model general?
Hi I'm planing to re-factoring our client's Models as some Models have over 100 modules which is not easy to maintain. Please advise how many modules should be in one Model in general. Best, Hisashi Yamaguchi
Ability to hide the email address from the blue toaster pop up
Description: We would like a way to eliminate the email address that shows up with the blue toaster box. Benefit/impact: We would like to eliminate this because we had a consulting group hang up the model and the end users were questioning why someone outside of the company was accessing our model. It created a lot of…
Global search/navigation - I want an easy way to find objects and data points as admin/end user
Description: Implement a global search across all modules/line items in the model. Please consider including the following: * In other software, there is a smart search feature when looking for a class, where I can type a couple of letters in upper case and it will match on words that begin with those letters. So the…
TEXTLIST as aggregation function, but only display unique
Hello, Is there a way to get the TEXTLIST function, when used in the aggregation format, to only display unique entries? I have the formula working in my model, but it is displaying every entry under the parent, rather than unique entries. I know that the normal TEXTLIST function has a "UNIQUE" option. Best, Matthew
Ability to use hotkeys to scroll page up/down
Description: Add Ctrl up and down shortcuts (or ctrl+Home or ctrl+End) to get to the first/last cells in the module Example of enhancement: Adding a page-up or page-down hot key would allow for quicker navigation through large modules/lists. Benefit/impact: Scrolling or clicking one by one is inefficient, and the faster a…
Save Subsidiary view as default
Hi When I click on the eyeball to open a subsidiary view, I get the default grid format with Time in columns. I can pivot the grid as desired, but then, how do I save this as the default view so that it opens like this when I click on the eyeball next time? I can use 'save as', the view is saved as a subsidiary view and…
Group models on the main launchpad by user defined groups.
Description: Group models on the main launchpad by user defined groups. Example of enhancement: Admins will be able to define groups in their workspace, which can be applied to models in the workspace. The models on the main screen will then display based on the group that they have been assigned. Benefit/impact: Currently…
Summary of Selected Cells Displays on Dashboard
Description: When selecting several cells in a module within a dashboard, we would like to see the summary (and perhaps average and count) of the selected cells displayed as well. This is similar to the customized status bar in Excel that shows the Average, Sum, and Count of selected cells.
Ability to collapse/group module views
Description: Currently Views when they are setup are listed under a module. It would be useful if there was a way to hide views, only show relevant views to users (i.e. they MUST be able to decide what they want to see not an ADMIN), or at the very least a way to collapse/group the views. Benefit/impact: Currently one of…

Modeling

Discussion List