Modeling

Ability to modify cell values by adjusting a graph curve
Description of enhancement: Be able to modify values by relocating the curve indicator on a graph. How it would help you business process: As-Is behavior of our forecasting application: it allows users to review easily their scope of forecast without modifying measures one by one.
How to Export a Dashboard to PDF?
I created a dashboard in one of the models I am developing. I want to export that dashboard out as PDF. I found this https://help.anaplan.com/anapedia/Content/Dashboards_and_Visualization/Work_with_Data_on_Dashboards/Print%20a%20Dashboard.html on anapedia, it says * Open the dashboard to be printed. * Click Export on the…
Used IRR formula in a Model but it is returning NaN as result whereas when Same numbers are given as
Used IRR formula in a Model but it is returning NaN as result whereas when Same numbers are given as a input to IRR formula in Excel it is returning a numbe
"Select All" for selective access
When you have several items at the top hierarchy to select in User Selective Access it can take some time (esp if there are 20+ items). It would be nice to have some way to "select all" to save time. (Then if you don't need all items you can remove them quite easily).
Optmizer constraint error - non linear constraint
Hi, I am working on a production planning optimization problem. I am building a minimum order quantity functionality using a binary variable. But I am getting error message 'The constraint has a formula that is not liner'. when I am removing this binary variable the error is resolved. Isn't it possible to use the binary…
DASHBOARDING TIPS
Dashboards play a very important role in model building as it acts as a reporting view for the end users. It provides the end users a glance view of its key performance indicators and data relevant to a business process. It can also be named as a Progress Report/Worksheet. Dashboard Design is an iterative process. It can…
How to synchronize Line Item Subset based on Line item ?
Below is my requirement -- I have a monthly module with 100 line items ,I want to input data and comments for each line item. I tried in this way -- 1) Create a input module with 100 line items and input data .(Module1) 2) Create Line Item Subset of above module .(Module1 LIS) 3) Create third module for input of comments…
Give dashboard elements a "Notes" field so Model Builders can leave development breadcrumbs
When working with a team of model builders sometimes changes to a dashboard aren't obvious, so it would be helpful to be able to leave a note behind for others to read. I could see this being helpful for when a button is added to a dashboard, or a filter is adjusted or a section is moved to a different place, a name of…
Let Dashboard Text be Selectable for Copy / Paste
There are many times where I find I'd like to select dashboard text to use as a reference or to send to someone in my company via email etc. It would be nice to be able to select the text on a dashboard's Title, Instructions, headers, notes etc. to use for copy & paste purposes. Better yet, let the model builder have the…
Maintain & Return to Model Builder's last Position in Modules / Dashboard / Actions lists
The search feature in these lists is nice, but anytime I have to switch between them I have re-find what I was looking at when I go back. A major, yet simple quality of life improvement for model builders would be when I switch between these lists, hold the scroll position I was on and take me there when I return. For…
Ability to Set an Action Button's Tooltip text globally at the Actions list
I like to use the tooltips to be able to customize what a user sees when hovering over an action button on a dashboard. But in larger models it means if I want each instance of a button to all tell the same story, I have to hunt them all down and change them 1-by-1. It would be very helpful to be able to set the button's…
Finding UTF8 Characters
It's useful sometimes to add a special character to an attribute in Anaplan. For instance, a special character can further deliniate and mark the name of a list or module to add another dimension to a model's back-end organization. Alternatively, use it in conjunction with a consistent process and include select characters…
creating transactional store of plan data
I have various modules which use numbered lists as children of cost centres. Users add items to these numbered lists to capture planned costs for different activities over time. To export data to our reporting tool I've created a module which collects the values dimensioned by cost centre, gl and time. It is…
Drop down Selection menu in Dashboards
i have a numbered list with hierarchy, suppose the items in the list are PC-A , PC-B, PC-C, PC-D. When i publish this list in dashboard as page selector, i am seeing PC-A, but the requirement is i should only see A in the drop down. How to do this? Regards, Adhvi
Model Map
I want to print my model map on a big sheet of paper so I can get a good look at it. Can I export the map to a PDF or similar document somehow? Thank you, Mark
Create list which is a combination of multiple lists
Hi, I am trying to create Revenue Module which should include accounts, Cost centre, Projects & products (4 different lists). But i am getting exceeds size limit error when i try to include all 4 lists in one Module. Can someone give any suggestions to build this module? Is there a way to create one seperate list which…
Better Model Analytics / Sizing
It's currently difficult to understanding how a model size will scale if list(s) need to increase in size. It would be helpful to have at least module level size calculation detail easily available within the model. It would be even more helpful for a systematic mechanism to "estimate" model size based on list changes…
Make dashboard titles that appear in "Used in Dashboards" columns clickable hyperlinks
When trying to work in Anaplan I find there to be a lot of "dead ends", meaning I have find where I want to go, but I have to stop, back out and go there in an unintuitive way that breaks my workflow. The "Used in Dashboards" and "Referenced By" columns are helpful to trace where things are used, but I still have to leave…
Ability to format a cells by logic instead of numbers such as blank or not blank
Hi Anaplan, It would be really useful and if you could format cells by logic instead of numbers directly on the cell. This could work by having blank or not blank in the formating parameters or true or false. Thanks, Usman
Ability to select copy/paste from right-click menu
Description: We would like to have the copy and paste buttons added to the right click menu. Ctrl+C and Ctrl+V work, but not all end users are proficient at this. So the actual buttons are needed as in Excel. Example of enhancement: In the right click menu, please add in the parenthesis Ctrl+C and Ctrl+V, so that a hotkey…
Comparing partial SUM values of lines of a list.
Hi, Anaplaners From the first table in the attached file, I would like to compare (calculate changes in values in %) first year vs second year and second year vs thrid year. The former compares sum of 2012 - 2015 (2016 should not include as 2016 for the second year is always zero) and the latter compares 2012 - 2014. Is…
Auto size columns
Description: As a model builder, I'd like to be able to auto-size my columns Example of enhancement: Auto resize option in column settings
COUNTIF - How to add sequence numbers within groups of repeating values
In Excel, I can apply sequential numbers within each group of values. For example - Column A has groups of values which Column B applies sequence numbers to the members of each group. The number sequence in Column B is generated by COUNTIF($A$2:A2,A2) which is copied in every cell in the column. I see that Anaplan's answer…
Action type that eliminates need for additional check box
Add an action type that allows for creation of new rows without needing to select an additional boolean checkbox Many actions require selecting a check box in addition to click a button. These should be consolidated into one step to improve user experience
Linked Formulas
Forgive me if this has been posted, but I did my due diligence and nothing turned up. It would be awesome if formulas had a click-able hyperlink to its source cells, similar to when you double click on a cell in excel to show a formula and it highlights the precedents. Its also similar to "Drill Down", but instead of being…
Show % formatted items description as a % rather than just showing description as 'Number'
If I format a line item or property as a % it is only shown in the blueprint or grid view as 'Number'. It is not easily identifiable as a % wotjout going into the line item and checking the % option has been ticked and the number of decimla places. Could we have this shown as a format description as 'number% 2dp' for…
Removing empty Numbered List items from Module with Time & Version dimensions
Hi all, I want to be able to create a "cleaning" dashboard that removes redundant line items from a numbered list. I have a module that has the numbered list in question with dimensions TIME and VERSION, which acts as my data hub and records all the information for reports on the system. My first attempt to build this view…
Version serlection
Hi Experts, Filter Module Row axis -Line Item Members- 1)Actual filter 2)Forecaste Filter 3)Budget Filter 4)Plan filter Column Axis -Time -Future 4 years 1) Actual filter applies only for actuals Version only but inthe above screenshot it applies all versions. IF Startperiod>Period(currentperiodstart()) AND…
Connecting two subsets in formulas
Description: I want to save server space and put all promo packs to a subset, but I have two types of promo packs, which have different calculations. Eventually I am obliged to sum them up without use of subset, which occupies a lot of excessive space. Example of enhancement: Create total promo packs subsets out of two…
MAX, AVG, NON BLANK over list dimensions and YoY Averages (seasonality) for TIME dimensions (2 Q's)
I have a Line Item "Conversion %" in a module that applies to a fake time dimension list called "Aging Days" that ranges from 0 - 365. Module: 0 / 1 / 2 / 3 / 4 // ... // 365 Conversion% 1% / 1.5% / <blank> / <blank> / 1.6% / 1.6% / .... // 26.5% If you see the above data, it is a curve (cumulative %) over 365 days.…

Modeling

Discussion List