-
Mapping from a module that is time dimensioned to a module that is not time dimensioned
I am trying to build a tool to manage my sprint. I have a module that is not time dimensioned I wanted to get the start and end date from a system module. The date comes correctly if I get it from a module that is time dimensioned as below But if I used a time dimensioned it does not come. The reason I wanted a time…
-
Identifying Line Items Used as Filters or in Actions
I have always difficulty identifying line items that are NOT referenced by any other line items/modules but used in actions or dashboard filters. During model cleanup, we often encounter line items that appear unreferenced but may still be actively used as filters in dashboards or within actions. These usages are not…
-
Set up Anaplan Workflow Approval process at higher level
I need to create an Anaplan workflow where a task is completed at the subregion level, but the approval happens at the higher region level. The current Anaplan workflow functionality seems to require that the approval task is on the same page and at the same hierarchical level as the completed task. My specific question…
-
Poll: Should I have a single model or two separate models?
Hi Anaplanners, I am hoping to collect some feedbacks from you on an ongoing discussion I've been having with my stakeholders. My organization currently have 1 TQP model, which is focused on keep the model small and agile, and quick enough for about 200 managers to use to plan out their territories within a 5 weeks…
-
Error "No current transaction manager" during data import
Hi Community, I ran into an error while manually importing a CSV file into a module in Anaplan. The error message displayed is: "No current transaction manager" Has anyone experienced this issue before? Thanks in advance for your help!
-
Need Help: Import Updates Only Specific Combinations Without Erasing Others
Hi Anaplan Community, I'm facing an issue while importing data FROM A MODULE (text details) INTO A MODULE that has two dimensions: "Unique Line ID" and "Organization x Site". The source file is based on a numbered list. It includes text-formatted columns (line items) that contain the names of the "Unique Line ID" and…
-
GL Mapping Update Without Impacting Historical Periods
Hi Everyone, I have a module that is dimensioned by GL Account and a P&L Line Item subset, which is mapped to the GL Account. I’m looking for a way to ensure that when changes are made to the mapping, they only affect the current and future period numbers—without impacting historical data. Ideally, this should be done…
-
Prevent end users deleting a list item when using Worksheet in UX.
Hi, I have a worksheet for end users to enter new hires into, for which the list item which persist across versions. I am having an issue where the end user can delete a list item using the grid functionality because the Current Version value is blank, but I want to prevent them deleting them (as data will be lost from…
-
Excel date format for February 2030, 2031 and so forth don't align with Anaplan format
Hello, I’m running into a recurring issue when importing CSV files into Anaplan, specifically with dates in February for the years 2028, 2029, and beyond. Here’s what’s happening: In Excel, the date format is set to Custom (e.g., 2/26/2025). When imported into Anaplan, the date is interpreted as 26-Feb, where: Month = Feb…
-
RANKCUMULATE not working when adding additional dimensions to module
I have an issue where I am getting the expected result from RANKCUMULATE when using one dimension, but when I add an additional scenario dimension to the module, it doesn't calculate the way I'd expect. Here are some screenshots to explain the case: Module 1 - calculates cumulative total for list items in list "Age"…
-
Show or hide item from LIS is possible?
Hi, Is it possible to show only override items from line-item subset on NUX context selector? In backend we are using all the P&L items for the calculation but need to show only override items on NUX. Is it possible? Any help much appreciated!
-
Please can explain this i am not able to mapping correct way
Please can explain this i am not able to mapping correct way.
-
Error on Level 2 Sprint 1 1.3.4.2 Update SYS06 Country Details Module
not sure what I'm doing wrong here. Region List is a flat list as well. Any help would be appreciated. I also tried using country name instead of code and got the same error
-
Rolling Forecast
Hi, can someone help me with modelling a 3month rolling forecast as per the attached picture? I can use a moving sum of the first 3 months for april but then for may, the formula needs to take the output of the movingsum of april and the actuals of feb and march and it is giving me a circular reference. Any ideas to solve…
-
Can Please explain the difference between a general list,a module,and action in Anaplan.
Can please explain why we create a general list ,a module,and Action ,and what purpose each one serves.🙂
-
Using Left for Different Number of Characters
I have account strings that are separated by a different number of characters for each string. I need to pull everything left of a colon ":" to get the first piece of the account strings. Some of the accounts are 3 characters and some are 4. Ex. AAA:BBB:CCC; AAAA:BBB:CCC. I need to pull all the A's for everything left of…
-
Sorting General List
Hi, I wonder if there's a way I can sort my general list alphabetically. The list is used as a drop down menu in a line item module and I want the drop down menu to be easy to navigate. I've already tried the Order List action. I already have a module with a text-formatted line item based on that list. But when I try to…
-
New UX Input cell colour
Hi community, I want to give a colour background for my input cells in new UX. Just wondering if there is a straight forward option. Any advises will be appreciated. Thanks Kal
-
How to create Anaplan formula MTD with Input Date
Hi, I'm trying to create a month to date line that is based on a specific input date, not the actual date. Is this possible?
-
How to create identical child items for multiple parents
The data I'm trying to import is as follows Parent-Code A B A C B D C D D E I want to generate the following list from this data: L1 L2 L3 L4 A A-B A-B-D A-B-D-E A A-C A-C-D A-C-D-E You can create up to L3.However, L4 has multiple parents for one row of data When I try to create L4 from D-E, only one list row is generated…