Modeling

Custom Calendars
Is there a way to create custom calendars in Anaplan? Our customers work out of different calendars and we would like to be able to enter and report data according to each specific customer's calendar, while at the same time being able to enter and report data according to our corporate calendar. Any advice or links to…
LOOKUP on Time | Model Optimization Team series
Hello Anaplan Community! Welcome to the Model Optimization team's monthly blog post. This is our last post in an eight-part series, on 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,…
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…
ITEM function cannot be used on composite lists with Summary of "Formula"
To reproduce: 1. Create a parent list and a composite child list. 2. Create a module with 1 line item with formula "ITEM(Child List)" and list formatted to "Child List". Applies To should be "Child List". 3. Change Summary to "Formula", the following error is shown: The formula for 'mod1'.'item1' is invalid: 'item1' =…
To have search option in the beta version of Module
Hello Everyone, I see that in the beta version of new module inventory, there are two issues: The Search icon is missing, which was there in the earlier version. When we use the find option (Ctrl +F), it only searches the module names present in the current screen and not from the entire list of modules. Attached the pic…
Ability to sort models in model management
A description of the enhancement requested Sort models by size and name in "model management A story for why they want the enhancement (specifically how would it help their business process) To easier sort models
🎁 Line Item Viewer ツールを公開しています 🎄
こんにちは、Amayaです。 2024年もほとんど終わりかけ、1年の振り返りをしています。思えば今年はこちらのBlogも掲載してもらったのでした。 Experimenting with automated documenting — Anaplan Community AnaplanのAPIから出てくるラインアイテムのデータを可視化してみよう、という実験についてのポストになります。このとき実際に作成したツールについては今も公開しています。（春のユーザー会でお見せしていたのがこちらになります）…
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…
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.…
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'…
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.

Modeling

Discussion List