Data Integration

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…
Tabs in data when using Anaplan connect
I was loading data using anaplan connect and i got an error saying there was a tab in my data. Turns out anaplan connect Anaplan Connect cannot allow tabs in TEXT fields. This is rooted in how Anaplan Connect constructs the information from JDBC to be passed into Anaplan. I got around this in the sql by using the following…
Delete from List using Selection
Hi Everyone, Is it possible to use the "Delete from List using Selection" to empty a module? Best regard Patrick
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…
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…
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…
Import from Salesforce - Case Insensitive Code
Hi, Today I did an import from Salesforce into Anaplan. I ran into a problem with the Opportunity IDs. I use the Salesforce Opportunity IDs as Code for my list. However, I have duplicates because Salesforce uses case-sensitive IDs, while Anaplan codes are not case sensitive. I know that there is an option to convert…
Anaplan Import Message Error
Hi All, I'm trying to upload actuals into my model however I keep getting Error Message 1. As I workaround I tried splitting the file into pieces to upload it. But while doing that I recieved Error Message 2. Can someone help me out with these error messages and let me know if there is any other work around this issue.…
Anaplan Import Message Error
Hi All, I'm trying to upload actuals into my model however I keep getting Error Message 1. As I workaround I tried splitting the file into pieces to upload it. But while doing that I recieved Error Message 2. Can someone help me out with these error messages and let me know if there is any other work around this issue.…
Filter Line Item in Module view based on another Line Item
Hello, Is there a way to filter line items in a module on a dashboard based on another line item? I have a line item called input preference, which has two options: Dollars or Percent. If dollars is selected, I don’t want my end users to see the percent input line item, and vice versa. When I try to use the filter, and…
Amending existing Imports
Hi, Apologies if this has already been covered elsewhere. I'd like to be able to edit existing import processes without the need of recreating them. The specific use case is that I provide self-service functionality for users to interact with apps and load data and metadata and I tend to do so via .csv upload. I then…
Snaplogic connector
Hi All, Can i get detail information using Snaplogic connectors for integration in anaplan.
What port(s) do I need to open for Anaplan Connect?
I am trying to run an Anaplan Connect script, but my firewall is not letting the traffic through. What port do I need to open?
Command Line Application Testing tool
I have a CLI developed in Go that automates the AWS devops platform. This app parses commands from a 'YML' and does build, deploy etc. I want to test this at a high level through some automation process, other than writing bash scripts. Is there a Framework or tools that I can use to automate this process? Thanks…
Import Date from CSV
Hi, I want to run a script to update the date on a daily basis. I have a batch file that creates a csv file with header Date and the date underneath on row 2 in format 08-02-2018 also tried 08/02/2018 However i can not import this to a module with a item formatted date, as it will not recognise it as a date , no matter…
Change to Import in ALM production list
In a production list, I have added one new property to the list and updated an existing import action to import data into this property. This action remains unchanged otherwise. This change was made in the development model In the production model, after the changes have been pushed from dev, and running the above action,…
Guide to import data from PostgreSQL/JDBC source to Anaplan using Anaplan Connect
1. Introduction I have written this guide to hopefully help save some time as I encountered a few, less straight forward, issues when setting this up. There is a guide describing Anaplan Connect, so please regard this as a complement to that guide on how to set up a JDBC connection. I will use PostgreSQL as an example…
Saving document Errors when using PowerPoint Add-in
Hello - looking for some answers to an issue we are seeing when saving using the Power Point Add-in. This does not happen all the time and we can not determine the cause. Once we have created our slide and done work to format the information in the proper charts and may have been able to save previously, we begin to get an…
Import error when list name is same as parent name
Hi, I am trying to import the data to my list for which i am getting an error as "New property combination found but name or code already exists" when list name is same as parent name. Ex: B is a parent of another list with same name. Do i need to manually add list in these situations or is there any solution for this. And…

Data Integration

Discussion List