Modeling

Issue with double counting bed types
We added new bed types to eventually move from the old "All Beds, single, double" I inputted the data into the new bed types Went to double check flow into other modules and found that they are being double counted even though I blanked the original columns out. I am not sure why it is still counting All Beds even if it is…
How to build a Polaris reporting model in less than two weeks
Author: Hanwen Chen is a Certified Master Anaplanner and Professional Services Sr. Manager at Anaplan. Over the past nine months, I have been involved in multiple Classic-to-Polaris conversion projects. One consistent requirement across these engagements is the need for scalable reporting solutions that support multiple…
Default today's date on UX with ADO
Hi everyone, I am trying to make a UX Page with today's date as default. That means, everyday when I enter in my UX page, I will see today's date (so the date will change everyday) and the figures related to the date, will change accordingly. Any ideas or tips&tricks? I need to men tion that I need to use ADO and not…
Level 2 Sprint 2 2.3.10
Hi, as a result for the first question (2.3.10) I have the answer 71.34 but it should be 73.48. I don't seem to understand where I made a mistake. Could anyone help me out please? - DEM01 screenshot 1 (DEM01) - DEM02 screenshot 2 (DEM02) - DAT03 screenshot 3 (DAT03) - Formula: IF 'SYS01 Time Settings By Week'.'1st Forecast…
Anaplan Export (Tabular Multiple Column): Saved View Line Items
When exporting from Anaplan using "Tabular Multiple Column", will the export include only the line items saved in the saved view, or will it also export line items that are excluded from the saved view?
Modulation in Anaplan
Author: Arun Thakar, Vice President in the banking industry. In cases where you have a single DEV model and multiple TEST and PROD models, the situation may arise where one user group asks for a feature that is not required for other users in different models. All too often the answer is to build modules, lists, and logic…
Mapping LOOKUP
I have a Combined String list and a Combined String Properties module. I also have a Mapped Flat List and a Mapping module. I want to bring the mapping from the Mapping module to the Combined String Properties. How do I do that? I know I should use a lookup, but I need help with the setup?
Add Syntax Highlighting
As a Model Builder, I would like to have "syntax highlighting" when I create my formulas in order to improve readability.
How to use a different 'Current period' for different versions
I'm working on a model with three versions: Actual (Actual version), Scenario: Prognose lopend jaar (current version), and Scenario: Budget volgend jaar. For one of the calculations, the Scenario: Prognose lopend jaar version needs to use a different current period than the Scenario: Budget volgend jaar. For this, I…
Using territory maps with Anaplan
Author: Paola Malafaia is a Certified Master Anaplanner and Associate Consultant at Cornerstone Performance Management. After setting up Territory Maps, I had a few learnings and I thought it would be helpful for other developers to put some notes about the basic settings of this mapping feature for dummies. The goal here…
Building a Cash Flow Model
Hi, I have started Building a Cash Flow Model for my Excel Spread Sheet and I need advice on how to decide the structure of my Model. So far I have made Module's made after the Yellow Tabs in my Excel Model and made the Line Items of my Modules the First Columns in my Excel Sheets (The things that I need to calculate and…
Time summary setting for a line item with "Formula" summary setting.
Hi All, I am currently working on a requirement to cumulate the value of a line item. For this line item I have opted for the Summary method - "Formula" but I dont want the overall total sum for this column; I tried to change the "Time summary" for this line item , but it is throwing me error - Invalid combination of…
How to create a dynamic time list using a numbered list
Author: Tyler Beck is a Certified Master Anaplanner at TBLB LLC, and is currently a Team Lead at CVS Health. Use case A client requests a flat list for time that will change year over year and does not want to manually update the list, and does not want to use native time. Instead of creating a production list to update…
Data Hub: Will multiple imports and loads at the same time slow it down or lock it?
If two spoke models pull data from the same Data Hub at the same time, will it slow down the Data Hub or cause any locking? Also, if the Data Hub is being loaded/updated with a different set of data while it’s sending data to two spoke models, will that slow down the Data Hub or cause any locking/issues?
Running IRR (IRR Calculation by Period)
In as much detail as possible, describe the problem or experience related to your idea. Please provide the context of what you were trying to do and include specific examples or workarounds: The IRR function in Anaplan is calculating the final IRR based on the entire cashflow over the timescale. We need it to calculate it…
User Access Management: Part 3 - Practice makes perfect!
If you missed the first two articles in this series, read Part 1 here and Part 2 here. This is a detailed walk-through (and a downloadable link to a practice model!) that you can follow to get started on your UAM journey. Note that the examples here leverage the Bulk API for adding new users to models. If you have enabled…
Create export template for Anaplan users to import using months
Author: Tyler Beck is a Certified Master Anaplanner at TBLB LLC, and is currently a Team Lead at CVS Health. Use case An end user needs to export a template from Anaplan using Months as the time period in columns, and qualitative data in rows. When the template is exported as a CSV file the years in the dates turn to days…
Show Line Item Format in New Model Building Experience
The new model building experience is far better than the classic and needing to click into every module if syntax is unknown. A big incremental enhancement would be to add some sort of icon or naming to show you the Line Item type. Adding this naming would allow the builder to better understand what they are referencing…
400 error when using From Action
hi, I'm receiving this error when trying to create item in numbered list item. My list has a display name property (used only to display name, never in modules) In form Action I ask user to give display name and other informations about the item (informations are line items in associated modules). It seems that when I ask…
CERTIFICATION BADGES - ANNOUNCEMENT
Anaplan Champions! The Community team just posted this announcement that certification badges may not be showing up on your profile probably until next year. Rest assured, you will get credit once you complete and pass the exams. https://community.anaplan.com/t5/Blog/Badges-Back-Soon/ba-p/123385
New UX Idea - Apply one more model source to all pages of the app at once
One of our model a dev and multiple prod models linked to a single dev via ALM. We have developed New UX App based on dev with a lot of pages in it. My aim now is to apply all prod models we have to this app, but the existing procedure is not effective for this idea. I want to have ability to add new source to the excising…
Discover how Anaplan turns complex workforce simulations into real-time insight
Author: Judee Dimapilis is a Certified Master Anaplanner and co-founder at Malaya Tech Consulting. Preparing for a major business launch is always complex, especially in the gaming and leisure industry where coordinating different departments, opening phases, and staffing requirements add another layer of operational…
model building activity 6 add formulas to REP04 module line items
hello. is there anybody, who can help with the LEVEL 1 Model Building Exam? I do not know what formulas to write in the model building activity 6
Single Thread and Cumulate
Hi, I'm reviewing a model MAPS report. the model includes 5 instances of 'Single Thread' cases all involving the Cumulate function. I can't figure how to resolve these. Does anyone have any pointers or ideas?
Enable cards from multiple models within the new UX app
Enable cards from multiple models within the new UX app. Currently you can add multiple models to a page, but when you add cards sourced from different models you have to toggle to that model at the selector. After creating the cards, you have to toggle to this modal at the top otherwise the data is killed as per the…
Open source module link in NUX
Suggest to add the "Open Source module" ability to the NUX, incl. the current analysis options available in the old UX. Right now our users can use the open source module function in the old UX whenever they want to dig into the details, see all the underlying formulas/comments, and do ad hoc analysis. Especially, the…
getting the error: "Dimension of mapping used for lookup doesn't match any dimension of the result"
I am doing level 1 model building(Activity-9.2.5 Activity: Add Formulas to Price Growth Rates Staging Module) When i try to enter the formula for the lineitem 'Unit Price %' i get the following error- "Dimension of mapping used for lookup doesn't match any dimension of the result" . My Formula- 'REV04 Price Growth…
Filtering line items or lists by another list
I have a module of multiple different input line items, but those inputs vary by the elements in a list. For example the North region (list item) has 2 of the 5 inputs, and the south region may have all of the inputs. I want to be able to use a filter to only show those applicable input line items for its respective list…
Drill to Transaction Functionality in the New UX
Drill to Transaction Functionality is considered critical for some partners/clients as it's functionality that has no alternate solution. I have heard specifically from FP&A implementations regarding allocations, as well as ICM use cases, but would love anyone giving kudos to leave comments with additional examples of it's…
Allow the end-user to set their own language preference for a model within their settings.
Description of the enhancement required: Allow for Workspace Admins to configure the Platform in English but support alias tables that allow end-users to switch between different languages (i.e. English to French, etc.) An example of the enhancement: Allow the end-user to set their own language preference within their…

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