Modeling

Add a Parent to a Line Item Subset
It would be nice to be able to add a Parent list/hierarchy to a Line Item Subset.
Multiple hierarchies sharing same children
Is there a way that you can assign multiple parents for a list member? Or when you need to build an alternate hierarchy sharing the same children of primary hierarchy, you have to create a new 'child-list'? Thanks.
Adding and removing Workspace Administrator Privileges to be correctly recorded in Model History
Description: I would like to be able to record the action of adding or removing Workspace Administrator Privileges in Model History. Example of enhancement: * Open Settings -> Users. * Tick Administrator Privileges for a user who does not currently have them. (eg. tester@anaplan.com) * Un-tick Administrator Privileges for…
A way to only see lowest level in dependent dropdowns?
When using dependent dropdowns, is there a way to make the module only show the lowest levels? Currenly the lowest levels are the only selectable options, but it still shows you the hiararchy above that - just greyed out - which can look a bit untidy when trying to make a simple dashboard for an end user. Thanks.
Timeline Charts
Hi Please can somebody throw some light on timeline charts? Anapedia offers this....... "Ensure the data items are date-formatted line items displayed across columns." This seems a little vague, does anybody have an example or some guidleines please, as i have a project model and would like to show a timeline chart (as a…
converting a list of postal codes into postal code ranges
Hi, I am trying to write an array formula in Anaplan which converts a list of postal codes into postal code ranges. He is the link for an Excel equivalent formulas. https://www.mrexcel.com/forum/excel-questions/411304-creating-zip-code-ranges-one-list-help.html Can anybody please help me to write this formula in Anaplan.
Creation of General list for user data entry
Hi All I am trying to do some simple setup in Anaplan and need your help.I am trying to create a general list with few columns where user will enter data. We dont need any hierarchy here and we are trying to mimic the attached excel sheet format in this proposed Anaplan list. The idea is user will maintain the data in this…
Show full numeric value in Drill Down and hover over
When I drill down into a calculated numeric value, I want to see the full numeric value of the source cells that play into the calculation. Right now, I only see the rounded value based on the Number format that I have set for the cell. It would also be helpful to, as a user in a dashboard, hover over a value that has been…
Improve sequence of list subsets in "Applies to" column of blueprint
IDEA: Sequence of dimentions in "Applies to" column of blueprint should be same to "New Module master" Imagine you need to create a new module. Just click "Insert module" button and select appropriate dimentions (lists/list subsets/line item subsets). New module master has user friendly sequence of dimentions to select…
Guru hours?
I'm working on simplifying our model and introducing pretty straightforward Forecasting capabilities to the deployment. I've heard that we have access to guru hours. What are guru hours?
Versions page selector for only the Prior Forecast column
Anaplanners: does someone what formulas would allow me to reference another forecast for the Prior Forecast column? I want to compare the most Current Forecast against whatever forecast the user chooses (April, May, etc). Would appreciate any guidance and thanks as usual.
Formula to calc workspace size
I am trying to determine the workspace size I will need for my organization. Is there any formula to calculate that (e.g. # cells x bit/byte or some other way to calculate)?
Module to Module Import triples source values
Hi, Anaplaners, I have faced an issue where module-to-module import triples values of a source module. I am trying imporitng between modules whose structures (lists in row/column) are exactly the same (only line items differ), but for some reasons, values triple everytime execute an import between the modules. Do you have…
User-list filtering
A user-list filter that would show the current user on dashboard views and other outputs, to record who was looking at the user
To have the functional capability to sort by column-specific attributes
A description of the enhancement required: To have the functional capability to sort by column-specific attributes An example of the enhancement The basic sorting functionality offered by excel, wherein one can sort column-specific data by alphabetical and descending / ascending order A story for why the enhancement is…
Collect Function doesn't work
Hi, guys! Collect function doesn't seem to work on the model that I am currently building. I have created line item subset using one of the modules I have created. I used this line item subset in my current module which has the same dimensions as with the source module where the subset comes from. I can't figure out why is…
Selective access list to generate a date when changed
Hi, I have a slective access list for approving a transaction, where certain people can approve a process or reject, challenge it. When they choose 'approval status'.approved', i would like to add the date to a line item. Adding a date to a line item is easy enough, HOWEVER the date field cannot be open, or people who do…
Allow copy/paste from right click menu (without using hotkeys)
When you click copy and paste in the right click menu in Anaplan, copy works, but paste tells you to enter the hot keys instead. I would like my end users to be able to click paste and have Anaplan paste the value with out them needing to use the hot keys. This would be a benefit as it would help end users that are not…
RANK with Selective Access
I'm trying to build a module that displays only the top ten cost centers based on a variance line item that I've got calculating. I'd gotten it to work with a RANK formula and then a boolean line item, but then when I started trying it with selective access set up on the cost center, it broke and I only see a few of what…
How to find Delta value between current period record and most recent period records.
Hello All, Need you help in calculating the credit for sales rep month by month for Orders he is working on. Order#Order StatusInitial Order DateOrder Change DateNet ValueDeltaPayout 111Initial Order01-Jan-18 100100100Jan Credit111Changed 01-Feb-18150150-10050Feb Credit111Changed 01-Apr-18300300-150150April Credit…
Ability to rename a line item without breaking the import mapping
Description of the enhancement: If a line item which is used as the source of an import is renamed, its mapping is removed and the action must be re-mapped. To re-create: * Setup an import from "LineItemA" in ModuleOne to LineItemB in ModuleTwo. The line items will need manually mapping since they have different names. *…
Showing Module Notes on Model Map
The new notes functionality allows a brief description of each module to be added to the Anaplan model. This is great as it provides in-model documentation and also forces model builders to really think of the purpose of each module and justify its existence in the model. This enhancement idea is to display these module…
Ability to assign Versions to line items
Use case: Import of transactions into a List where properties are defined to specify the dimensions (Time, Version, Entity, etc). I am not able to make a connection between a Text item and the Version. The Versions is needed for the customers who not only import Actual transactions but also other Versions (Forecast/Plan…
Collect Function doesn't work
Hi, guys! Collect function doesn't seem to work on the model that I am currently building. I have created line item subset using one of the modules I have created. I used this line item subset in my current module which has the same dimensions as with the source module where the subset comes from. I can't figure out why is…
How can you capture the last update date in a list?
Hi I have a requitmemtn where the data is maintained in a List and when the user updates the data (edit/create),then we should capture the system date in a column in the list. This is to know when the data was last updated. Appreciate any pointer on how this can be acheived . Thanks Regards rabakaran
Collect Function doesn't work
Hi, guys! Collect function doesn't seem to work on the model that I am currently building. I have created line item subset using one of the modules I have created. I used this line item subset in my current module which has the same dimensions as with the source module where the subset comes from. I can't figure out why is…
Naming Convention : tips
Hi, anyone should read an apply the Naming conventions which are described in Anapedia. I found it usefull to add some personnal ideas. When you build a model, you will often find duplicate names for : * module (Sales Plan) * dashboard (Sales Plan) * action open dashboard (Sales plan) Of course Anaplan will prevent using…
TEXT function to have the option to convert the displayed format
Description of the enhancement: Currently using the TEXT function it will convert the underlying number. For example, if you have: Line Item 1: Number format, set it to 5 decimals - value: 0.0000005 Line Item 2: Text format, Formula: TEXT(Line Item 1) Result: 5-E07 Desired Result (in TEXT FORMAT): 0.0000005
Budget Rejection
Hi All, What is the budget rejection mechanism in Anaplan? Is there a way to reject budget submitted by cost center user, reviewed by manager and rejected, which then notifies user via email for instance Regards, Andre
How can you "Paste Link" in Anaplan
Could not manage to “paste link” the TO PAY (SAR) column (manually inserted in module X) from X module to Y module. The look up unique identification is the Transaction No. OR Document Number. Can you help? Module X PAGE: Bank Element List Vendor NameVendor CodeVendor CategoryDocument NumberAmountTO PAY (SAR)OUTSTANDING…

Modeling

Discussion List