Modeling

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.…
To save records in the module, some kind of archiving within the model not the actual archiving.
So I am developing a model where I need to save the same module with different versions of it. Basically, I wish to make some changes and save it and someone else also should be able to make the changes and see it. I want to capture these modules with the changes made for the future reference.
Lookup in Anaplan but with different dimensions
Hi Everyone, I have 2 modules: The first being 'Module - Calculate' with 2 dimensions: 'Site and Services' and Time. It has 2 line items, number of days and total cost. The second 'Module - Rate Table' with 2 dimensions: 'Site' and 'Numbers'. It has 2 line items, number of days and Rate. Reason for separating the Rate…
Updated forecast version based on updated Actuals
Hi, I need some modeling suggestions on the following task. I am new to Anaplan versions and would appreciate your help. There is a demand forecasting module (Demand) subject to Actual and Forecast versions. Let us assume the only line item here is Demand.Units. The forecast values are for future timeperiods and are based…
Circular references Cash flow planning
Hello! The model that I’m building for the client includes circular reference. I need to calculate the amount of the loans and net debt that depend on the Free cash flow sum for the period. Free cash flow at the same time includes interests paid, that is calculated for the net debt. When i'm changing any parametrs that…
Merged: Native User Subsets
This discussion has been merged.
Standard lineitem format for each module (different from number)
We would like to have an option to set a standard line item format for each model / module. It would be nice if we could set a standard lineitem format for each module, so we can differ from the current standard of number formatted lineitems. For example, in my access driver module, I would like to have a standard boolean…
how to add new member in a list (not numbered) from a dashboard
Hi Experts, I have to create a dashboard and use it to update an list. New members will be added in the dasboard which will add member in the list. This list is not a numbered so i cannot use create button. I have manage to udpdate the list properties via import but cant figure out how a new member would get created or…
Front door SDP Launch pad Customer display
On frontdoor when logged in showing available models and workspaces, instead of Customer with drop down, show selected customer name
Version Selection
Hi Experts, In page selector When i select Version selection.The following periods need to show remaining periods are hide Version is actual then i show previous 6 months actual periods non-editable Version is forecaste then current period to end of the with in the year data. Version is Budget then next year all periods…
Ability to double click and open a summary line item
Hi, It would be nice if we have the ability double clicking to open a summary line item.

Modeling

Discussion List