Modeling

Filters on import to list actions
As a model builder, i need to be able to filter the list items created based on a criteria. This is required as we currently operate models that determines a calculation scope of contracts and the needs to import the corresponding cashflows to calculate profitability. Currently we need to import all cashflows from our…
Chart Data Labels - Show only one, and make font bigger
Hello - Is there a way to show only one of the data labels in a combo chart in the New UX? a lot of data labels are overlapping each other and it looks like a mess. I tried manually updating the scale, but then the scale doesn't look right when I make different selections. Being able to only have one data label would be…
Versions as list format
Make Versions available as a list-format. Benefits: Allows the end-user to select the version they want to look at from a drop-down making for better variance reporting. Allows you to map from a normal hierarchy into a version dimension *Excel add-in needs to support & support with filters
Introducing the Connected Planning Playbook
Connected Planning isn’t easy. That’s why we can’t help but smile a bit when we hear our customers and prospects say, “Well, of course, Connected Planning at Anaplan is great. It’s what you do!” The reality is: our own Connected Planning journey was hard. And, if it was hard for Anaplan, it had to be hard for our…
Additional practice models/builds
Hi Anaplan Community! I've completed the certified builder program, but am wondering whether there are any additional practice builds out there that I can attempt? e.g. I'd like to practice building an ICM/SPM model. Thanks!
Train the Trainer
Will there be "Train the Trainer" courses beyond Level 2, so our Team can be certified Anaplan trainers? If so, has the course changed titles? We can't seem to locate any current "Train the Trainer" courses. Thank you for any help you can provide.
List item has nothing showing in 'Referenced in Formula', but it is referenced?
I have a list that shows no references, and i was removing ‘dead’ lists however, when i tried to delete it i got an error saying it was used in a module. And after looking i found it was indeed used So why does the reference not appear in the list information?
OEG Best Practice: PLANS: This is how we model
PLANSPLANS is the new standard for Anaplan modeling—“the way we model.” This covers more than just the formulas and includes and evolves existing best practices around user experience and Data Hubs. It is a set of rules on the structure and detailed design of Anaplan models. This set of rules will provide both a clear…
Ability to record timestamp of input as a separate line item
It would be extremely helpful from an end-user and a workflow perspective to have the ability to capture the timestamp of a manual input as a separate line item, instead of having to look through model/cell history manually. That way you could easily see when the latest input was entered.
Building a Long Range Planning Model
Hi, I'm a new Anaplan user (completed L1 model builder). I'm starting a project to get our current Long Range Planning model from excel into Anaplan. This is my first project and I'm wondering whether other group members have any similar experiences. There is a template LRP model in the App Hub which I'm considering using…
Level 1 Modeling Activity #5
Hello - I have been having similar issues with the formula updates to the Bonus%, Car Costs, Phone Costs and Medical Costs in the EMP02 Module - when I try to update the formula as below I receive the error message. I am seeing posts about removing the Role List and reimporting without the Parent Column and the reimporting…
RANDOM() function
Function that will generate random numbers, between specified min & max values. Excel has two functions to provide random numbers: RAND() generates a decimal value between 0 and 1 RANDBETWEEN( x , y ) generates an integer >= x and <= y It may be worth considering an extension to these functions such as: RANDOM( x , y , z)…
SKU to Format, Flavour, etc
Hi Guys. I have the following issue with our Anaplan implementation. Our SKUs can be rolled up either to Format (FO), Flavour (FL), Volume (VO), etc. All these have parents such as F1 > F2 > F3. The common denominator between all of them is the SKU. I have created a SYS module that has all of these as properties, therefore…
Retrieving user selective access in module
Hi, I have an issue in my Workforce Planning model I can't quite get my head around. The scenario is the following: I have an organisational hierarchy with Cost Centers and then Individuals as childs. I have selective access enabled to my cost center list and only certain users have access to certain cost centers (and…
Is it possible to have a "Create" Action on a list with no parent?
Is it possible to have a "Create" Action on a list with no parent? If not then is there a workaround?
Schedules Mapped by Entity Name in Anaplan
In Anaplan, I have a schedule that needs to have the name of an entity name change to the English version. I was put on notice recently, that the schedule is being mapped by the entity name. Can anyone provide guidance on how I would be able to see in Anaplan exactly how that schedule is being mapped by entity name and…
Sum based on Parent in Hierarchical List
Hi, I have a hierarchy of lists, L1>L2>L3. My module is dimentioned by L3 and has two line items, Input value and Input %. Input Value is entered by user. Input % = Input Value/Sum of Input Values for all list items of L3 under a L2 list item. How can I calculate this sum, as it is the sum of all items in L3 under L2 a…
Level 2 - Sprint 1 - 1.5.2
Review DAT01 Beginning Inventory Module * Module Name: DAT01 Beginning Inventory * Dimensions: SKU Flat list, s Location Flat: Distribution Center? list * Category: Master Data Line Item Format Purpose Beginning InventoryNumberBeginning inventory count (opening stock) for each product SKU by Distribution…
Retrieving last non zero value for daily exchange rates
Hi, I have a daily exchange rate module which store the daily rates for multiple currencies. I wanted to get the last non-zero value for each date for example we have daily exchange rates for 1 Jan 2021 but none for 2nd and 3rd of Jan 2021, so the daily exchange rates for 3 Jan 2021 should display the rates of 1 Jan 2021…
OEG Best Practice: Formula structure for performance
Thinking through the results of a modeling decision is a key part of ensuring good model performance; in other words, making sure the calculation engine isn’t overtaxed. This article highlights some ideas for how to lessen the load on the calculation engine. Formulas should be simple; a formula that is nested, or uses…
How to move or copy an excel spreadsheet without loosing connection
I'd like to merge 2 excel files. Both have anaplan connections. How can I move or copy excel spreadsheets to another file withour loosing my anaplan connection?
CloudWorks
Hi, I have just started using CloudWorks, it's a great Anaplan in-built tool for integrations and processes but does anyone have any idea how can we run subsequent process in it. for ex. I have a process A and process B in my model and I want to run in a manner that as soon as process A is complete, Process B should start…
Mouseover Hover Text for Model Builders
I think it would be helpful to model builders if there was a hover over option to display the text of a particular element. There are instances where the description is cut off for certain display elements and there is no option to resize columns for that element (I see this most frequently in the Module Blueprint and Data…
Talent Builder Workspace Extension
Hi Community, Currently we are using talent builder workspace for all learnings and have exceeded 90 days trail period. Is there any way to get an extension of the time limit? If we reapply for new workspace will the old model stays as it is or do we have to create the model from scratch? Thanks & Regards Badam
Allow column Formatting on Lists Grid View
Lists with multiple subsets (having long SS names) become confusing in grid view where columns only show partial names in headers. There should be an option to format columns similar to modules to increase column width etc.
Can you link to a specific record on a new UX page
I have a list of projects and i have a line item that is a link to the project page, but would like to go to the specific project they are clicking on. The html for the page is the same no matter what the item, but can you add a tag to the html at all, like you can in other apps?
PlanIQ Error
Hi, Do you know what would cause a 'PlanIQ Flow Trigger Failed' error @Misbah
Expand "Tree View" for Lists beyond 1,000 items
Lists automatically convert from "Tree View" to "Grid View" once the 1,000 item limitation is reached. In my opinion, the Tree View is much more aesthetically pleasing and easier to navigate, particularly as the data set gets larger. It would be great if the Tree View was maintained for an infinite amount of items (or at…
Add List Search Option while create module and Import from Existing Model
Hi Team, If we provide a search option to select a list when creating a new module, it helps model builders select the required list. Similarly, if we provide a search option to select the source for any import from existing model views or lists, it also helps model builders.
Add List Search Option while create module and Import from Existing Model
Hi Team, If we provide a search option to select a list when creating a new module, it helps model builders select the required list. Similarly, if we provide a search option to select the source for any import from existing model views or lists, it also helps model builders.

Modeling

Discussion List