Data Integration

Copying Actions
I have an action to import today's date into a field 'Today' in a time assumptions module, every night using connect script. Great, works perfectly, all is good. I have a separate action/process that runs ad-hoc, but when it does, I would like to import today's date into another field in the time assumptions module 'Update…
L2 Supply Chain Model - Errors while loading data from Data Hub Model
Dear Community, I'm facing show stopper while running the historic volumes import into Supply Chain Model from the Data Hub Model. I ensured the source model is mapped correctly in Supply Chain Model. Further also checked at the individual import step to see if the object is referred correctly. Still, I'm getting below…
Update Anaplan connector for Informatica Error Message
When using the Anaplan connector for Informatica Cloud and an export fails when writing the output to a table that it can't accommodate a generic error message of [ERROR] Exception in thread “Thread-9” is displayed. It would be beneficial if a more meaningful message is displayed. Current Error Message: Proposed Error…
Level 1 - Expense by Role
I need to set Employee drivers by Role, so i created a list and imported roles data into it. 1) what should be my parent hierarchy in this case - All roles? or All departments? since i had initially created Employee hierarchy with E1 departments - (All Departments being at the top level) then #E2 Employees with E1…
Anaplan Data Integration options for Oracle as source
Hi - One of the challenges i often face while talking to clients is around the data integration options with Anaplan. What are some of the popular options to import actual data into anaplan from source systems. I am interested know about over and above the anaplan connect or flat file upload options. Is hyperconnect being…
Correct mapping guide
Hi, I have created a new list called 'SKU' which needs to be added at the bottom of product hierarchy for SKU's. I have denoted the hierarchy and tried importing the data. Can someone please correct what's going wrong. Thanks STEP 1 STEP 2 STEP 3 ERROR HIERARCHY Thanks
Updating a file through Dell Boomi but unable to change Default file type.
I am an admin and I am uploading a file from Dell Boomi using my credentials and while editing, I can see the records in the file being created but another admin can not see the updated records and Hence, Can not use the import actions using that particular file. Also, there is no option to change the settings of the…
Module to Module Import
Hello Everyone, I have a module named A. I have an action where the source object is a view of the module A and target object is the module A. I have done the following mapping in the action. All the Dimension have been correctly mapped for the import but when i come to the line items Mapping * I am mapping the "Sales Ops…
Import: Mapping Issue with Tab Separators
Hi all, When I tried to upload .csv file with Tab separator, I cannot see any mapping with setting (Please refer to the file called "Separtors=Tab.PNG") and import went to be failed. With Column separator, however, I could see what items were mapped (Refer to the the file "Separators=Column.png). The difference between…
Export batch script | Capture Current Date & time append with file name
@Misbah Hi Flok, How to modified export script to get the customize file name along with current date & time Regards, Rahul
How to create a Saved View using Actions
Hi Friends, I have a Module. And I want to create a Saved View (of filtering) by Action. Is it possible?
Import Error - More than one value for non-numeric cell
Hello everyone, I'm receiving the following error "More than one value for non-numeric cell" when importing data from our Data Hub model into our spoke model: The file that I'm importing into a module in our Data Hub contains a table (in CSV format): The "Id" values (which are unique identifiers tied to separate records)…
New UX clearing user entry
I have a display which allows user to enter values he/she is looking for. The page is based on module dimensioned by USERS. As the new UX requires user to clear the field one at a time and we have quite a few fields for filtering, I thought I create an action that will reset the fields from other dummy fields which are…
Error in Import - Expected 2-digit month number in date/period
Hi Guys, This might be simple but I do not get why it is having an error. So I have 2 identical modules. I have IC PNL and AIC PNL. They are both identical in terms of dimension and line items. So what I am trying to do is import IC PNL to AIC PNL that simple. Whatever numbers is in the IC PNL should be the same as the…
Tool for Choosing an Integration path
I have attached a decision tree for deciding on a Data Integration Method. I believe will be helpful to us with Clients to help them decide the best path based on resources and skill sets available in an organization. Please feel free to share!
Import same value from 2 dimension module into 4 dimension module
Hi, Have a small challenge - I'm trying to import line items from one module with 2 dimensions and into another with 4 dimensions. The 3rd dimension in the latter is set to ask on import but the 4th is irrelevant, i.e. the import should basically import the same line item values into the module for every item in the 4th…
ANAPLAN API : Get dump files from process with any action
Hello, I'have an issue, when i tried to retreive the dump file from a process with multiple actions, the API returns a 404 status code. The URL called : https://api.anaplan.com/2/0/workspaces/[WORKSPACE_ID]/models/[MODEL_ID]/processes/[PROCESS_ID]/dumps/[OBJECT_ID] Where the Object Id comes from the task result where…
Importing with Time Dim in Mapping
Hi, I have an Module with Tim Dim and list. It has a line item called Data which is an Input filed. I need to create action such that the data gets copied from one quarter to other. Example: I need to copy data which is Q1 to Q2. I tried to create a saved view and create an Import action from saved view to module, but it…
New Filter Option: "Absolute Value" and "In Between" Filter
It would be very helpful to have a filter option added that allows a user to filter on absolute value as well as to filter by defining a top and bottom range that returns amounts in between the range. Currently, we have built line items as a work around, but these tend to take a lot of space. This functionality should be…
PLEASE HELP--- Importing a value in the list
Hi Friends, I have a module abd SYS Mod 1. It has no list but only Line Items. I want to import, the Line Item value (ie. Jun 20) in the list. Kindly assist.
Need the Import Scripts | file name append with date & time stamp
Hi Guys, I need import action batch script to take the file name with (Date & Time details) and every time same file name keep on changing with updated date & time stamp. Example: File name : Import_File_Name_30062020_0930.csv and next time the file name to run the same import scripts is below: File name:…
Anaplan AWS Integrate Conflict
Hi! After we integrate Anaplan to AWS servers (https://community.anaplan.com/t5/Anaplan-Platform/How-to-integrate-Anaplan-to-AWS/m-p/63302) we starting to get analitics data conflicts. We grab data from Google Storadge which work with site(here link), grab with Python on AWS. Our bisness analitics have Flask microservice…
Excel Add In
Hi All, I am working on a model in which I have a combination list(A numbered list with various properties such as states, product, factories) applied to a module. When I am creating my excel sheet for that particular module using excel add in version 3.4 I am getting all the combinations of the list irrespective of the…
DAT03 Historic Volumes
I am unable to get the mapping correct. Can anyone assist?
Option to export Graphs with Title and/or Labels
When exporting a graph from the New UX, the title of the card is dropped as are the labels/selectors. This is the case whether it is exported via "print chart", or PNG/SVG/JPEG. Ideally, there would be an option to include/exclude this information on the export, but at minimum to automatically include this information on…
Export Action Mapping Basis
Sorry, couldn't find a official answer to this, and I've had different interpretations on how this worked over time, but just wanted a definitive answer: For export actions that you intend to repeat, what is the "official" way that the Export action is defined, relative to the module you are exporting from? We all know…
Excel Add-in: restrict end-user ability to create a new connection
* Description: As an author of the new Idea, I want to suggest the new level of security in Add-on(s). Where we can restrict the Non - WSA User not to create a new work book using the models that they may have access to. * Example of Enhancement: If the user is not a WSA for the particular model he should not have access…
Ability to filter module data for export via the API
Description: Be able to pass filter values to the export view through the REST API. This could be passed in the request body Example of enhancement: Let's say we have a view with data for all our hotels. We'd like to call the rest api to export data for specific hotel. Benefit/impact: We need to run exports through REST…
API usage on Users tab
Description of the enhancement required: 1. API : ability to delete users from a workspace via api. 2. API :ability to create users to a workspace via api. A story for why you want the enhancement: The process of searching for users, clicking their names, and clicking delete is very tedious.
Allow the option to not create an import as an action
The ability to select whether you want a manual data import saved as an action on the actions tab is requested. The reason being that during development and for sprint review purposes, sometimes test data or files with lists are uploaded to allow clients to visualize the end product. Every time an import is run, an action…

Upcoming Events

Anaplan Academy Open Office Hours [AMER]
Join us for Anaplan Academy Open Office Hours, an open, interactive space designed to support your learning journey. Whether you’re just getting started with Anaplan training, working through course content, or preparing for certification exams, this session is your chance to get direct answers to your questions. Our…
Anaplan Academy Open Office Hours
Join us for Anaplan Academy Open Office Hours, an open, interactive space designed to support your learning journey. Whether you’re just getting started with Anaplan training, working through course content, or preparing for certification exams, this session is your chance to get direct answers to your questions. Our…
Save the Date: Anaplan Workflow - Next Steps in 2026
We’re continuing the conversation! Following the success of our first Anaplan Workflow event, we’re bringing you a deeper look at what’s next. Join us in February as we expand on the insights shared in the previous session and explore how Workflow continues to evolve to support planning collaboration and process…

Data Integration

Discussion List