Data Integration

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…
Workaround for Access issue with Cloudworks?
Hello everyone, I am currently struggling with CloudWorks integration and I would like to ask if anybody in the Community have faced similar issue before. The setup: We have few modules which have DCA enabled in them - both Read and Write This Read and Write DCA is based off another modules where you basically set up…
Event Registration - API Developer Virtual Meetup
Hi All Our first event for 2023 is right around the corner! Agenda: Welcome and Intro Update from the Anaplan team Demo Q&A Event times: AMER/EMEA: 25th July 09:00-10:00 (PDT) APAC/EMEA: 26th July 13:00-14:00 (SGT) We will record the sessions for those who cannot make the times listed Registration Steps: Register here ⇒…
AnaplanClient.bat is not recognized as internal or external command, operable program or batch file
Hi Team, Could you please, assist with this problem? @echo off rem example. Set AnaplanUser="example@example.com:password" set WorkspaceId="*****************" set ModelId="*****************" set Operation=-via http://example.net:10085 -export "Export_action.xls" -execute -get "D:\output.xls" rem *** End of settings - Do…
3.5.4.1 Level 2 Sprint 3 Supplied By
There is no supplied by in the original data imported into the original models.
CloudWorks scheduled status types
What are the different status definitions for a CloudWorks scheduled process?
Populating list subset based on a Boolean from a specific version of a module
All, I need to update my hierarchical list subset from a module with versions. I have a module dimensioned with my list and a saved view in forecast version with a Boolean formatted line item (already populated and true for several items) based on which I need to update my list subset using action but I couldn't find my…
ALM setup DEV to Test to Prod
Hi Guys How do i setup ALM so that it only works From DEV -- > Test and then only Test --- > Prod Currently i have DEV TEST In deployed mode synced with DEV NO PROD PS:- I know this is against the best practice as we should do DEV --- > Test and DEV ----> Prod but trust me client only want above . Thanks
Anaplan export action list via POSTMAN
Hi All, I have this issue on not being able to get the list of Anaplan export actions or any other artifacts via POSTMAN. These are the steps I am taking - a. Authenticate — https://auth.anaplan.com/token/authenticate (I using basic auth and I am able to authenticate, and I am able to get the tokenValue. b. Model list -…
How to upload file in postman while running a collection
Hi Team, I am trying to import a csv file into Anaplan through API in Postman. When I am running individual requests and upload file in body(binary), it gets uploaded into Anaplan but while running the collection all together and putting file into collection runner, it is throwing error "500 Internal Server Error".…
Integration to a non jdbc driver data provider
Hello all, Can someone let me know different/efficient way to connect a data source for automation syncing data which doesn't have jdbc driver in it.
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…

Data Integration

Discussion List