-
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…
-
History Enhancement: Details of changes to workflow status
Description: Currently changes to workflow status appear as follows in model history. ||ID||Date/Time (UTC)||User||Description||Previous Value||New Value||Module/List||Line Item/Property||Target User|| |0001|2017-01-01 00:00:00|user@anaplan.com|Model change (no details available)| | | | | | This does not give any…
-
Documentation/text on any object in the model (model documentation)
Description: As an administrator, I should be able to put a text description/documentation on any model object in the settings tab or blueprint. This should include: * Line items (in blueprint) * Roles * Versions * Actions * Modules * Dashboards * Lists * Properties * Subsets * Line item subsets Note that I should be able…
-
Mailto function multiple line body
in regard to the mailto anapedia, how to have the body of the email to have multiple lines? i.e. how to make %0D%0A work in to the mailto formula?
-
Copy/Paste not working for computers set to different number formats. Requires "locale."
Description: When copying a cell in Anaplan, the underlying value gets copied (ignoring the 'Decimal Point:' format set for the line item), and the browser's locale is used to set the decimal separator. This is flawed for companies with users in various parts of the world. eg, Anyone with French browser locale (which uses…
-
Set default level in page selector on grid
Description: As a model-builder, I want to be able to set the default level for a page selector on a grid published to a dashboard. Example: For example, on a composite hierarchy, I might want it always to default to the lowest level, regardless of a user's selective access. Note that if a user can save their own default…
-
Read/write access by line item
Description: Enable read/write access by line item. Examples: Hide intermediate calculations, and don't let the end user see them even with Show All. Disable data entry where some line items are imported.
-
Request for keyboard navigation and selection in TreeView of List Settings
Description: With the mouse, I am able to select multiple tree nodes and drag-n-drop them to a new location. This is great. I would like to be able to make the tree selection using keyboard and close with the drag-n-drop, or a Copy-Paste operation to complete this action. Example of enhancement: Steps would be: 1. Focus…
-
"Show Hidden Content" negates restricting access to Roles
Description: If you are not a WSA and certain views have been hidden from you in the "Contents" tab, you can show them using "Show Hidden Contents". This was always possible but wasn't as explicitly available as it is now. Users can edit these 'hidden' modules, probably because they have Write access, but this is not…
-
Suggestions on how to optimize data imports for a Real Estate Company with many products
Our company is a real estate developer and I am having a problem dealing with too much data. For example, we consider our condominium units as our products. These units are unique from each other (i.e. they have different unit number for each building and for each project development.) In short, no two units are the same…
-
Dynamic Versions in Anaplan
Hi Team, My model has 4 versions: Actual Version: Monthly Input Forecast Version: Once yearly Input Q2 forecast Adjustment: Q3 Forecast Adjustment: Let's suppose we have forecasted for whoel year and users are done with Actuals input of Jan,Feb,Mar,Now the Higher management wants to adjust there forecast for Q2 in which Q2…
-
Ability to archive versions in a model
Desription of the enhancement: We would like the ability to 'archive' versions within a model, so that we can save the data and look back at it later, but it will not take up space. Note that version subsets will not fully meet this requirement, because if you remove a version from a subset in a module, you will lose data…
-
Include slicer functionality similar to excel - i.e. save filters in a button
Description of the enhancement required: Enabling slicer facility in Anaplan tool like the one in Excel https://support.office.com/en-gb/article/use-slicers-to-filter-data-249f966b-a9d5-4b0f-b31a-12651785d29d How would it help your business process: Customer would need this facility of Slicer enhancement due to multiple…
-
Improve error message where you are unable to give a list item a child
Description of the enhancement: Improve error message where you are unable to give a list item a child, if it has a child item in a different list You are unable to give a list item a child, if it has a child item in a different list. Error: "Parent item has a child item that is in a different list: You can only add a…