-
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 (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 "Organization x…
-
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…
-
Mapping
Hi all, I’m having trouble grasping how “mapping” works in Anaplan when importing data and aligning dimensions. I keep getting confused about when to map to lists vs. line items vs. time, and how to handle mismatched names and hierarchies. Could someone explain, in simple terms.
-
ABC Demo Optimizer Lesson in Academy
I followed the directions in the lesson Anaplan Optimizer where the quantity and the total cost should be results from running the optimizer as set up in the course. When I fun the process "Find Solution" I get a Process failed error Additionally, there are no values in my quantity module not in the shipping cost module. I…
-
How to map 3 columns(line items) of data to one line item based off time
I have a data set with multiple columns of data (2023 inforce premium, 2024 inforce premium, and 2025 inforce premium) that I want to map to a module and sum based off the corresponding year in the title. What would be the best way to map these line items in the data while avoiding a lengthy if statement that would need to…
-
circular reference: Volumes
I am trying to write this formula DATA02 SKU Volumes.Volumes in REV02 Volumes Inputs to pull Data from DATA02 SKU Volumes Model. When I do I get an error message Circular reference: Volumes. I checked and there are no other formulas in either Model. I even tried turning SUM to None in Summary field. Could someone tell me…