Data Integration

Anaplan Connectors for Informatica Cloud
Hi Guys, I'm trying to use Informatica cloud to connect Anaplan using it's Informatica connectors But i'm not seeing these connectors in my Informatica cloud. I tried to download the trial version of it but I'm getting message, my Org already have access to these connectors. I have reached out to Informatica team and they…
Organize Actions after Model Building
After completing model building activities, we need to prepare the model for User Acceptance Testing, one of the requirements is "Review and organize the Actions to rename and add repeatable actions to a process and remove any single-use/one-time actions"... When I look at the actions, some imports were conducted multiple…
L1MB - Model Building - Importing data to Modules (Employee Details)
Dear APC, Can any one help me why I get to see mismatch in Employee names when the file used is same for creating the Employee List and Employee Details Module. I tried to delete the Employee list and re-created the new List and loaded employee names from csv file. Same csv file is used to load the Employee details - but…
L1 SYS08 Employee details data import target item greyed out
Hi, I'm trying to import data but the "department "is greyed out. Does anyone know why this might happen and how to fix it?
Importing into SYS08 system module
I am confused with the mapping part of the source to target as well. As is where to map Active? Employees = Code? ( Because it is numbered list) Dept Code = Department? Country Code = Country? Active? =? How to make sure data we are mapping is correct?
Add the ability to make external REST API calls from within Anaplan
We should be able to trigger external APIs from Anaplan models so that we can build integrations between Anaplan and other systems and allow the Anaplan users to trigger them when they know the data is ready.
Anaplan Excel Add-In 3.4, Show Changes
Hi Everyone, thanks for your time. Would like to ask if anyone knows if it would be possible to update multiple modules at once across different sheets with the show changes option in the excel add-in (similar to how refresh worksheet works). Currently I am able to only do it for each sheet, am asking to see if I missed…
Level mismatch on common dimension
i would like to get inventory DOI calculation from module-KPI DOI to module-Inventory ending report. Therefore, i inserted 1 line item call DOI into module-Inventory ending report then put formula as below. Then i get below error message. You can refer to attached document for 2 modules blueprint. Module inventory ending…
Rename List items
Dear Friends, I need some help from you. I want to update my list. My initial list items (12 list items), will be renamed and a new list will created with the (4 list items).
Urgent help assistance
Hi Friends, I am struck with a difficult situation. I have Module 1 and this is the Data Hub and the Date is stored in Text Format. Every quarter I need to pull the data and make it look like Module 2. Now my problem is as the Date is in Text Format, I was trying to find the current year. By converting Text to Number and…
Requesting a serious help
Hi Friends, I want to create an Action process. That will automatically import the current year data. Please assist me in this.
Time out issues with Anaplan Connect v1.4.4 console while importing LARGE files
New to Anaplan, loading large volumes of historical transactional data to support multiple models. We have a clean structure and the process "works" but virtually every import into the module has our session in the console timeout. It appears that the file has loaded successfully, but when the console times-out, I lose…
is there an API Endpoint for all listed import errors?
@jesse_wilson Is there an API endpoint for all import errors? For example, a user can get these types of errors when importing to a model: no items in a list, failed cells, and unmapped line items, etc. I've automated imports with a custom script. I've now purposefully introduced errors into my imports so they fail and…
Mapping numbered lists during module to module import
Hi all, Seems like this should be a straightforward one, but I can't figure it out.. I am trying to import data from one model into another model, using numbered lists. The Source module and Target module (which are in two separate models) both have a list called 'Towns' as a dimension. This list is a numbered list, but…
Excel Add-In tab does not appear
Hi All, I am a new user of Anaplan. This is the first time I try to install Excel Add-in. I have followed all the steps required, up to the point I can see Anaplan Excel Add-In appeared in the Active Application Add-ins list, in Options window of Excel. I have tried checked/unchecked the box several times in the Excel…
Getting more detailed error messages for automated imports
I have a Python script that automates the import of a file to Anaplan: fileData = { "id" : "file_id_here", "name" : 'file_name_here', "chunkCount" : 1, "delimiter" : '"', "encoding" : "UTF-8", "firstDataRow" : 2, "format" : "txt", "headerRow" : 1, "separator" : "," } url =…
Anaplan CA Certificate: Are Sectigo a supported CA?
There's a guide here on procuring a CA Certificate from Sectigo: https://community.anaplan.com/t5/Releases/How-to-Use-Third-Party-Certificates-With-Anaplan/ba-p/49116 However Sectigo aren't on this list. Supported Root certificates:…
When saving a view ignore the case sensitivity
We have a 10-minute rollback sometimes and we are very careful to ensure formulae and entries are correct. The one annoying thing is case sensitivity on views. I had to wait 12 minutes because I saved a view as Customer Data and then saved as Customer data. It does not ask if you wish to replace and it does not allow the…
Import Data into SYS06 Product Details
1) Mapping Tab: I am confused as to what to insert in the time tab as in the course structure it was clearly given whether we want to import it as an actual or forecast data. But here whether to choose fixed time or Ask each time import is run? 2) Line Item tab: How to go back and check the target items having product…
Excel Add-In OLE Action
Hi All, I wanted to see if anyone has been encountering this issue with the Excel Add-In. Oftentimes members of my team will go into Excel, log into the add-in, and then the whole Excel Application feezes. It freezes for a few minutes and then comes up with a message box saying "Microsoft excel is waiting for another…
Import Pop-Up
Hi Team, A user has just started receiving a strange Pop-Up when they use Data - Import when within a Module Normally you start with the Select Source pop-up and move to the mapping items etc while this has no mapping items etc Is this due to access levels? Thanks User Upload Pop-Up Normal Upload Pop-Up
import action not grabbing latest data file
I have an import action for importing data into a module. I've created a process for this action and a button for the process published to a dashboard. When i click the button....sometimes I have to select the file to upload and sometimes I don't. The data in the flat file has changed but I don't see that reflected in the…
Filter by formula
I have a particular existing module. Now I want to create a new module which will only have the filter records. Please assist.
Delete record without saved view or filter
Hi Friends, I have a Module from which I want to delete the highlighted records. But without using filter or saved view. I can use any formula to do so. Is is possible by any chance? Kindly help me, if you had worked in a similar restriction.
History from Archived Model
Hi Guys, Does History still works on Archived models (Change the mode from archived to standard). I cannot retrieve data from the production model due to switchover for some cells and I would like to check it out from an archived model. Regards,
Importing a csv file - Question
Hello Anaplan experts! I am very new to Anaplan and am going through the courses to get my Level 1 certification. I am sure this is a vey silly question, but figured I would ask rather than keep spinning my wheels. I have a csv that is attached. I need to Import this file into a Geo Hierarchy, but am having trouble mapping…
L1MB-Part 8: Data Import For Rev
I'm not able to import the data correctly. The mapping of the columns seem off. I'm trying to use column headers for time but it keeps picking up the first column where it says Volume (See attached). Is this because the way I built the module (see screenshot)? Thanks, Kevin
Anaplan API WADL
Hi , We are looking to use the anaplan api with one of our ETL tools which allows us to setup a connection using a rest connection, however it's looking for a WADL. Is this something that exists or will we need to create this ourselves. Thanks D0nmac
Contents of import actions
For import actions it would be good to have a column in Imports tab. suggesting which of the source items(list or lineitems) are mapped to target. Not the natural mapping by anaplan but any thing which is manually mapped and saved rather than opening each action and figuring out.
Db2 integration with Anaplan
Hi All, We are planning to start to integrating data from Db2 into anaplan for planning. First i did not find any search results with Db2 so starting link in case any one ha earlier experience please share your inputs. Secondly, more specific question are their any anaplan recommended connectors for Db2? And third in case…

Data Integration

Discussion List