Data Integration

Duplicate Rows or Columns Excel Add in
After closing and reopening an excel add-in linked workbook I am seeing the attached error. The workbook worked fine before being closed. It has also broken the connection on another tab that was working correctly, I think this may be a separate issue.
Cloudworks - view the queued processes and/or cancel process queuing
In case of Anaplan issues with Cloudworks servers, processes that were on schedule start to form a queue that is released once Anaplan solve the problem. We ended up a few times in situation where the same 30 min process (normally scheduled every 2h), run 3 times one after another. This is causing problems with other…
Update Current Period Action
From April 24, 2021, model builders will be able to update Current Period via an action. Workspace Administrators (WSAs) can always update the Current Period manually via the Model Calendar, however, this may not always be convenient. The Update Current Period action enables the WSAs to increase efficiency and reduce…
How to mass-delete data from a List
Hi experts, Could someone give me a way to mass-delete data from a list? There are 300,000 of product data in the L_Product, and when I try to select all and delete them, "Cannot delete over 10,000 records" error appeared. Regards, inoue
Timedimension while exporting a module in .csv file
I am facing an issue when trying to export a module in .csv format. I have setup a Time Range that has 2 Periods and have available aggregations set as Total of All. In a Module I have this Time Range (which is in periods - Jan 20/Feb 20/etc...) in column and when I am exporting the module as a .csv file in the .csv file…
How I Built It: Beginners guide to integrating with Anaplan using Python
Author: Matt Budd, Certified Master Anaplanner and CIO at Nightingale College and Solution Architect at Dialed Solutions. Hello Anaplan Community! In the last year, I've done a lot of work around creating automation and integrations with Anaplan using Python. Several solutions I've built using Python include: Creating a…
Data Validation when using Anaplan API
One thing i've found quite challenging when doing API implementations (and at this point i've done well into my 20s of these) is, what is the best way to validate that my API calls are properly working? Specifically - how can I validate that file uploads are pushing in the right data? There are so many different variables…
Provide capability to import blank values for dates and list formatted line items
I would like the capability to blank out cells. This is not currently possible without clearing target before import. Description of the enhancement required: Ability to blank out cells without clearing the entire module each time An example of the enhancement: During the upload, there is an option which allows user to…
JAVA REST API example with Anaplan generated Certificate
Hi All - SSO is enabled for my tenant with exemption users not allowed due to internal policy so certificate authentication is my next option to bring data into anaplan is a systematic flow. I will obtain a CA Certificate as described…
Update export actions created from a saved view when saved view is modified
I think the title says it mostly, but to be clear I'd like to be able to do the following: 1. Create a saved view of a module 2. Create and export action using the saved view as basis 3. Modify and re-save the saved view (i.e. add a new column, change the filter etc.) 4. The export action should update itself based on my…
Option to export conditional formatting in export to xls
Description of the enhancement: Add an option to include conditional formatting in exports to xls
OAuth Authentication and Anaplan Connect
Hi, I have been testing OAuth connection with Anaplan Connect. And it has been quite a struggle. I started with "Authentication - Generate OAuth Token With Force Register" and it was not really working but giving strange error messages that didn't really help. After trial and error I got the example script to work by…
Model history api endpoint
As a integration admin, i d need to be able to access to the model history through an api endpoint and in the model This is required in order to - listen to models actions and check if / whenservicess outside anaplan should be triggered - extract for audit purposes the history of anaplan model and expose it to auditors or…
1.3.4.3 Update SYS07 Location Details Module
Hi All, I completed this task and everything seems good. Except Location name not populated in the SYS07 location Details module. Please see the screenshots attached and advise everything is correct and I can move forward. I tried to Manually map location to code under 3rd tab but not able to do it. Someone please help me…
RESTful API How To
You can interact with the data in your models using Anaplan's RESTful API. This enables you to securely import and export data, as well as run actions through any programmatic way you desire. The API can be leveraged in any custom integration, allowing for a wide range of integration solutions to be implemented. Completing…
Excel add-in save & refresh: possible to fill line item data with formula's in excel?
Hi, Using the Excel add-in, I am curious whether it is possible to auto-populate line item data using formula's in Excel. Can anyone tell me if it is possible to set this up and if so how? As an example: consider a module linked in Excel where cell A7 contains a line item with B7 a number that is editable. Is it possible…
Anaplan Excel add-in 4.3 Cloning
I am trying to copy an excel sheet with an existing Anaplan connection into another workbook. However, once the copy is done, the Anaplan connection seems to be broken and cannot be refreshed. I understand that the cloning function currently works within a workbook only, does anyone have any workarounds with respect to…
Different numbers being imported
I have 2 modules, both with exactly the same structure (2 dimensions, multiple versions, no time scale, and with only one line item). I created a simple import from one module to the other, however, once the import has run successfully with no errors, I'm getting different numbers landing in the corresponding cells in the…
Importing data directly from another Anaplan module
When a user is attempting to import data directly from another Anaplan module, they need to be able to use an identifier (code or link vs. the display name of the field) to ‘connect’ the records. For example: When a user exports from a ‘source’ Anaplan module, the user has the ability to export the ‘code’ or ‘list link…
Anaplan Connect: Difficulties setting up export from Anaplan to SQL Server
Hi, We're trying to set up a connection to export data from Anaplan to Microsoft SQL Server. We already have a working connection to import data into Anaplan, but we can't manage to set this up the other way around (export). We set up the export connection using the Anaplan Connect guide and our working import actions. We…
Add Bulk Copy to action list to be added in process chain.
Hi there, Current limitations with the version dimension mean we are not able to select Version as a list formatted line item (there is a separate ticket with community support on this topic). Because of that, we are forced to do a number of data moves using custom version lists, list subsets, and collect statements to…
Line Item Subsets API Endpoint
Create an endpoint for retrieving list of Line Item Subsets in the model. Also, we need an endpoint to see which line items are included into the subset.
How to set up integration from MS SQL Server table to Anaplan model via Talend
Hi, We are trying to load contents from a table in MS SQL Server table to Anaplan model (processes, actions, etc.) using Talend. So far we are able to make connection to Anaplan model and do the authentication successfully. We are able to view all import ids of the model / process ids / action id. I am following this user…
Integrating to Anaplan with Talend
Hi all, Has anyone successfully integrated a Database result to Anaplan using Talend Studio? I've looked all over and cannot find successful examples of querying a db, using that dataset and pushing it to Anaplan without saving it to a file first. My issue is I cannot get the db result into a format that feeds correctly…
Transactional API for Direct Module Data Access
Hi All, Has anybody built a solution using the Transactional APIs to Retrieve cell data for a view yet. There is reference of Denodo Virtualization tool on forums but it does not work for modules above 1,000,000 cells since there is restriction on the API endpoint.
Anaplan Google Sheets Plug-in
Anyone knows why Google Sheets Add-on would really slow down and then not let me sign in on Anaplan on a specific google doc? Could it be because of the size of the google doc? When I try to create connection on a new blank doc - it runs as expected. Thank you
#ERROR! in Anaplan Google Sheet Add on
Hi community, This was meant to be a question, but in the last minute I found out the root of the issue. So I decided to go ahead anyways and post it as a solution, just in case it helps anyone. Using Anaplan add On for Google Sheets, I was getting an #ERROR! value instead of the items of the dimensions of my modules, in…
Anaplan API V2 Line Item Extraction Missing All Fields
I am currently working to extract line item detail via the API V2. Is it possible to have all fields available via the API show even if they are blank? When pulling detail from multiple models the JSON extract will have a different number of headers/columns as I show in this example. To remain consistent is it possible to…
Excel Add-in (Submit data from multi spreadsheets to Anaplan)
Hello, We are using Anaplan Excel Add-in to upload data. We create a write connection with a one module which have Country dimension. Each Country is presented in separate sheet, can we upload data to Anaplan from all these sheets by clicking only one button - Submit? Thank you in advance for help. Best regards, Dominika
certAuthGenerator batch file
Hello All I am trying to run the certAuthGenerator.bat file in order to generate the JSON and CA cert info in order to add to Postman as I need to do an authentication test. I have followed all the steps in Anaplan's documentation. I basically have the .PEM and .KEY files and I have followed the direction to create the…

Data Integration

Discussion List