-
Time Dimension - date
Hello, Am trying to make a calendar in Anaplan to plot weekdays and holidays. Time dimension for the model is "DAY" and I wanted not to type the dates in each days, but to put a formula instead. What would be the formula to return the "date" of the time dimension to the line item. I tried to use "ITEM(TIME)" but it does…
-
Measuring Model Performance
It would be great to have access to metadata or to an Anaplan model which helps to measure the impact/usage of this model and it's performance by month (for example). If we can see how much do the users interact with a specific model/dashboard/module/action, we can analyze which dashboards are used more and identify areas…
-
Calculations
Hi experts, we mainatained joining date, Resigned date and last working day properties in employee dimension. Based on those properties we need to calculate previous 6 months Organization Active employees and resigned employees count. We create one module called headcount planning module.In these scenario current period is…
-
Property based filter
Hi Experts, In Employee list we maintained one property called Reporting Person. In Reporting person property we maintain reporting employee names for eg: manager reporting to owner , Supervisor reporting to manager,Staff reporting to Supervisor. In Selection When i select Owner position then Show all owner combination…
-
Locked model greys out Open button but not Copy/Delete buttons in Settings, Modules
Description of the enhancement required: The behaviour in a locked model is odd, while in the model module screen, the open button is greyed out, the Copy and Delete button should be greyed out too since trying to use them will result in error saying the "Sorry, the model has been locked by another user". Misleading to…
-
Property based filtering
Hi experts, I have a requirement But i am cofusing acheive the requirement. In employee list we are maintaining some Properties like (Joining date,Resign date,Last working day ,Position,Employee Type, Department,Salary properties). In Employee Module, i want to get data based on page selector selection. Suppose, in page…
-
Need Formula Help
Hi all - I am very new to Anaplan and have just finished the Intro to Model Building. As a test for me before going into Intermediate Model Building, I tried to set up a copy of a report I currently have in Excel. The report is to show revenue by PI for each month & the % of their revenue at the site they are located. I…
-
Formula does not work in QA but in Dev
Hi Experts, I am facing a unique issue, I have modified an formula on a line item with number format and it does pulls the resulted value in Dev enviornment but when the solution is migrated to QA, the formula does nothing and the line details read message as " Drill down unavailable for this cell: No other data cells are…
-
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