Data Integration

Use ChatGPT's API to produce commentary and send it back into Anaplan
I've love to see some more native API's to connect Anaplan into ChatGPT API to be able to generate commentary. This would be an application similar to CloudWorks or PlanIQ that allows you to configure certain fields to be selected and then a certain style or questions can be asked to ChatGPT to produce the commentary based…
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…
1.5.6.2 Import Data into Historic Volumes Module
Hi All, Please find attached the screenshots of the mapping I have done for the import process. But I am facing the error - Manual mapping is unavailable when number of items exceeds 5000. Because this I am unable to perform the mapping of line item "Volume". I have used the file provided in the activity…
VBA/macros for Excel Add-In
As a model builder I would like VBA and macros to be supported in the Excel Add-In so that I could further automate workbooks. For example : 1) I would like to be able to create VBA code and macros for the various Anaplan actions so that I could automate a number of tasks (eg Login and refresh data) through macros 2) I…
Metadata
Can someone explain what exactly is metadata, and what is the role of metadata in the datahub and how it is better to calculate the metadata in the datahub itself rather than importing it to other spoke models?
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…
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…

Data Integration

Discussion List