Data Integration

File Missing in Level 2 Sprint 3
Hi, Is there a .csv file for the Shipping Methods and Time taken for delivery? If not then it is not mentioned how should I populate it? Regards,
Add Filters for Data Import
I have Module A form where I want to import Data to Module B. I can't touch Module A, so I can't use Export function from Module A. As shown in the pictures, I want a filter Import of a particular country. I have worked on creating saved views and exporting but not sure whether same can be for Import as well. Any inputs…
Integration with ERP based on date uniqueness
Can Anaplan able to import data based on uniqueness of date? ( It's a numbered list) I'm trying to upload data with date as unique factor but not able to succeed at it. Please find attached screenshot where i try to upload quantity transaction data into anaplan based on customer, size, date uniqueness.
Add a new Data Hub
What are best practices when is needed to create a new Data Hub due to workspace space limitation to 130GB? I have already built the Data Hub which contains historic data and data validation processes. I still need to load further years. The only option I have, without deleting the data already loaded is to create a new…
Safety stock import filling missing
I find the safety stock import .csv file is not uploaded in the Sprint. The image I uploaded is an old one shared in the community. Can someone please share the file or assist how can I download it?
How to import data without manual mapping for Numbered list?
Hi, I want to upload data into a module that has a numbered list as a dimension, as a result of this I have to manually map list elements manually to excel file rows Any technique for automatic data mapping of numbered list elements to excel rows? PFA Screenshots of my mappings for more clarifications:- 1. Source or Excel…
Issue with value addition
Hi Community, Can someone help me understand, why am I not able to fill in any values for Volume Line Items even manually.
SFDC Integration
What are the available ways to integrate SFDC with anaplan, How i can enable data flowing between these two systems?
Informatica doesn't find Anaplan Model as source/target model
Hi all, I'm trying to connect Salesforce and Anaplan via Informatica. I've setting up Salesforce and Anaplan add-in in informatica and 'test loging' works for both. When I am trying to create a new synchronisation task for an update, Informatica recognizes Salesforce. However for Anaplan, it seems that Informatica can't…
Selective push of line items through ALM
Hello fellow Anaplaners, I was wondering if it would be possible to selectively push line items/modules while synching models through ALM? The idea is - I would like to setup a master model and then migrate only the required functionalities/calculations to two different target models. With this setup, I will have to design…
Lookup data from two line items with different format and "applies to" lists.
Hi, My current build has been full of surprises. Right now I need to lookup start dates for new employees, but, the module I am building and the model from where I need to take the data, both use different lists. As you can imagine the lookup does not work and I cannot just pull data directly over without a formula. Do any…
Anaplan sales planning with AI
Anaplan yesterday announced that now platform has capability of AI predictions for sales planning I am not able to find any documentation or anything on platform does anyone have idea where to find it?
HyperConnect Transformations
Hi, I'm trying to find examples of what kind of things can be done with Hyperconnect Transformations. I haven't been able to find anything on transformations.. TIA, Danny
import file amount rounding
hi anaplaner, i have problem about impor/upload file, when iam upload file number format, data in anaplan and excel file always different, ex: excel file 497.157.884.509 but in anaplan 497.157.000.000. how to fixing that problem?, and why is that? Thanks, Panji
Unable to Connect Using Basic Authentication : Says Invalid Credentials
This is my first time using Anaplan Connect My Batch 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 doc\Anaplan Connect User Guide.doc set AnaplanUser="sripad.lokapure@abc.com" set…
Anaplan Connect model to model import process API Timeout
Having issues running the Model to Model import between work spaces. Has anyone encountered this issue... API request is timing out... Processes not found: Processes not found for Model ===================================================================== Anaplan Connect 1.4.2 OpenJDK 64-Bit Server VM (Oracle Corporation)/…
Use RESTful API to Export Data from All Modules (Without Export Actions)
Hello, Is it possible to export data from all modules (or selected modules; let's say there's 70 of them) without individually creating export actions for every single module? Thanks, Arthur
Anaplan connect 1.4 Shell Script
Hi Leaders, I have got encountered with the below error as I try to do Anaplan connect version upgrade 1.3 to 1.4. Not able to figure out the error. Script: # This script executes a data load import to the model set JAVA_HOME="/****/jdk1.8.0_191/bin/java" set CertPath="/******/OpenSSL-Win64/bin/certificate.pem" set…
Importing into a list based on a specific value of the parent
Hi, I'm trying to add functionality to a model where G3 items in a list are deleted and replaced with other items in that same list. The model has the following Hierarchy: In the G3 list, each Resource is either a resource in the current scenario or in the future scenario, this is achieved by the 'Type' property: On a…
Error when importing a csv file into a module
I am facing an issue with exporting and importing a csv file. So I have a file that I am exporting with data for 12 months (Dates are formatted as Y-M, (i.e. 19-Jul) in the exported csv file). Then when I try and import the same file using custom mapping (Y-M) for Time, I get a failure dump and an error which reads: Import…
Importing a list data by end user
Hi, Just want to know, can end-user able to upload data into the Anaplan list? or only workspace admin can do it? Anyway, he can upload changing user access? Import Action can solve this issue but anything other than that? Thanks & Regards Sai Bharadwaj
See mappings for file imports
Hello, I constantly run into the same issue and I'm hoping that someone can help suggest a solution. When I create an action that imports from a csv file into a list or module, I always find it difficult to re-open up that import action and revise (or just view) the mapping that was previously created. Instead, I have to…
MSAD change (Microsoft 2020 Jan release)
Hi, I came across the following Microsoft LDAP change that will be introduced in January 2020 and I was wondering if there is anything to bear in mind from an Anaplan point of view? (eg login, integration, etc). Here is the link :…
Excel Add In Filtering for Base Members Only
Hi All, Has anyone come across the ability to filter only for base members against a hierarchy in the Anaplan excel plugin instead of having to manually deselect all the parents them each time? The alternative is that I can think of is creating a saved view that only shows base members of the list, however the downside…
Excel Addin 3.3 - Filter on Line Item
Tried the new Addin, great improvements vs. 3.0 but still the same constraint of 1M cells. With that, I think we really need to have a Line Item filtering function to be able to control # of lines to download. Will this function be added? Thanks.
Length of Text value
Hi Anaplanners I have a question about the length of Text values.I tried to import a text data(500bytes) to a text format and failed.I was wondering if I had exceeded the length limit. Is there anyone can tell me the maximum length for Text values.Thanks!
Anaplan Connect 1.4.2 Shell Script
Hi, I was encountered with the below error code as I execute shell script. Shell Script : # This script executes a data load import to the model set JAVA_HOME="/****/jdk1.8.0_191/bin/java" set CertPath="/******/OpenSSL-Win64/bin/certificate.pem" set PrivateKey="/******/OpenSSL-Win64/bin/private2.key" set…
Tracking historical data in a live model without making the model huge
Hi Community, I've built a model where end users input information and it calculates outputs. This tool will be completed by end users on a adhoc basis, some will use it weekly or monthly, while others will it once in a while. One of the outputs, shown below, is based on live information in the model: As we want to keep a…
Territory Allocation Urgent
Import current month data
I already have previous month data. Now I want to import only current month data. Please assist.

Data Integration

Discussion List