Data Integration

Customized exports from UX Page
Hello, I was wondering if it is possible to customize the export of UX Page in PDF format for the end user. What do I mean by customize? Now we have created a UX Page, from which data export in PDF format is generated (it contains tables, charts that are on this page) - the data for the corresponding page selector is…
More than one value for non-numeric cell - Boolean
Hello, I have a input module published to a dashboard that allows planners to enter new headcount for their departments (Planner Dashboard TBH Input - DB View). I import this data into another module that doesn't have the department dimension (To-Be-Hired - Input). The purpose of the dashboard module is to prevent planners…
Level 2 conclusion INV01 export view
I have created an export view from my INV01 module. I've been able to deselect the hierarchy for the products but when I try to deselect levels for time the option is greyed out. I've tried pivoting the view and that still doesn't work. The export looks like the example except for the monthly summary. Can someone help me…
Actuals load time
Can anyone share how long it would take to load ~20M records of actuals into Anaplan ?
[Start Here] Transactional APIs – Part 1: The Basics
Welcome! We’re so glad you’re here. We’re shining the spotlight on Anaplan's Transactional APIs and we’ve crafted this blog post to cover the basics like what it is, who is it for, and a high level overview of some use cases for them. Let’s get right to it! What are Anaplan Transactional APIs? Data integration is a key…
Dynamic target version for import to module
Hi, I would like to know if somebody is out there to help me with a problem 🙂 Each month we make a Sales proposal in our source module (in the version Plan Proposal). After approval of the proposal, the values of the plan proposal should be copied to a different target module. We need to copy the values starting from the…
Pasting Multi-Line Cells from Anaplan to Excel
I'm experiencing an issue where copying multi-line cells from a default module in Anaplan does not properly paste into Excel. In the attached image, I'm copying three rows from Anaplan to paste into Excel. Instead of pasting 3 rows, the second line within each cell of the "Admin Comment" column is shifted down and to the…
Exporting summary calculations from Anaplan to Tableau
Hi I have an Anaplan model whose data I'd like to see in Tableau. A lot of the line items that I want to see are ratios, and in my Anaplan model they are recalculated at summary levels. e.g. * North: 25% * South: 15% * West: 30% * East: 45% * Total Company: 29% (not 115%!) I've read the documentation here and it advises…
Informatica Import from file via Process
Is it possible to run an Anaplan process from Informatica in one Informatica step with the standard data import process? Or do you have to call each action individually in Informatica and set up the sequential ordering (A then B) in Informatica? Process: Step A = Import into list from file (builds Anaplan code from UID)…
Anaplan integration with SAP
Can Anaplan consume REST based SAP Webservice?
Anaplan - Certificate for the authnication
Hello Team, Can someone help me on the process to get the Anaplan authentication certificate?. I know that, initially we had an option in Anaplan to generate the certificate and later Anaplan team is used to share the certificate. Any Suggestions would be appreciated. Thanks!! Regards, Venkat
Add-In Sign on
Hi Team, When attempting to sign on through SSO in the add-in, the window moves to the view of a web browser and I'm unable to sign on. May I have your feedback on this please? Thank you Matthias
Cancelling Import will remove any partially imported data or list items
As a user, I would like any partially imported data or list items to be removed when I cancel an import. Currently, when an import is cancelled mid-way through, any partially imported data or list items will remain after the import is complete. However, the history will show that the import was cancelled. This will help…
Level 1 Model Building import data for Non employee model
Hi all, please help me in importing the data of non employee expense
Lesson 7 importing employees
please help me to correct the format exactly with anaplan screenshot given in leaning centers for example i need SHALA ENGLE in first column
Level 3 Sprint 1
Hey, Its regarding Level 3: Sprint 1 : User Story says " Import the Financial Forecast data from the Level 1 FP&A model" I have used the "Baseline+Financial+Forecast.csv" file for now. Can anyone help me to identify if the mappings given in the image are correct? Unfortunately, I am getting the error "Invalid line item…
Unique ID longer than 60 chars
Hi, As per Anaplan's best practice in loading data, we are trying to create unique ID, however, since the original codes are very long, the unique IDs we are trying to create by concatenating the codes of the different dimensions are longer than 60 characters long. For example, we have Cost Center, Measure, FinGeo etc, and…
Confused as to why this import is not mapping automatically
I am trying to build a process where end users can upload values into an input module. Ideally they can export out the template from Anaplan and then update the values and then import the updated csv into the Module. However when I am trying to create the import action the automatic mapping for the field Sales Plan Region…
How to use Talend with CA Certs and Transactional APIs
In this article, we will illustrate an example of real-life scenario involving Anaplan's Transactional APIs with Talend and CA Certs. If you haven't already, we recommend to start your CA Certs journey here and then there. Pre-requisites * Talend Open Studio Knowledge * Anaplan REST API * REST API & JSON * Python…
How to leverage sample codes to generate authentication strings from CA Certs?
This content has been updated. Please visit the following article:
Commission % on employees details module
I have imported the data into the employees details module. everything is correct however the commission % is not showing correctly. The correct format is 0.15% and the imported format is showing as 15.00% what am i doing wrong? screenshot attached.
Import a csv file to a module where "Months" are line items
Hi, Anaplaners I am struggling with import data where one of its columns represents time "YYYYMM" to a module where Time dimension is "Year" and "Month"s are a line items. Would you take a look at the attached to see what I would like to achieve ? Such an import ever possible ? Thanks in advance.
Possibility for Data encryption during export
hi Community! Our business users would like to protect exports from anaplan with a password. So that, any time when they export a file with confidential information, it could not be accessed people without authorization. Do you have any idea how this can be done in anaplan or using other technologies in addition to…
Run your integrations on Camel
Integration is one of the key implementations for most enterprise solutions. It involves connecting different applications and transforming a huge amount of data on a daily or ad-hoc basis. Different iPass tools are available in today's market to make the integration easy to use without any coding. They provide a good user…
issue loading data from views with page selectors
Hi, I am running into issues when I try to import data from views with page selectors - when I save a view that has selectors and then set up the import elsewhere, the view looks completely different, and can lead to unpredictable results. There are workaround available, but this seems like an problem. Thanks Ethan
TaskID REST API answer - to contain audit information about launch timestamp, users
Hi, When using REST API scripts, in the answer to a taskID for processes or imports, there is all the information that is needed except some very useful audit information like: - Timestamp Start TaskID - Timestamp End TaskID - user that launched the task Is it possible to add these kinds of information? Thanks Alex Bellow…
Anaplan - Denodo
Does anyone know if Denodo can be used to connect with Anaplan?
How to use AI tool
Hi. My team is going to use AI tool in Anaplan, and I can't know how to use it. This article in 2019 said that we can use it.…
level 1 Model Building (lesson 7)
How to map data for module employees? import process will populate the module with Name, Country, Start Date, Leave Date, Current Salary, and Commission % data. also need to set header and first row.
Snapshotting Issue - Formula Summary for Time Periods
Hello! We are doing snapshots for some key metrics, and I'm facing an issue where a few of the source line items are %ages with a Formula summary for Time period. When these are being imported into the snapshot modules, the quarter value is being messed up because that can't have a Formula summary. I figured I could create…

Data Integration

Discussion List