-
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…
-
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…
-
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…
-
Filter option should select highest parent hierarchy as default
Description of the enhancement required: When there is a filter (dropdown) in a dashboard, customer wants the biggest parent as the default selected item. For example, "Total region" is always selected at opening. How would it help their business process: They use filters in all of their dashboards, and as admin or user,…
-
Match subsets automatically in import mapping when names are identical
Description of the enhancement required: If we create Subsets in a new target list with identical names, Anaplan should be smart enough to match those with the source subsets when running import. Unfortunately, the system appends " / Is Member Of" to the source, causing the matching on name to fail. This causes the user to…
-
Ability to wrap text on line item names
Description of the enhancement required: Word Wrap for Line Items and/or Rows instead of just Columns An example of the enhancement: Ability to wrap text on a dashboard without having to publish the line item as a "selected line item" How would it help their business process: Majority of the line items or members on rows…