Modeling

FIND list items by property value
Currently you're only able to use systm properties: Name and Code to identify List elements. Please add an optional argument in a FIND functions that would allow to use any single exact property in the selected list as a reference.
Code property
ITEM is not an occupied system property while CODE is. This makes the formulas ITEM and CODE not equivalent and thus inconsistent for Anaplan modelers. Since CODE() and ITEM() are very similar formulas, it would be nice to make their syntax similar. The practice that we use to keep formulas simple is creating “item”…
Copy-paste line item setting in blueprint
Previously you could easily copy-paste similar line items when working in Blueprint mode. Unfortunately at some moment this feature stopped working. Currently when trying to do so you receive the following pop-up at first: After that you see the following error:
LOOKUP towards a line item that has less dimensions
Please add an option to use LOOKUP function towards a line item that has less dimensions. For example: I have a line item that has three dimensions: * Client * SKU * Month I try to get some masterdata from Region, Month level that doesn't have SKU dimension. When I try to use [LOOKUP: Client.Region] towards this line item…
Develop error when adding to a subset parent
When creating elements in a list that has a subset as parent, we can get an error because some element have the wrong parent. It would be very useful to have a more detailed error, with for example the rejected lines.
Need unique element through versions
Hi! I've got a module with few dimensions, including versions, I generate code there for a list to update. So I need to filter unique code. Currently, I use formulae: IF RANK(1, ASCENDING, SEQUENTIAL, TRUE, 'List name') = 1 THEN 'List name' ELSE BLANK But it does not work properly through versions (return duplicates) Is…
Dependent drop down list
Hi, I have a mapping module in one of my models, where I want to map a sub-scenario to a scenario. I have one dimension in my module, a list called "Scenarios". I have one line item, "Sub-scenarios" where the format is a list-subset to a list called "Sub-Scenarios". The sub-scenario list if below the scenario list in…
Use process inside another process
We have some instances where we are incorporating multiple actions into more processes. Instead of adding action A,B,C,D,E,F into 4 different processes, we could bundle this into Process X. Process X can then be used in the 4 different processes. This will make the maintenance more convenient. E.g. we can ad action G or…
Formula Access Driver
Sometimes we have a list in which some list items should be populated via a formula and some other list items via a manual input. The way to model this at the moment is to create 2 line items enabling to input first and see the final amount that takes into account the formula. Obviously, from an end-user perspective, this…
Have display name overwrite for modules/actions
Hi, as model builder it would be very handy to start using naming conventions like in the blog of @joeymorisette Time to Tidy: No More Mess in Your Models. With some naming conversions it would also be easy to sort your modules/actions (or in theory any object) on name, however if you publish modules to a dashboard you…
Allow specific list grouping within the Admin Settings Panel
At present , the Admin settings panel used by model builders to create and build new lists for their modules and driving functions do not have the specific list grouping feature. Under Lists and Roll-Ups , we only have General Lists acting as the parent for all lists within the model. To create a better understanding of…
Easily see whether a list or module is used in an Action.
As a model builder, I want to see whether a module or list is referenced by, or used in, an Action. For example, in "General Lists", we can see whether a list is referenced in a module's "Applies To", as a Format, or in a Formula. But we can't easily see, for example, whether the list is used in a Saved Export. The same…
Have BOHY showing the YTG numbers for every Half Year period
Description of the enhancement requiredCould you please add to the enhancement list the task to add a new standard subtotal for timescale?We are very interested to have BOHY showing the YTG numbers for every Half Year Period.A story for why they want the enhancement, (how would it help their business process)We have been…
Ability to compared any two ALM revisions and obtain comparison report
Description of the enhancement: Ability to see a comparison/change report between ANY two model revisions which the customer chooses. How this would help your business processes: This would be very helpful for peer reviews and in general to understand what changed and what the original values / formula were.
Display Name User Selection
Hi, At present within Anaplan it is possible to dynamically change the contents of a Display Name (on a numbered list) and to give the end user the ability to change the Display Name (or its alias) as required. However the problem at the moment is that this solution is not scalable. i.e. if User A were to change the…
Data Mapping for Import failing
Dear Community, I need a help. I am trying to import import the Unit Cost and Sales Price. My file image 002 depicts desired output. Image 03 is the .csv file to be imported. But I am unsuccessful. I need help badly. Kindly guide me. I have shared screenshots for reference.
Source Module
What is a Source Module Tab?
Data Split
I have data of products sales in years (FY17, FY18, FY19 & FY20), how can i allocate it to monthly for a given financial year?
Automatic unique codes for nonumbered lists
A unique identifier is required for items in a non-numbered list. There shouldn't be an option to edit it even by administrators (analogue of #-code in numbered lists) An example of the enhancement: Add another system property called for example (system code) and make it noneditable but accessible through formulas and…
Keyboard Delete / Backspace should delete a selected dashboard object, ENTER should = clicking OK
Seemingly across the board in software the "Delete"/"Backspace" keys can be used to delete a selected item and "Enter" accepts the default button on a dialog. Building a dashboard in Anaplan is unnecssarily tedious because neither of these work. Lack of small quality of life workflow changes like these add up and makes it…
Currency Page Selector/Filter
Hi, I need to be able to create a DB that allows me to choose what currency to display. At the moment I have data in various currencies, a currency conversion module has been made which hosts GBP, Local Currency and USD. I've created the FX List. What I need to do now is on the dashboard somehow create a page selector that…
create a formula to show actual and forecast in same line
Hi, I need to be able to show actual data and forecast in same line item. I have an actuals line item, forecast line item, then total view line item. Formula i have written is IF Time filter.Actual Months THEN Actual ELSE Total Forecast It returns the forecast but I should be able to see actual months data, it returns 0.
How do I sum a selection of weeks using a look up
Currently we have a formula that is returning the last week of the month from the look up. How do I get the look up to do a sum of all weeks within the month ? CURRENTVERSION()'.h_collect previous version[SELECT: ..., LOOKUP: Time filter.'H2 End wk']) The H2 End week needs to be a sum of the month ...
using finditem when there are two of the same names in a list each with a different code
Hi, I have a line item in this module called "TPS System Takeout" and in the column next to it "TPS Competitor Report Type Classification" i want it to find the matching name in this list "CTO Competitor Classification Types" You can see that RaySearch was populated because the code for RaySearch in the list is…
Task option in anaplan
What is task option in anaplan ?. Can anyone give brief explanation on that.
How to split vendors into Above a certain amount, show vendor name, else show and MISC.
Doing an OpEx forecast. I have the usual OpEx Account list and Department list along with vendor list. However, on the module, I want to show vendors under the GL. When I do this, it shows all the vendors and I want show vendors above a certain amount. Any idea on how to approach this? I tried a numbered list but I can't…
Linking subsets to a new list
If i have created 5 subsets from a long list and a new list (Subset 1 to 5). Is there a way i can set the formula in my properties of my longlist to command that all items included in the subset 1 shall be tagged as part of the new list for Subset 1 instead of doing it manually? Thanks in advance! Appreciate your help! 🙂
Updation of master data and its reflection in spoke model
I performed an incremental load / full load of the master data(lists) from my Data Hub to a Spoke Model. Now, in my data hub, I renamed a list item in one of my lists and I want to update the same in my spoke model in some way without having to manually change the same in the spoke model. Is there any way to handle this…
Sum by lookup
Hi, I want to sum the total Categories in each Quarter-Year in this module using this column in this other module please help! Thanks 🙂 Amanda
User-Defined templates for new Modules / Lists / Dashboards (instead of a blank canvas)
As a model builder I'd like to be able to create a module template for use when anyone clicks "create new module" so that when any model builder begins making a new module the "empty module" they start from is my designated template. This would likely include various pre-named and formatted line items, categories, with…

Modeling

Discussion List