Data Integration

Application of Filter Condition on Tabular Multiple Column Export
Hi Team, We see a challenge in not getting the Cost Center dimension when filtered to the saved view, it is not getting exported as per the Named Saved views instead we get all the Cost centers as default to the module. This feature is required for us to have it in the Tabular Multiple Column Export for the Integration…
Export from Anaplan to cloud using bulk API
Is it possible to export the files from Anaplan to the cloud other than Azure, Google and AWS? I believe by using Cloud Works API we can export only to Azure, Google and AWS. My client's requirement here is not to use the on premise server for the exports from Anaplan. Primarily they have no on -premise server in their…
L2 Sprint 2 2.3.9.1 Import data into DAT03 Historic Volumes module
H All, What happens in this case. I already pulled DATA from DATA HUB model in to Supply chain model DAT03 Historic Volumes module manually. What happens if I run the process 9 9.1 Import Historic Volumes9.2 Import Opening Stock9.3 Import Shipping Metrics Will I receive any errors in DATA in supply chain. Or The earlier…
Allow option to display status of a running Process/Action via Cloudworks
We are able to trigger a cloudworks job via UX page but there is no way to show the status of the job if its running or finished on the page. This information is vital to inform users so they are aware process if finished and if they are able to continue working.
Extend CloudWorks to support *External tables* in Google BigQuery
CloudWorks currently integrates with Google BigQuery and supports the following table types: Standard BigQuery tables, and Views. It would be useful if this support could be extended to include External tables (where the data is stored outside of Google BigQuery). At the moment I need to create an intermediate table in…
Schedule automated Anaplan notifications
As a Page Builder/Integration Administrator, I'd like to be able to schedule Anaplan native UX notifications. This would allow me to send native (instead of email) notifications to a set of users (hard-coded or lineitem-driven) about a predefined page. I'd like to be able to have different scheduling options, each being at…
CloudWorks Handshake
Hi, I would like to ask if CloudWorks is able to furnish a handshake mechanism once it picks up a file from an AWS S3 folder? For instance if CloudWorks runs an import into Anaplan, it picks File A from Folder 1 and imports it into Anaplan. How can it provide a handshake that the import has been run? Because the…
Bulk Copy On Items Within Modules and Bulk Copy Actions On Dashboards
Hi Anaplan, Currently the ability to 'Bulk Copy' of data only exists a list items data to be copied to another list item across the entire model. My idea is to have the ability to 'Bulk Copy' but only within a module from a list item to another list item within that model. Meaning that the data being copied only happens…
CloudWorks
Have you been wondering about Anaplan CloudWorks™ and how it can help you? Anaplan Academy is pleased to announce a course that will answer all your questions. CloudWorks provides an integration framework that uses an agile approach to integrate data directly into the Anaplan platform. In this course, you’ll learn how to…
"Line Item identifier(s) were not mapped and ignored" during data import
Hello! I am running an import from saved view into a model and I am facing this notification - it is not an error, but at the same time nothing gets imported because of it. Weird thing that this line item was indeed mapped and it was mapped automatically. Any idea what could be wrong here? Thank you!
Community Perspective: Using OAUTH2 to develop custom Anaplan connector for Azure
Introduction The release of OAUTH2 authentication for the Anaplan API opens the door to developing more native connectors across all the major cloud platforms. In this article, I explain how you can configure a custom connector on Azure for use in Logic Apps. The benefit of a custom connector is that you can expose all the…
HTTP Error 422
I had an import which loads salesforce data into Anaplan using the RestAPI fail today with the 422 error code below: { "status": { "code": 422, "message": "Unprocessable Entity" }, "path": "/2/0/workspaces/8a81b08e5cdbe172015cfb45189104ca/models/43955D63B8BD4E3FA3EA72776BE2CC41/files/113000000080", "timestamp":…
Calendar in the NUX Pages
Hi, Is it possible to put a calendar wherein I can choose the specific month or date in the New UX pages? if possible, how? Thank you!
Automating Cloud to Predictive Insights Integration
Introduction The following document describes the steps needed to automate integration between cloud data sources and Predictive Insights using CloudWorks. In the document, we will use Amazon S3 integration as an example, but other cloud data sources are also supported. For simplicity, account data will be referred to, but…
Managing Anaplan ALM with API using Postman Tool
Hello Team, While am trying to retrieve syncable revision tag from the source model, am facing issue of whose screenshot i have attached below, Reference : I have cross verified the ALM between source and target and also i have verified the Model whether its defined correctly in the environment variable and also checked…
Controlling ALM using Anaplan Connect
Hello Team, Is there any batch script/Anaplan Connect script where we can automate the revision Tag Sync of Datahub with Multiple Production Models ?
Is there a way to integrate mailto function?
Hi, I would like to integrate MAILTO function so that it automatically sends email to dynamic users based on selections done at the backend. Thanks
2.3.8.2 Import into DEM01 Module
Hi everyone, I am trying to do the import into de DEM01 Module, but I keep getting this error. I've seen some similar questions here at the Community but can't really figure it out what everybody did to correct it. I am attaching some screenshots so you can see what I am doing. I really don't know what else I can do. Any…
[Part 2] Script example: Leveraging the SCIM API to bulk remove users
* Prerequisites * Getting started * High level process * Recommended usage * Script walkthrough * Section 1: Libraries * Section 2: Logging configuration * Section 3: SCIM API configuration * Section 4: Authentication * Section 5: Parse CSV file containing Users * Section 6: Call the SCIM to perform the selected operations…
Anaplan Add-On for Google Sheets Not Working
The Add-On for Google Sheets will not open and allow us to connect from large workbooks. It only seems to work with smaller/single sheets. Has anyone else experienced this? Is this a limitation of the add-on?
Where is the data coming from?
There is an error in the data in the spoke so I looked and the the spoke indicates that the mapping came from this module in the Data Hub. However, the data isn't flowing through in the Data Hub but is coming through in the Spoke. Is there anywhere else I can look? I've tried pivoting the view but no data pulls through at…
Bulk API Integration
Hi All, If I upload a file to Anaplan server using Bulk API, can a user manually run the import action from actions page in Anaplan to import the uploaded file into the Anaplan Model, are there any limitations or pre-requisite? For example I understand if I am uploading the file using basic authentication with a user ID…
RESTful API - Postman examples
I have attached a json file for to be imported into the POSTMAN application. These are example calls to Anaplan's API. Please note that most of the API calls were using certificates. The URL to get POSTMAN is here: https://www.getpostman.com/
Building a Chat Bot - Part 3: Interacting with Anaplan from Slack
Since you’ve reached this point, I believe it is useful to remind you what we achieved so far. In both Part 1 for AWS and Part 1 for GCP, we used both platforms in order to host a function that can generate a new token every time that you need one. This could be very helpful in any integration scenario that you can come up…
Use columnar file formats with cloudworks
WIth the ability to connect cloud storage to anaplan with cloudworks, it would be great to be able to use columnar file formats (like parquet or orc). Parquet format is considered a better file format for analytical workloads as large sets of data can be read faster than with row files format (.csv, .txt, .tsv..). As these…
Question for Level 1 Activity 4.8.2: Import Data into E2 Employees# List
Hello there, I have one question regarding the activity 4.8.2 in level 1 where I imported the data successfully but employees of departments all shows up like numbers (please refer to why number.PNG). As you can see from the screenshots enclosed, the mapping was correctly done before importing (refer to Import set up.PNG)…
Management Reporting slides download for multiple page selector at once
Currently we can download slides for each page selector by one by one .It would be great if we can download one slide for all item in page selectors at one click . Scenario - In page selector , we have 100 employees Data in slide changes according to page selector (using dynamic text ) .Customer wants to export slide for…
[Post Work] Join the Conversation: Unleashing the Power of Anaplan Integration
Hey there, fellow Anaplan integration enthusiasts! After attending the Anaplan Community Event (ACE) OEG training in San Diego on June 5th, we invite you to be part of an exciting discussion that holds immense potential for your organization's growth and success. We want to hear your thoughts on how learning about the…
Export data from Anaplan to SQL server through Anaplan Connect script
Hi Anaplan Connect experts, I need some help. I know how to write a Anaplan script to load data from SQL Server to Anaplan module. I need sample script from you, how to export data from Anaplan to SQL server. Could you share me your sample script please? Thank you & regards, Anil
Ability to copy/paste values incl. hidden decimals from Excel
When copy/pasting values from an Excel table to Anaplan, it only includes the decimals shown in Excel. E.g. if the value 0.5499 is in Excel but the cell in Excel is set to only show one decimal place, the value displayed will be 0.5. When copy/pasting to Anaplan, 0.5 will be used and not the full 0.5499. This issue can of…

Data Integration

Discussion List