-
Change of E-mail Domain - User History and information
My Org, will be undergoing a rebranding soon and as a part of it the domain name of the email addresses will change user@oldco.com → user@newco.com We use Anaplan SSO for Login and Authentication, Once the SSO is reconfigured expect change reflect in Anaplan user base. How will Anaplan treat this change? Will the new…
-
Native Versions: Add as a Line Item Format Option & Allow Subsetting
As a model builder, some of the native version functionality is great. However, there are limitations that prevent it from being preferable in several cases. For this community idea, I am requesting the ability to have both of the below functionalities for the native versions in Anaplan: 1 . The ability to set a line item…
-
Have time as line item format (12:00, 12:30 etc)
Would be great to be able to have a line item format of time - not this isn't knowing what the current time is but users being able to put in 12:00, 12:30 etc or imported via datasets As we look towards having operational planning models being able to capture time as a pre-defined dataset rather than creating a list would…
-
Level - Sprint 1 - 1.4.6.1
1.4.6.1 Rename Actions Using the recommended naming conventions for Actions: * Rename the Actions used to load the P3 SKU list and SYS12 SKU Details system module:* Organize the Actions in the correct sequence. * These Actions will be included in the Process: 1 Load Products. * Rename the Action used to Build the P3 SKU…
-
Recording now available! April 30 platform release event
If you missed our April 30, 2025 platform release event, the recording is now available! In this webinar, we highlight the most recent feature releases and how to take advantage of these in your environment. Our expert-led session demonstrated new features and innovations, provided a technical deep-dive and “how-to”,…
-
Configure Default Number Format for Entire Model
It would be nice to be able to set a default number format for an entire model. We use the same number format across all modules and models so we're spending a significant amount of time modifying this setting from the current default. It would be very beneficial to set this format upfront. I saw this idea labeled as "Not…
-
How to calculate number of months between two dates when one date falls outside of model time range
I am needing to calculate the number of months between two dates, one of the dates falls outside of the model time range. I am needing this so I can do a straight line depreciation cacluation but the # of months formula returns a blank value because of the date/time range isue.
-
Data Encoding & Feature Scaling
Was wondering if: * there are Data Encoding features (like one-hot encoding) available to process categorical data into ordinal/numeric values, so that they can be fed into forecasting/ML algorithms available in Anaplan. * there are Feature Scaling (min-max) methods available to bring columns within specified ranges. For…
-
Module to Module Import
I am building a module to module import, loading data from one module to another. However to make sure my import run optimally. I want to filter the data (essentially a boolean line item) to control # of rows. My Modules has 5 dimension, so not possible to nest them all in the rows. I have added filter but when I run the…
-
OEG Best Practice: Time range application
If you have a multi-year model where the date range for different parts of the model varies (for example, history covering two years, current year forecast, and three planning years), then time ranges should be able to deliver significant gains in terms of model size and performance. But, before you rush headlong into…
-
2.3.9.3 Update Historic Volumes for Baseline Forecast
Hello everyone, I encounter a problem concerning the formula of "Offset Volumes for 1st Forecast Year" . I wrote the formula that seems logical to me but it doesn't work. Can someone help me correcting it ? Thanks in advance. N.B : The first image represents hints for the formula and the second image is the formula that i…
-
MAILTO - CC users with selective access
Hi All, I'm trying to add all users with selective access to in CC of an email to be send via "MAILTO". But can't seem to get it working. Did anybody already try something similar? Thanks,
-
Add Versions as a native option for a line item/property format.
Description of the enhancement required: Version as a format An example of the enhancement: When uploading a planning file (budget, Q1 forecast, Q2 forecast) from excel, a number of identifiers for my transactions are uploaded as text and later on in the transactions module turned into line items based on a list so I can…
-
Export Function
Hi Anaplanners, Hope you all are doing good! I have one question regarding export. Lets say we have module dimensioned with 4 dimension . And we cannot add 4 dimension in row. I have added time dimension(Year) in Page selector. While exporting I dont want time to be displayed in export file. Is there and possibility in…
-
Clear a date formatted list property.
Hello everyone. My case is simple : For a specific client need, I have a list with date property. Each time a date is input in the module, a process is run to "save" the input in the lists properties. Some of these properties are date formatted line items. When the client input a date and save it, the import sends the date…
-
New Function To Convert Date Format to Text Format
It would be very useful to have this functionality rather than convert to numbers through DAY, MONTH, YEAR and back to text through TEXT function. Best practice would dictate to split these functions out but this increases clutter and causes unnecessary calculations in models.
-
Melhores Práticas para Configurações de Tempo em Modelos Anaplan de Grande Escala
As configurações de tempo no Anaplan vão muito além de uma etapa inicial de configuração, elas representam uma das principais dimensões em um modelo padrão. Com exceção dos modelos do tipo Data Hub, a maioria dos módulos utiliza a dimensão de tempo, e qualquer alteração nas configurações de tempo impacta diretamente o…
-
How I built it : Centralizing complex calculations
Author: Fabien Junod is a Certified Master Anaplanner and Senior Solution Architect at Autodesk. Hello Anaplan Community, Let me ask you a question: do you have the same complex calculation in multiple models (maybe with different dimensions) and wish you could centralize them? In this “How I built it” tutorial, I shared…
-
How to Auto Populate a Form for Users?
I’m working on a page that includes two tables: Module 1 (called CRM Table): Dimensioned by L4 Employees, includes line items like Term Date, Role, and Department. Module 2 (New Hire Table): Dimensioned by L4 New Hires, with similar fields. Both L4 Employees and L4 New Hires roll up to L3 Department in the same hierarchy.…
-
Pulling list property into a module
Appreciate that it is recommended to avoid using properties in lists, however we do have a couple of instances of this in our model. Just looking to pull one of these into a module that we have already created, shown below and was looking for advice as to what formula is best to try and achieve this.
-
Level 2 Sprint 3 INV01
I am at the point where I am comparing my INV01 data to the Anaplan lesson example and my numbers aren't matching. I have a couple of questions about INV01. For Beginning Inventory: My numbers are good until week 4. Then I realized that when triggered the PO Submitted boolean, it showed up in the confirmed PO line for the…
-
Time to Tidy: No More Mess in Your Models
As winter is now behind us and the annual process of “spring cleaning” begins, I find that it is a good reminder to not only clean and organize my house, but also to clean another area that most likely needs some organization: my Anaplan models. The beauty of Anaplan’s platform is that it gives the model builder an…
-
Modeling Performance
Hi Team, I would like to get the next year summary value into previous year’s month. If we need current year summary, then we can use YEARVALUE function to achieve but we need to bring data from next year so we can use either LOOKUP or TIMESUM . I would like to know which function is effective between LOOKUP and TIMESUM.
-
Need help related to custom Time Dimension
Hello Everyone, Want to create module which captures data days wise, but the challenge is the data should be Displayed in two ways. So, If current forecast day is 6th Aug, so 1st Column named "Till Date" will be showing Summation of 1st Aug to 5th Aug and remaining days will be displayed in further columns which will sum…
-
Level 1 Model Building Exam Activity 5 - Stuck!
I have been stuck on this activity for the past 2 days and do not know what I am doing wrong: This is the formula I tried for Bonus: For bonus: IF Employed? THEN Salary * 'EMP03 Employee Drivers by Role’.Bonus % [LOOKUP: 'EMP03 Employee Drivers by Role’.Department, LOOKUP: 'EMP03 Employee Drivers by Role’.Role] ELSE 0 And…
-
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…
-
Waterfall chart intermediate totals
Hello, Does anyone know why the waterfall intermediate total is showing up in blue? I'm using a ragged hierarchy. With intermediate totals turned on & colour set to black I want to see the forecast bar also as black. Is there anyway we can achieve the same? Thanks in advance!
-
How I Built It: Fast, efficient model build of scenario planning with P&L impact analysis
Author: Marina Ketelslegers is a Certified Master Anaplanner and FP&A expert and independent Anaplan Solution Architect. In this 'How I Built It' tutorial, you'll learn how to create a dynamic and flexible impact analysis and allocation framework tailored to your needs. Whether you're evaluating P&L scenarios with business…
-
Straight Line Depreciation spread issue
Dear Model Builders, As per attached screenshot of my Straight Line Depreciation code, I am not able to get depreciation to calculate and spread for all subsequent months from Date in Use to Useful Life of the asset. All I am getting is a depreciation for a month of Date in Use but not for subsequent months. I have even…