Data Integration

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.
Add "includeDetails" parameter to "Retrieve lists" API Endpoint
Currently "Retrieve lists" Endpoint returns only an array of lists which contain only "id" and "name" information. [ { "id": "101000000000", "name": "Organization" }, { "id": "101000000001", "name": "opportunities" }, ] For my use case, I need to find out which lists have Selective Access. There are two ways to do that:…
Issue while Importing Dates in week format
Hi All, I am trying to import data into my module however, i am not able to map the date format with the modules timescale, the date is in "Week 1 FY19" format and i am not sure which time scale format will be suitable for the same. Thanks.
Remove Line Item Mapping when Item is Removed from Import Data Source
Within the Line Items tab of the import dialogue, please can line item sources be removed when these are removed from the import data source. Take the below as an example: If I were to remove Revenue from the import data source, the Revenue line item source would still appear on the left to be mapped to a line item target.…
Level 1 Model Building Exam - Model Building Activity 4
Hi, can anyone help me to figure out what's causing the error for importing the data into EMPO3 Employee Drivers by Role and Employee+Drivers+by+Role module? 1.1) If I load the original downloaded file of "Role List", it's showing the following error. 1.2) So I deleted the Parent column to load it as below. 2.1) After the…
UX create page as a hyperlink
Hi, As a page builder I would like to add a link to external sources as a page, the way user can use native Anaplan navigation pane and click on the link to external source instead of going into the page directly. This would be useful in cases when Anaplan is integrated with external systems for reporting giving the sense…
Unit Testing is for finding bugs, not show correctness
Architect, Builders; Having worked projects with hundreds of bugs, the natural question is how did this happen? The solution passes User Acceptance Testing means that it was adequately tested. This could be a paradigm shift for some in thinking about unit testing. Doing a quality job of it adds time to get a solution to…
Update Formula's Automatically
Hi All, Is there anyway by which formula's can be directly imported in a module for a line item? The blueprint view import option does allow to import a new line with a parent and a code from a file or any other module but is there anyway that the formula's also get updated automatically from another module or a csv file?…
File Download API using name instead of ID
Hi Everyone, I have an Anaplan ←→Azure integration pipeline where Azure Data Factory pulls some data using an export action via Anaplan APIs. We were using the name instead of the id when we run the download API. However, today observed that it no longer works. Getting a 404 Not Found. { "status": { "code": 404,…
Regex Formula
It would be very helpful to include a regex style formula in Anaplan so we can pre-process text fields ahead of an integration, or even help to cleanse messy inbound text. Currently if we want to remove special characters, or parse strings into cleaner formats we have to specify one by one the characters we wish to remove…
Automating Salesforce to Predictive Insights Integration
Introduction Please note: the Salesforce connector for CloudWorks is currently in beta The following document describes the steps needed to automate integration between Salesforce and Predictive Insights. The overall flow described by this document can be depicted like this: This flow will: Load a list of accounts and…

Data Integration

Discussion List