Data Integration

Excel Add-in 4.0 - Make Clone function be able to clone a tab into another workbook
Hi, I would like to suggest adding additional functionality to the Clone button. It would be helpful to be able to clone a tab and all of its formatting (or at least the tab's connection and connection settings) to a new tab in another Excel workbook and/or to a new tab in a brand new workbook to be opened. Thanks,
Automate Notification Feature
Hi Team, I have currently published the "Notification" button on New UX page which shares the URL for the respective page with defined "Recipient". Anaplan has introduced the "ANAPLAN Cloudworks" which automates the defined Actions(Import/Export) but how can I automate the notification feature through ANAPLAN Cloudworks…
CloudWorks Integrations & Processes General Columns
I don't want to waste the space to create an extensively long name to identify what Model my Integration corresponds to, especially when we add many new integrations. Can you please add the Workspace and Model to the columns available when looking at Integrations so I don't need to click into every single one to check…
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…
extend time to access anaplan
Hi, Unfortunately, my access to my profile was expired, All my models and apps and Data have disappeared which I need to finish my course. I am middle of level 2 and it is very important to finish my lessons. Do you Know How can I recover my DATA or extend my access? I am a student and 90 days were not enough for my to…
Transactional API For Meta Data missing information
I am building a workspace audit model where I want to extract all information about models, modules etc. When extracting the data some fields are only partially populated. For Example: Model Information - The Size is not always populated Module Information - The Module id is not always populated Has anyone else experienced…
Dell Boomi - Certificate issue
Hi, I'm using dell Boomi to connect Anaplan. I have the certificate but i'm not sure how to get the Private Key Alias. Any suggestions?
How to update existing records(s) and insert as new records if not exists like UPSERT
Hi, How to update existing records(s) and insert as new records if not exists like UPSERT through Anaplan Connect script for MS SQL Server? Thanks & regards, Anil
Anaplan API Authentication service - nuances...
Official documentation from Anaplan: https://anaplanauthentication.docs.apiary.io/# In order to successfully connect to the Anaplan Authentication service you will need to: * Generate a CA certificate. with access to both the public certificate and the private key * Add the public cert to the anaplan security site *…
How I Built It: Integrations using CloudWorks
Author: Gokul Selvam Sadasivam, Certified Master Anaplanner and Senior Manager, Business Platforms at Okta. Hello Anaplanners! I’m excited to share a video that I created as part of the ‘How I Built It’ video series — diving into Integrations using CloudWorks. In the video, I give a live demonstration of how to use the…
CloudWorks Integration with Amazon S3: "There was an internal server error"
Hello, I'm trying to get Anaplan to an Amazon S3 bucket. I have set up a connection and it seems to work, however when trying to pick a data target I keep running into the issue of there being an "internal server error". Any thoughts on how to resolve this?
Google Sheets Add-on Performance
Hello, We would like to use the Google Sheets Add-On, but face the problem that every step, including the refreshing and sending of data to and from Anaplan is very slow and time consuming. Using the Add-on in a new empty sheet works faster, but the client works in several Google sheets with multiple…
How to change date language setting in module
Hi, Is there any way to change date format in Module from English to other language? I set both my browser's language settings and Anaplan's user settings to my local language, which is Japanese, but the date in Time dimension is still shown in English like in the attached picture("Jan 20" etc). I do not need to change the…
I want to understand the use of this feature?
I am trying to import data from Data Hub to spoke model. The requirement is to clear the target before loading the new data. Can I use this option at 'All Items' as an alternative to creating clear module data actions using 'No data' formatted clear line items in the target? Is that more efficient? Does it work the same…
Level 2 - Conclusion - Create Country Currency List
Hello, While I try to import the currency data, the data for EUROS is not getting updating because it is similar for 3 countries. I tried selecting the name or code also, name only and code only. Tried selecting countries as parent and deselecting it. But facing the same error. Kindly help. Sneha
Integrating Securely: Using the Anaplan REST API with Certificate-Based Authentication
In the ever-evolving landscape of technology, secure communication between platforms is paramount. The Anaplan REST API offers a robust way to connect and interact with the Anaplan platform, and one of the most secure methods of authentication is through certificate-based authentication. In this article, we'll delve into…
How to deal with 3 dimensions having many to many relationship?
I am having some trouble connecting dimensions because I have a relationship with many-to-many and therefore I can not use LOOKUP as I am used to. I feel like I had some trouble explaining the problem before so I will use some screenshots. I have a model for a book retailer, and my final goal is to determine the…
incremental synchronization
Is there any way to implement incremental synchronization of data loads? which will only synchronizes the data in the application that has changed since the last sync from the data source?
sample code for rest API
Hi all, Is there anyone who can share a sample file with code to use for REST API. We would like to setup a data integration between SAP and Anaplan using REST APIs, but it is hard to get started without sample file. Thank you!
Efficient Data Exchange: Integrating Anaplan with SFTP Servers
In the dynamic landscape of modern business, data integration plays a pivotal role in decision-making processes. Many enterprises rely on Anaplan as a comprehensive planning and performance management platform. When it comes to data exchange, integrating Anaplan with SFTP (Secure File Transfer Protocol) servers offers a…
Character restriction on Code Import
Hi Team, Recently we encountered an issue where we were importing data to a list, where unique identifier was to be added to the code and we find few records saying as invalid code. Example: any unique identifier with underscore "_" was at the start or the end was giving error of being invalid code. Can we have these as…
Level 2 1.7.3.2 Import into SYS08 SKU Details module
Hi Folks, I am facing error in Distribution center Mapping. attached is my model view. Please guide .
Have CloudWorks support DCA
I would like to see CloudWorks support Dynamic Cell Access. Our organization has a model-to-model import process that would not run correctly in CloudWorks due to the source module having DCA.
How to get Export output in json format?
Hi all, I am running a download API in logic app to get a list of my exports, i am able to get the result, but its in octet-stream format while i want the data to be in JSON format so that i can create a blob file with it. Any ideas how i can achieve this, also the Apiary links says that my result will be in JSON format…
Loading file with different file names for the same action in deployed model
Hi All, I am trying to run the action through Anaplan Connect with different files in deployed model. But the action is running only for the file that matches with the source label of that action and if I use the different file name scripting is failing. Attaching the screenshots for reference. Screenshot1:File name same…
Issue on Importing a File
Hi Community, I would like to ask this issue. I have never encountered this before so I hope you can provide me some insight. For example: This is the view of the file I am going to Import ini Excel mode(just a sample). I do the usual Save as "CSV format". I open the CSV format and everything is fine. I proceeded in…
How to use the RANK function
Hi everyone. I would like to use RANK function and extract only the data for the most recent date. However, the module have over 10 million cells. RANK function cannot be used... What should I do now? The following error message is displayed. Best regards.
Viewing Incoming API CSV Files on Anaplan Server
Hi Anaplan Community! My colleague and I are currently working on a new API connection between EDW and their Anaplan Data Hub. We are currently having difficulty loading all files through the connection. We have reviewed the queries and scripting for sending over the CSV files and cannot find any errors. We also are…
How to get File IDs for a specific process and then download Via Azure Logic App.
I am trying to run couple of exports in a single process through Anaplan APIs, the challenge is I want only the file IDs for the process which i am running, but if i run the get file ID API, i get all the files within the model, so is there any API which will let me take only the files which are under the process? or is…
Help - Stuck on 1.5.6.1 Create Historic Volumes Module
I am still having trouble with 1.5.6.1 in L2, Sprint 1. It says "DAT03 Historic Volumes Invalid Line Item Identifier." I have attached screenshots of how I have mapped things - can someone please help? Thank you.

Data Integration

Discussion List