Data Integration

Dynamic Data Sources
Have the source model and source object name dynamically update in Import Data Sources as changes are made in the source.
Maintain Flat File Mapping in Copied Models & Model Mappings
When we move models from workspace to workspace, the Anaplan model to model connections remain intact, but all flat files need to be reuploaded and mapped. This causes a large amount of work per model that we move. Adding this feature would make the workspace governance process run much more smoothly.
Update API import error messages to display process and action name instead of task and import IDs
Import error records from API only display task or import ID, which makes troubleshooting difficult. Recommend to display process name and import action name instead.
Data Import Error - “Key for this row maps to more than one list member”
Dear Anaplanners - we have a couple of import processes that are presenting a number of Fails, with the Error_1_ message “Key for this row maps to more than one list member”. Is this an error message I need to be concerned about - as both of the lists that we are importing against we are aware are replicated to support two…
Error in importing CA Certificate
Hi All, We are trying to achieve CA Certificate authentication. While we followed the instructions provided in the link below https://community.anaplan.com/t5/Knowledge/A-Guide-to-CA-Certificates-in-Anaplan-Integrations/ta-p/39305#toc-hId-1363730354 , we got an import success message. But still, we don't find any file…
Production data column in import actions
What causes production data value in the Import Actions view to populate ? Also does it work only when model is in deployed mode ?
How to add a header name in module grid view
Hi Experts, I want to know how to add a header name in module grid view. As shown in the red circle in the picture. Or, I want to export this spreadsheet, so header name only in export is also welcomed. thanks in advance. Regards, Tsuyoshi
Importing Data into Parent Elements with breakback enabled
Hi I would like to know whether it would be possible to import data into a line item against parent elements of the list which has break-back enabled. I have tried doing the same but can't find any way to map Parent Elements. Attaching screenshots for reference.
Multiple Import Actions - Same Source & Target
Hi, I wish to create 2 import Actions where it is utilising the same Source Object & Target Object but there is only 1 action (which is the last upload) and hence I need to re-map etc when I wish to perform the latter Action The Source Object is a CSV file and which contains multiple columns. The Line-Item mapping on 1…
External reference of source Model while Importing model from One workspace to another workspace
Hi, I am importing a model from x workspace to y workspace. The import is successfully done. But the issue I am facing is that in the imported model of y workspace, I see that in Actions>>Import Data Source>>Source Model column there are references of source model (i.e. x workspace) for Module, List and Saved View source…
Informatica Power Center - Anaplan Integration
Hi All, I have a requirement to integrate Anaplan with Source system Database using Informatica Power Center. Power Center does not have an Anaplan Connector to establish a straightforward connection with Anaplan. There is an option to use the HTTP Transformation in Power Center to call the Anaplan Rest API. Can anyone…
Error when importing .csv data
Dear all, When importing price information (.csv file), it appears in Anaplan as a multiple of 1000. e.g: a unit price of 42.99 in my csv file is imported in anaplan as 4,299.00 As anyone ever experienced the same issue? Best
Consolidated Module (with list output type to combine)
Hi, I have 3 modules, all sharing the same dimensions (period, transaction# and employee list). The first 2 modules contains line item "metric" both with output type list (same list), I need to see all the data in all line items of module 1 and module 2 - it should be consolidated in module 3. In module 3, it has the same…
How to relate items to list
Hi experts I have problem in importing data. The picture is sample of failure. I want to relate specific employee under regions. How to do this in 1 step? thanks in advance. tsuyoshi
Error when importing to a module with new line items
Hi, We have some intermittent issues with import actions that give up the following error (in pic) The target module had a new line item introduced which was on a subset of the same list as the entire module. The module was based on Subset 1 (applies to). The new line item was based on Subset 2 (applies to). Subset 1 and…
End-user file import from a dashboard
Hi all, Just wanted to confirm if end users can use the data/import function via the little drop down arrow next to the module name on a dashboard? I am currently getting an error message and I am not sure what i need to "switch on" or assign for the end user to be able to run an import. I know that often an import button…
Connect to SQL server
Good day I have an SQL server as source of my data. What are my options to import this data to Anaplan? Thank you! Renier
Docusign Writeback comment feature
A feature to allow the employee to write a comment back to the manager or template sender. So it is about a write back feature to anaplan, but not of a mapped line item rather it is a comment.
Upload modules into new model new workspace
Hello Mates, I have exported (csv) my 10 modules from my model 1. This model 1 is in workspace 1. Now i want to copy/.upload all these 10 modules (with formula, format, summary..etc..) in different model which is in different workspace. But there is no import option available. Simply, i want to replicate my work in…
How to relate sub-region under regions
Hi Experts, I have problem in importing data again. Could you tell me how to map data Sub-Regions under Regions? For example NOAM > US North > Anderson, Janet Kindly see what is expected and what it is now in my screen. thanks in advance. Regards, Tsuyoshi <<What is expected>> <<This is my screen now>>
What are the settings for Exporting a Dashboard as PDF?
There is a dashboard which I want to export as PDF. But the exported PDF is very different from what I see on the dashboard. Please help me with this Dashboard ViewExported PDF View
Format of export data (ISO-8859-1 or UTF-8)
Hi Product team, What is the format of data when exported as .CSV or .TXT? Is it ISO-8859-1 or UTF-8. What I have seen is if the module is English only it outputs as ISO-8859-1 and if the module is Chinese, output is UTF-8. Can we have some clarity on this please? Thanks in advance. -Regimon Sebastian
Smart Sheet Add-In
Hi Anaplan, It would be great if Anaplan developed a Smart Sheet Add-In. This is a great alternative to presenting data in excel due to browser based flexibility and functionality of Smart Sheet. Thanks, Usman
Date Format conversion
I have a module in Anaplan whose one line item is date formatted. I imported a csv file which is having a date column with the format MM-DD-YYYY. The import results showed a failed report becasue it accepts date format as MM/DD/YYYY. Is there any way to map my csv file having the abovementioned format with the date…
Import of partial list
Hi All, Is there any way i can import a part of list into a model from a huge list from another model?
Can't upload the parent under partner list
Can't upload the parent under partner list
Get list of all models in workspace.
Is it possible to get list of models from workspace using Anaplan Connect? When I use Anaplan Connect, I have to use model ID. I want to download all models with model names and Ids. Customer will choose Anaplan model name in his app, I will download all models and I will get Id, I will send Id to Anaplan.
Ranking on data Loads
Hi, Please see attachment for details. Thanks in advance. Regards,
Parent Child Mapping Error
Hi, I'm trying to load master data in the system but in the files which I trying to load have erroneous records like one child has multiple parents. So is there any work around in which I can identify those combinations in a staging module for error check in anaplan.
Option to insert action before or after
Currently when I create an actions from within the Actions tab I only have the option to add this at the Start or End of the list of actions. It would be very useful to be able to select an existing action and use the 'Before' or 'After' functionality that exists when creating module or lists. This would save a lot of time…

Data Integration

Discussion List