Data Integration

import logic
Hi Anaplan Community, Below is the item I need help with this is regarding the clients extractor process. JFC will be sending 2 csv files for their extractor process. Below is the table with Months spread according to project name (this includes not in Budget – which is normally empty according to the user). Now the column…
Excel Add-in: Restore Connection after module rename
Hi all, Is there a way of restoring a connection to a module via Excel Add-in after the module has been renamed? the re-map functionality does not work either (model ID is the same) . My connection stopped synchronizing and the only change is the module name and I found below restriction on Best Practices for Excel Add-in.…
10.2.2 Errors
Hello, Can someone tell me why I am getting errors? What happened to my total? Thanks,
Add a item number when importing to modules
Hi, I want to import "order" file to modules. I have several modules which has Item number List as Applies To. module A & B. I want to import this type of csv file. This order files don't have order no. So I have to add Item numbers to first row. When I edit the csv files, some Lineitem( other) has 0 on the dead will…
Now available - new release BIG VALUE in terms of identity management and security! SCIM is here.
Anaplan System for Cross-Domain Identity Management Further progress and updates on User Management and security/MFA. See here for the latest on SCIM These are REST-based APIs that can be used to integrate Anaplan and a SCIM-compliant identity source, such as Okta. Designed to simplify user management, SCIM APIs allow…
Export API call returns only module headers
Hello all, I am trying to export out data from a module via an API call using an existing export action. Have successfully initiated the export action and retrieved the file details (chunk numbers etc), however when I attempt to download the first (and only) chunk details the API call only returns the module headers…
Workspace message error while importing a file
Hi, I have a little issue, In my development model i have created a process in order to import members of a hierarchy list regarding code, name and parent, in one step of the hierarchy for exemple let say that we have 4000 lines, in the lower level we have 40 000 each with parent, code and name, when i run this process…
import duplicate list item
how can i import duplicate data from excel to list : remember there is no parent or code with in excel i only want to import main channel please check screenshot THANKS in advance
API Anaplan Connect Export Action give no data
I can set a batch file that works and exports data, a small bit, but if I switch the action to a different one, it returns only headers. This is the exact file minus username:password and action name and path are removed. To be clear, the action run by hand exports a csv and the data is all there. If I run it via…
Improving the quality of management reports when exported to Excel
The quality of the font on management accounts deteriorates when exported to Excel. It's OK when zoomed in, however just looking at on an A4 page it gets fuzzy. It may be that the resolution is too high?
7.2.3 name and country error
Can someone help with these errors. I have tried several times to fix. I must overlooking something.
Associating a list to a hierarchy
Hi, I created a Cost Centers list with values (1, 2, 3, 4, etc.) and a hierarchy of Business Unit lists (Business Unit 1, Business Unit 2, Business Unit 3). I'm looking for a way to associate each group of cost centers from the Cost Centers list to the Business Unit hierarchy. The hierarchy Business Units 1-3 values…
Export file into email
Hi, I have built a supplier forecast module and created an export into excel with added data from the list used in the module. I would like if I could make this export be divided so each supplier receive an email with their items and forecast Is this possible in any way? Since we have a lot of suppliers we dont want create…
L1 Volume Inputs Module
Hi Everybody , I got stuck while importing/mapping the data into Level 1 - Lesson 8 - REV02 Volume Inputs , I have attached the snap shots of each tab , Please advise the solution . Thank You
Error when importing from 2 other models, one works, the other doesn't
Hi I am importing data to a module from 2 other models. One works perfectly whereas the other import comes back with an error message 'The column headers in the file you are attempting to import do not match the import definition'. The source modules have the same structure apart from there is a numbered list in the source…
L2 1.3.3.2 import error
Hi, Need help on importing country flat list on l2 sprint one .as a flat list we need not to assign any [parent but withot assigning i am unable to import. what will be the correct mapping
Anaplan Connect
Can somebody help me this error. Unable to figure out where is the mistake. Thanks Amrutha
Import Transaction Data to Data Hub Module with Numbered List
Hi, I have created a numbered list module with no item yet (Refer to image 1) When I import the transaction file into the module (image 2), what can I do to auto create item in numbered list (#1, #2, #3, #4)? Thanks
copy between versions - current year to next year
Is there an easier or faster way to copy data from FY21 Forecast version to FY22 plan version without copying it module by module? Also, I need to keep the current FY21 plan intact. so the result on plan version should be FY21 plan + copy of FY22 Forecast. This is a model level change. Lag function doesn't work on version…
CloudWorks—This is how we use it, Part 4: Using CloudWorks APIs with AWS Lambda
In Part 3, we described the procedure for using CloudWorks APIs. But the main question would be, how can we use them? Indeed, we can find that having a dedicated screen in Anaplan itself is already a major step forward. And it surely addresses most of the future needs. Nevertheless, in our strive to open our platform as…
SYS06 Data Import
I'm trying to import data into the SYVS06 module and for some reason there is error with the size list item import. Please help.
L2 Sprint 2 - 2.3.10 - Create DEM03 Demand Forecast Module
I have inserted a formula successfully but i am not getting any values for other line items. Can anyone please help in this regard.
NUX Customize Load File message
Hi All, in NUX when Users need to load the file, they can see following message: It always says 'select the CSV file'. This is really confusing, because in this case Users are obliged to load Unicode Text file. Although, they always see CSV here. We are not able to edit or customize this message. Using classic dashboard,…
Interface from Vena to Anaplan
Hi I wanted to ask whether Anaplan can import data directly from Vena models or does a bespoke interface need to be developed to move data between Vena and Anaplan. Thanks Kevin
view to view import failing
Hello friends, need your help in nailing down the problem which i am unable to point. * Module test has 2 views..1a and 2b * Module has following dimensions i.e. Model TIME, 2 lists & 2 line items * What I am doing is inputting the view 1a data into 2b view, receiving the below error. Not sure which data is getting…
L2 S2 2.3.11.2 Create DEM03 Saved View for Global Demand Assumptions UX
Hi All, For 2.3.11.2 Create DEM03 Saved View for Global Demand Assumptions UX Module: DEM03 Demand Forecast Saved View Name: Global Assumptions Grid UX * Add a filter to this module to display Months only. * Use Months as the columns and line items as rows. * Display only Baseline Forecast and Initial Demand Forecast line…
How to undo the mapping
Is there an efficient way or do you have a suggested way to undo the mapping? The only way I am doing it is deleting them, but it is becoming more work when there is a long list. Thank you
Setting to ignore elements when imported into a time dimension.
Hello everyone! I constantly face the problem that I described in this topic. The problem is that if, when loading data, you have time in the columns, and the rows have several non-embedded columns (reference for the user, outgoing measurement (and the mapping is done according to an additional LI: code), then at the start…
Anaplan Connect Import Error - Unmatched Delimiter Character Due to Double Quote and Underscore
Dear Community, I observed two causes for the error 1) double quote 2) underscore. My questions are: 1. It seems I do need to use delimiter for my load. Is there a way to clean the data before the load without putting restriction at the user data entry point? 2. why would underscore cause this error Below is a post from…
How to integrate Azure data factory and Anaplan
How can we use Azure data factory REST API Connector to ingest data from Anaplan to Azure blob Storage? Is there any direct solution or links to this?

Data Integration

Discussion List