Modeling

How I Built It: Creating functional P&Ls using line item subsets without COLLECT formula
Author: Austin van der Linden is a Certified Master Anaplanner and Senior Model Builder at Hubspot. Hello Anaplan Community! In this 'How I Built It' Tutorial, I show how you can build functional P&Ls using line item subsets as a mapping tool. One of the cool functionalities provided with line item subsets is that you can…
Number Formatting Precision / Stop dividing by 1000
I would like to propose a feature to instead of dividing by 1,000 to show items in thousands or 1,000,000 to show numbers in millions, that this is handled by the number formatting. This is a little used feature in excel where you can apply a format to a cell with the value $32,500 to display as $32.5. In this case the…
Share your feedback: modeling experience (deadline extended!!)
The product and UX team at Anaplan is looking for your feedback on your current modeling experience, specifically focused on building an appreciation for the challenges you face as a model builder in Anaplan. This survey is designed to capture this detail, so that we can explore how to simplify and accelerate the modeling…
Convert Months to Quarter
Hi, How can I sum my months to get the quarter value in another module? My source module is using month, i turned off of the summary SUM for Time. (to save space) My target module, i want to get the quarter value of my source. Thanks, Tom
DCA - How to lock/unlock checkboxes based on selection? [No Dimension]
I have a module (no Dimension) with 5 -line items labeled 'Custom 1' through 'Custom 5'. When any 'Custom' checkbox is selected, all other checkboxes should be locked but the selected (example: Custom 1) one should remain editable. If the selected checkbox is unchecked, all other checkboxes should become unlocked again.…
Approach for managing conditional formatting colors in one place
Thought I'd drop this here in case it's helpful to anyone. Business Need To promote a consistent user experience and an intuitive application, we want colors to be used in a consistent manner across an application. We also want it to be easy to quickly and easily change those colors in the event of: Changes to user…
Selective Access on Flat List Subsets
Currently, selective access write permissions must be granted to a parent item for end users to modify an item's subset membership. In the case of a flat list, the items do not have a parent, which means users cannot modify the inclusion of these items in the subset. This has created challenges within my organization, as…
Level 3 - Ask the Stakeholders - Establishing Sales Targets
Level 3 - Ask the Stakeholders Establishing Sales Targets Process Questions This forum is for asking the stakeholders of the Unicorn Candy Company questions about the Establishing Sales Targets Process. The Anaplan Academy team will be monitoring this forum during US Central standard business hours. Please allow up to 3…
Can i have 'Create Action' under a 'Process' which includes other Actions (Import/Export Actions).
I am trying to create a process for the user where he can create a record to a numbered list using 'Create Action' and add attributes to it in a module & keeping this process as base, I am trying to export this record & Attributes to external ERP System using 'Export Action'. Can i conclude all this in a single 'Process'…
Customized Drill Down
Anaplanners, We have a module (Module A) that displays the monthly income for each department across various locations. Module A includes the following dimensions: Department, Location, Time, and Value (Line Item) We are presenting this data at a higher granularity in another module (Module B):Module B includes the…
Is there any way i can convert number to text format but still following the number format for comma
Unable to convert number to Text following comma format, Could anyone help me out of this problem? Thanks in advance
How to use notifications effectively
Author: Vinay Varadaraj Mirajkar is a Certified Master Anaplanner and Senior Solution Architect at Anaplan. When you think about creating simple workflows or enabling collaboration between/within the planning teams, some of the features which can help achieve this are: sharing pages, card comments, notifications, and last…
Setting up action naming conventions that will withstand the test of time
Author: Taylor Giesler is a Certified Master Anaplanner and Director, Enterprise Performance Management at Alpha Alternatives. I have been a consultant for nearly four years now, and I have seen a lot of models, some easier to follow than others. The person building the model isn’t always the same person maintaining it…
New UX - Conditional formatting multiple line items the same
Hi, I have a dashboard with 20 columns, all of which share the same complex conditional formatting rule that consists of 12 midpoints. Setting up one column takes a little time, and I need to repeat this process for all 20 columns. It would be really helpful to have the option to apply a formatting template to multiple…
CIM Phase II - Live
You must be aware that CIM Phase - 2 has gone live today. With the advent of this phase, User admins will be able to * Create new users directly from Admin Console. Remember if the user has been added without assigning to any workspace then the user will be considered as a dormant user, meaning s/he will not have access to…
Bulk Copy Action - Line Item Input
Great addition this past weekend with the Bulk Copy Action so that it can be tied to a process. As another enhancement to this feature - it would be great if the model builder can set line item values to drive the input - similar to the update current period action released prior.
Allow for line item subset to be more than just number formatted
Description of the enhancement required: Line Item Subsets are often used to build filter modules, as an alternative to using the Show/Hide functionality. Using a Boolean against a Line Item Subset on a filter module makes it very easy to select which columns should be shown or hidden on a dashboard. An example of the…
Composite hierarchies List and Production Data
Hello Everyone, I recently took over the model development from a previous team, and I'm looking into optimisation options. One issue I came across has to due with Composite hierarchies List used for Selective Access, as per the example below: G1 Group - Used for Selective Access - Set as Production Data - No changes in…
How to roll back a production model to recover lost data
Author: Jessie Zhao is a Solution Architect and Certified Master Anaplanner at Anaplan. Working with a model in ALM has a lot of benefits. These include building new features in a development model anytime without affecting production users, securely managing production lists by identifying structural data that needs to…
Ability to mask or sanitize all of the Production Data within a model
I would like to be able to easily mask all Production Data within a model. Currently, this involves a lot of manual effort. For example, replacing all names with fake names, and all numbers with fake numbers. Being able to do this is useful for a couple of different purposes: * If I need to have Anaplan Support take a copy…
Event recording available! Model design best practices
If you missed our event yesterday, November Challenge Recap: Model design best practices, a recording is now available. Last month, we invited the Anaplan Community to share their best advice for model design. In this recap event, speakers Rob Marshall (@rob_marshall) and Adam Trainer (@AdamT), both from Anaplan’s…
Calculate the total interest from the first blank to the last blank in the 'Interest Expense' column
I have a sample where there are loan dates. For each loan date, the nominal interest will be calculated from the first non-blank 'Date of Loan' entry to the last non-blank 'Date of Loan.' The total interest will then be inserted in every non-blank 'Interest Expense' line item.
Send an Email Notification if a Line Item Doesn't Equal 0
Is there a way to send a notification to specific users if a variance/line item is not equal to zero?
Copy Branch Workaround for the User Experience
The ‘Copy Branch’ action hasn’t currently made its way onto the UX, so I was recently challenged to create a workaround. This is my relatively simple solution, which could be amended for “Assign” by deleting the items in the ‘copy from’ list once copied. It should be noted that it is not a best practice for users to run…
Bulk Copy Action for Production Lists
This idea relates to the Bulk Copy action enhancement released in a platform update earlier this month (Nov 6 2021 release). (Thank you by the way for that enhancement!) We would like the ability to execute the Bulk Copy action for Production Lists. (Currently, the action is limited to only non-Production Lists.) Bulk Copy…
Today() Function
I'm wondering why in Anaplan we can only have to input current period in Time. As we're using Anaplan as Supply Chain planification tools and we work really at planning on days level. So it's necessary for us to determine "today"'s date. The solution we use now is to launch an automatic import and update the "Today" item.…
Calling all model builders: Share your feedback and impact our future plans!
The product and UX team at Anaplan is looking for your feedback on your current modeling experience, specifically focused on building an appreciation for the challenges you face as a model builder in Anaplan. This survey is designed to capture this detail, so that we can explore how to simplify and accelerate the modeling…
ALM- How and why anaplan saves data in module after replacing list with new subset of same list?
My module contains 5 dimensions, and I am replacing one of the list subset by another list subset of the same list, I have tested it using ALM, but I would like to understand how anaplan ensures even after changing the list subset anaplan preserves input value in that module. I have updated list subset first in test…
Convert month number to month (month period)
Hi, I am looking for a way to convert a month number (f.e. 1) to month name (f.e. 'Jan 20'). How would you do this? Kind regards, Catheline
Convert CUMULATE functions to PREVIOUS | Model Optimization Team series
Hello! Welcome to the Model Optimization team's monthly blog post. This is an eight-part series, following the topics we see occurring most frequently in slow customer models. Our aim is to inform and guide how to build with best practice intentions for these model building topics. Each month, two of our analysts will take…

Modeling

Discussion List