Data Integration

Import mapping source of a line item/list to 'fixed item' or 'ask every time' remove 'Which target'
Description of the enhancement: Import Mapping: Mapping the source of a line item or list to 'fixed item' or 'ask every time' removes the 'Which target items to clear prior to import'. Can this remain there? As a user, I would like the 'Which target items to clear prior to import' option to remain on the line item/list…
Ability to format the layout of dashboard when exported to PDF
Description of the enhancement required & example of the enhancement: Ability to format the layout of dashboard when exported to PDF: - add page break between modules in dashboard - make the module page selection font size bigger
Provide ability to re-arrange Export labels
Use case: A list with over 20 properties. It is extremely difficult to reorder the labels in the Export dialog. It requires removing them all and then adding them 1 by 1.
"Omit Summary Items" should omit summary Line Items for Tabular Exports
Description of the enhancement: An Export with radio buttons "All Line Items" and "Omit Summary Items" selected results in Summary Line Items not being omitted. The "right" behaviour should be that Summary Line Items are omitted, or that a radio button with "Omit Summary Line Items" exists. Use case: 1) Exporting data from…
List exports to Excel limited to 65536 rows
There is a limit on the export of 65536 rows. Excel 2007 can handle 1048576 rows.
Improve Process Completed dialog box to highlight any errors
Description of the enhancement required: I am experiencing an issue for Non- Workspace Admin users performing an upload process. After running the process the dialog box reports Process Completed Success but upon reviewing View Details you can see there were errors. This is an issue for users who do not know that some of…
Which PUT Method to use?
I've run into another issue with uploading a file using the Anaplan API. For this client I'm trying to do a data integration from a data migration tool called Scribe Online where the API connections are configured using a GUI. When Scribe receives the API specifications from anaplan.com/swagger.json it brings in the…
Requesting File ID from Rest API Throws 500 Internal Server Error
Hello, I've been attempting to get the file ID from a model using the following curl code adapted from the Anaplan API docs in Apiary. curl -v --include --header "Authorization: Basic encoded_username:password" --header "Content-Type: application/json"…
Anaplan REST - issue uploading file
Hi, I'm not Anaplan guy but doing an integation with Anaplan through the REST API. Export of data works fine. Issues come with the import. As first step, we have to upload the file. We are using PowerShell but any feedback if other language is also welcome. My question is: shall we use --upload-file in the url. In the API…
July 14, 2018 Release Discussion
Do you have feedback on the July 14, 2018 Anaplan platform release? Share your thoughts below! Click the Reply button below to post.
Exporting major modules for archiving purposes
Hello everyone, Do you have some insights to share on the process of archiving data outside of Anaplan? Indeed, our current customer would like to store Anaplan produced data – each closing – in another tool. The constraints of our context are: * Many modules from which to export * Many lists in those modules (each time…
June 16, 2018 Release Discussion
Do you have feedback on the June 16, 2018 Anaplan platform release? Share your thoughts below! Click the Reply button below to post.
Date Flipping from UK to US style
Hi, I am importing data froma csv into a module and i have 7 date fields, they are all formatted (short date) exactly the same as each other, when i import the data, i have ticked the format to show D-M-Y which correctly showed the dates and applied to all date fields as normal.. However when i import, 6 of the fields are…
Differences between api2.anaplan.com and api.anaplan.com
Hi, Documentstion is not clear... What are the differences between api and api2? Our client tool works with api2 but it doesn’t with api Thanks for any clarification
How to use Data Tags
Hi, I am trying to understand how to use data tags , I uderstand that we create tags in settings and assign the same to various objects in the model however I am not sure how and where can I use those tags.
Importing duplicate rows into a numbered list
One of the reasons for choosing a numbered list is that it supports duplicate combinations of properties. Does anyone know how you can import into a numbered list from a CSV containing duplicate rows? It is not acceptable to have to add anything to the CSV prior to import. For example the CSV has 3 columns headed List1,…
Anaplan Connect Batch Script Error: "Anaplan API: The Credentials supplied were invalid"
Hello, I am trying to set up a certificate to run my batch scripts instead of having my username and password included in the batch scripts. I have confirmed that the batch script works when including my username, and then manually typing in my password; however, when I replace the information with a new certificate that I…
Masking Username/Passsword Within Anaplan Connect Scripts or Certificate Based Authentication
Does Anaplan Connect support or provide functionality to mask/encrypt usernames and passwords within the batch files created to run jobs? Or is there a preferred method in setting up Anaplan Connect in which you will not need to explicitly state usernames and passwords within the batch file itself. Thanks for the help.
Make action to export data based on view dynamic
Hi all, We currently have a dashboard showing a view that is updated automatically based on selections and filters on top (e.g. if you select a certain country or brand, only the relevant SKUs are shown). Next to this view we want to offer export and import actions so the user can create an offline CSV, work on those…
Anaplan API Error: The credentials supplied were invalid.
Hello, I am working through the Anaplan Connect guide and have run into an issue testing the first import of a .csv file. I'm using the following script stored in a .bat file. @echo off rem This example loads a source text file and runs an Anaplan import into a module. rem For details of how to configure this script see…
Upload file (.csv) used for Anaplan import in the past
Hi All, Is it possible to download the csv file used for an Anaplan import in the past from the Anaplan cloud. I have the import details from the History log with the ID & date/time details. Would the file used for this import be stored somewhere in the cloud and can we download them for any future reference? Thanks in…
OEG Best Practice: What are the benefits of creating a Data Hub?
If you're familiar with Anaplan, you’ve probably heard the buzz about having a Data Hub and wondered why it’s considered a “best practice" within the Anaplan community. Wonder no more. Below, I will share four reasons why you should spend the time to build a Data Hub before Anaplan takes your company by storm. 1. Maintain…
Anaplan Connect Error with Proxy or Firewall
Anaplan API: Communication failure <SSL peer unverified: peer not authenticated> This is a common error if a Customer Server is behind a proxy or firewall. The solution is to have the customer whitelist '*.anaplan.com' for firewall blocks. If behind a proxy, use the '-via" or 'viauser" commands in Anaplan Connect. The…
Is it possible to skip lines when importing data from CSV?
Hi, is it possible to skip lines based on defined combination of imported fields values? Ideally also without raising any error. Warning would be OK. Cannot manipulate the CSV file before the import. One solution, far away from ideal, would be: * import first into a temporary table with fields as line items * create a line…
May 19, 2018 Release Discussion
Do you have feedback on the May 19, 2018 Anaplan platform release? Share your thoughts below! Click the Reply button below to post.
import data in data hub and then execute process to laod several Models
using anaplan connect. batch executed via a BODS job called by a SAP process chain. All is working well if i import a file with Master data in 1-data Hib 2-model 1 now i would like to do same action but want to send this is 2 additionals models so basically: 1-data Hib 2-model 1 3-model 2 4-model 4. our anaplan…
Create Hierarchial list using import
Hi, I am trying to create a list as shown in the attached image. Here i have'nt created the seperate list for 5804 (which is like parent list). To avoid sparsity & size constrain, i am trying to create parent & child list in the same list. I know how to create in the tool for less items. Can someone tell me how to use…
Issue logging into Anaplan using Firefox
Hi Team Am not sure if this is the right forum but could not find one for general discussions. When I log into Anaplan using Firefox, my machine drastically slows down. it does not happen while using Chrom or IE. Any one experiencing same.
Anaplan REST API Authentication with SSO
Does anyone have experience with making get and post calls against the Anaplan API after implementing SSO (SAML 2.0)? Before we setup SSO, I was able to pass my "username:password" credentials in Base64 to authenticate against the Anaplan REST API and make get + post calls successfully. Now, when I pass the same…
Create Hierarchial list using import
Hi, I am trying to create a list as shown in the attached image. Here i have'nt created the seperate list for 5804 (which is like parent list). To avoid sparsity & size constrain, i am trying to create parent & child list in the same list. I know how to create in the tool for less items. Can someone tell me how to use…

Data Integration

Discussion List