Modeling

Include Calculation Effort metric in Anaplan Classic
I have found this feature available in Polaris to be very valuable. So I would like to request it to be included in Anaplan Classic as well. Thought there was already an existing idea request for this but couldn't find it. When I encountered performance issues during a list item insert that was taking 90 seconds to execute…
Quick way to open referenced Line Item or List Property
It would be great to have a quick way to open a referenced Line Item or List Property from an existing formula. It can be very tedious & time consuming to hunt through the modules & lists, then again through the line items & properties to locate the reference, especially when there are multiple levels of references to…
Getting 0 results from a COLLECT line item
Hello, I have a line item that has a COLLECT() formula. This returns the values just fine. But when I use this line item and Lookup or Select a specific member, it doesn't return any value. Is there a way to do this, or am I doing it incorrectly? LINE ITEM FORMULA APPLIES TO SUMMARY TIME Source line item COLLECT() List 1 &…
Invalid Formula error?
Hi - I am copying the same formula from another cell, and adjusting the start of the formula to another cell so should be straight forward, but I keep getting 'invalid formula'. Please see screenshot below. Can someone please advise? Thanks
How do I get the correct mapping?
Hello, I'm facing a mapping issue, wherein I've a module with 3 dimensions & few line items- Lets say Dimension X, Y & UID with a line item formatted as dimension ZZ Then there's a 2nd module with the dimension ZZ , Y & the same line items- There's a mapping between ZZ & X so I can lookup that & pull the values, dimension…
Anaplan Id Merge
Hi Team, I have a team member who has currently changed the organisation. She is Anaplan certified resource. She was having id with the previous company credentials want to merge it with current company credentials. Can you please help us with the process.
Get self-service and lower cost of ownership using CloudWorks
Now that Anaplan has rolled out CloudWorks, more clients are asking about how to leverage it as the main data integration tool for their Anaplan platform. After years of implementing Anaplan at a partner firm using mainly Anaplan Connect for integrations, I have been pleasantly surprised at how CloudWorks performs and how…
Converting Text to Date and Date to Text
Author: Julie Ziemer is a Certified Master Anaplanner, Anaplan Community Boss, and Solution Leader/Business Analyst at Akili. While Anaplan has specific functions to convert between data types, converting Text to Date and Date to Text are two commonly searched topics on Community and they require the use of several…
How to avoid showing disabled parent from Drop Down list Selection
User is not willing to see parents in drop down list selection. By creating a flat list of my level 4 and by creating mapping between L4 and flat list we can fulfill the ask but I am looking at multiple options on how to achieve this. Feel free to share the approaches if any.
How does the Model Open Analysis Report change without any changes to model?
We've come into performance issues on our model and requested a Model Open Analysis (MOA) report from Anaplan support. This was very helpful in identifying modules and, in particular, line items that were using up a lot of processing power. The metric they used was Total Calculation Time, measured in milliseconds. After we…
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…
Manual Entry
Hi all, Is there any possibility for manually entering and using formula in same line item... Knowing its not possible still is there any possibility for the same .... Regards, JEEVAK
Five principles of solution architecture
Author: Arun Thakar is a Certified Master Anaplanner and Vice President in the banking industry. Whether you are just starting out as a solution architect, or you’ve worked on several models you may benefit from a refresher on some of solution architecture’s key principles. It’s important to remember that these are not…
Level 2 Model Building Conclusion - DEM04 Demand Export Demand values
Hi, Could someone please help me with the following? Solution DEM04 should be this: My DEM04 Demand Export: My values are way higher, Demand line item is not for each product SKU. How can I fix this? My DEM04 blueprintview: Baseline Forecast: Thanks in advance!
Show all data if no user filter selected
Hello, I have a user filter selection. It only shows data after filtering. How to see all the data even without filter? Thanks.
Count the total number based on filter KPI
Hi, I have a Count line item of employees that has a formula of 1 in my employees module. I have a Total Count line item on another module to show the Total Count based on Filter that has a formula of: my Filter formula is: How do I show the total count of employee based on the filter? Thanks
Did You Know: Multi-dimensionality overview
Author: Allison Slaught is a Certified Master Anaplanner, Anaplan Community Boss, and Senior Principal Solution Architect at Anaplan. Hello Anaplan Community! The objective of this ‘Did You Know’ tutorial is to provide a brief recap of multi-dimensionality in Anaplan and provide a framework for identifying how formulas…
Anaplan Partners for FP&A
Hey there, Has anyone implemented Financial Planning & Analysis in Anaplan for an organization without an Anaplan partner or a light one? If so, how was your experience? Thanks! Andrew
How I Built It: Dynamic source data selection
Author: Erik Svensson is a Certified Master Anaplanner and a Principal Solution Architect at Anaplan. Hello Anaplan Community! Thank you for checking out my ‘How I Built It’ tutorial. In this video, I showcase how you can set up end user selections to vary data sources across one or more hierarchies. This is a dynamic way…
NEW UX: Link to pages in other apps within the same workspace
In Classic Anaplan, we have one big model within a workspace. We're considering building it again in the new UX and expect to break the big model into more functional apps. The trouble is some of these apps are not entirely siloed, i.e. users will need to move between pages within multiple apps. It would be really helpful…
Top 25 Anaplan features released in 2024
Author: Misbah Ansari is a Certified Master Anaplanner, Anaplan Community Boss, and CEO/Founder at Miz Logix. Anaplan has released hundreds of features in 2024 to enrich its platform with more flexible planning, dynamic reporting, and scalable offerings. These features have been released throughout the year across all the…
Exam 3 - A 2019 Actuals
Hi, I successfully loaded the provided 2019 Actuals file and updated the Sales Planning model and I am still getting incorrect answers for the first 2 exam questions which are based on this file. I hit every check point in the Level 3 lesson sprints and successfully loaded the file, so I'm not sure why my numbers are off…
Month Number respective month.
I want a line item where I can select the month by drop-down. For this respective month I need the number value of the month. How can I achieve this.? Like October is 10. I am thinking to create a month flat list and use it, but how can I get the number? And i would very appreciate you if you share screenshot.
Activity 4.6.4
When importing the excel file I keep getting an error message saying “import complete but with failures” and the failure is an invalid code. It says US is not the correct code. Anyone know how to help?
Sankey (Flow + Magnitude) Charts
Hi Anaplan, We've had a few requests now for Sankey charts to show flow direction of data as well as the magnitude of this flow. Especially pertinent in allocation processes where you it would be great to be able to visualise the movement of data from one location to another i.e. Allocation of L3.C to G5.A & G5.B; or Sales…
Interpolation
How can we do interpolation in Anaplan? I need to interpolate scores from the following criterias: a. Min number with equivalent score b. Max number with equivalent score Thank you!
Level 2 Sprint 1 - 1.5.7.2 Add Formula to SYS13 Line Item
Hi, Can I please get some help with the formula for this? Thanks
Data Import from Model A to Model B
Anaplanners, Had a query, i have data in Model A, in Revenue Module which is dimensioned by Country List, Time & KPIs as line item. I need to import this data into Model B, in same Revenue Planning Module, which is again dimensioned by Country, List, Time & KPIs as line item. However here we have an additional plan type…
Removing unnecessary Top Levels
Removing unnecessary Top Levels (or better yet, not adding them in the first place!) Author: Allison Slaught, Certified Master Anaplanner and Principle Solution Architect at Anaplan. To improve efficiency in your models, it’s important we only calculate where necessary. One way we can do that is to only use Top Levels…
Adjusting Statistical Forecasts: Utilizing different Methods for varying time horizons
Hello Anaplan Community, currently we have a very simple statistical forecast tool in Anaplan. We can select between 15 forecast methods for a forecast category. We generate the statistical forecast using a single method for the next 5 years. We aim to introduce a logic that enables selecting two distinct forecasting…

Upcoming Events

Community Challenge Recap: Annual rollover best practices
In this ACE Spotlight event, we will cover the most effective techniques for making your annual rollovers seamless and repeatable, based on the solutions from our latest Community Q&A Challenge.
ACE: Anaplan Workflow expanded
Join us for an upcoming Anaplan Community Experiences session focused on continuing your learning with Anaplan Workflow. In this event, we will explore best practices for designing and implementing workflow processes that support structured planning, approvals, and collaboration across teams. The session will provide…
Quarterly Platform Release Webinar
Registration will open soon for this event. Join us for our Quarterly Platform Release webinar where we highlight the latest enhancements and updates to the Anaplan platform. In this session, members of the Anaplan team will walk through key capabilities released this quarter, explain how they support better planning and…
ACE: Anaplan Workflow
Registration and events details will release closer to the event date. Join us for the third session in our Workflow Expanded series as part of the Anaplan Community Experience program. This session continues our exploration of Workflow best practices and builds on the lessons from the earlier events in the series. We will…
ACE: Anaplan Workflow
Registration and events details will release closer to the event date. Join us for the fourth session in our Workflow Expanded series as part of the Anaplan Community Experience program. In this session, we continue building on the concepts and best practices discussed throughout the series, with a focus on helping model…

Modeling

Discussion List