Data Integration

Does Transactional APIs supports data query?
Hi, I'm new to the Anaplan platform and I'm working on Transactional APIs to consume data from a model and view. I'm using the API collection from the docs and the following endpoint to get data - {{int_v2_base_url}}/2/0/models/{{modelId}}/views/{{viewId}}/data?format=v1 I'm not able to find any examples online on how can…
Anaplan Informatica Hyperconnect
Hi Is Microsoft Azure Synapse SQL Connector for Informatica cloud available with Anaplan Hyperconnect?
Publish Subsidiary View to the Excel add-in
Our users are using the excel add-in to link to offline files for forecasting inputs. Currently, we cannot use a subsidiary view in the excel add-in, which is making it impossible to forecast a few items using subsidiary views through the add-in. Seems like this would be a useful enhancement. excel, add-in, subsidiary view
SAP integration
Suggest to build native integration with SAP solutions. A lot of Anaplan customers use SAP solutions such as SAP ECC, S/4 HANA, SAP BW etc. and heavily depend on large amounts of data flowing back and forth into Anaplan. Integrating with these solutions often require an extra layer such as AWS or similar which then again…
Import error (parent item has a child item that is in a different list)
Hi all, I'm getting the following error in one of my import: Import into Hub_0_Product_Group Marketing L8 # list failed: Parent item has a child item that is in a different list: You can only add a child to a parent item, if any existing children of that parent item belong to the same list. Do you have any tip/advice to…
7.2.3 Activity: Import Data into Employee Details Module error
Hi team, Missing out some step data while mapping, data was updated successfully attached screenshot (12error), however data is being uploaded with ignored values. Do I have to make any change in the module section? @noelle_murphy
Stop allowing copy and paste into dependant dropdowns
Hi, We have a field that is dependant and i have unticked 'Allow access to unfiltered items' However if you copy and paste a valid (non dependant) value into the field it allows it I have made it go red as a warning, but can it be stopped so you cannot paste into dependant dropdowns? thanks
Allow filtering of tabular multi column exports from transactional api
When defining tabular multi column (TABULAR_MULTI_COLUMN) exports from the UI, you're allowed to specify a boolean line item to filter the results. This functionality is not built out within the transactional API. The API documentation alludes to this option being the case, but it is not supported. Without this filter you…
Mapping timescale during import and ignoring some columns
Hi I would like to know how do I ignore several columns from the source CSV file while importing data , where the first columns contains list and apart from several columns I want to ignore, Column headers are mapped to time. Attaching screen shots for your reference. In the source file attached , the first column simply…
Inquiry Regarding Anaplan Integration Process and Schedule
I have created an 3 Integration Process and added it to the Integration Flow and Schedule using my ID. I have a couple of questions regarding this setup: If the update schedule is modified using a different ID, will the process continue to run under my name, or will it reflect the name associated with the new ID? In the…
Text format validation
I would like validation functionality for text formats in Anaplan. When entering names of products or items in Anaplan and importing them into external systems, import errors occur if the input contains strings that the external system cannot import. Having text input validation functionality in Anaplan would facilitate…
CloudWorks AWS S3 file list
It would be great if once you have input S3 access credentials and established the connection, CloudWorks would present you with a list of available files to choose from, instead of having to input the filename. Furthermore the ability to reselect the file to be imported by the connection will speed up integration admin a…
Can we export data from anaplan and directly load into other tool via Rest API?
Hi, Can we export data from anaplan and directly load into other tool via Rest API, without exporting csv or text file.
Clear an entire module
Scenario: If I am importing data into a module and a line item no longer exists in the source file, the Clear Before Import will not clear that line item as it will only clear line items that are coming in from the file. This can lead to numbers being off. Current workaround: Create a duplicate module that is filled with…
Cloud Works integration
I apologies in advance if this idea has already been posted🙂. In Cloud works if we delete any integration by mistake is there any solution or process for reverting it back again or to see what we have deleted and revert it back .
Import Scripts run successfully but target module did not update as expected
Hi, We're able to set up a scheduled import actions using Java scripts with certificate authentication and it appears to run successfully according to the import history, but the target module in ANAPLAN is not being updated as expected. It seems like it is still importing the old csv file instead of the new one. Also, we…
Cloudworks Integration Flows in UX
At the moment, we are able to add Cloudworks Processes to the dashboards and the addition is great. Could we do the same with the Integration Flows? I see multiple benefits from this for several customers and I do not think that the implementation would be too different from what is currently in there. Is this currently in…
export Anaplan data decimals precision to PowerBI
Hi Anaplan Community, I am trying to export data from Anaplan into Power BI using the Anaplan Connector. I manage to get my values into PBI, however, I miss the decimals precision which I see in Anaplan. Example: in Anaplan my number format is set to show 3 decimal places, so 594.450 (US notation), five hundred ninety four…
Set one column of source data as "Not Applicable" for this import
Dear Anaplan Community I am looking for a way to "ignore" one column of data from the source file as irrelevant when uploading its data into module. Source file contains columns as below. Column D is actually the code of Column C inside Anaplan model. And Column D is there because client wants visibility into expense type…
How to use OAuth authentication in Anaplan Informatica Connector?
Hi All, I am trying to test OAuth Authentication in IICS Anaplan Connector. Is there any documentation specific to the Anaplan Connector having steps for setting up the authentication available? I noticed we have documentations with steps for Anaplan Connect and API , but was not able to find any that involves Anaplan IICS…
Any Way to Switch a Cloudworks Integration from AUTO_DEACTIVATE
Is there any way to force a cloudworks integration to toggle back to ACTIVE from AUTO_DEACTIVATED? Context: We built a number of integrations and scheduled them to run on the weekend. If an integration is scheduled to run during the regular maintenance windows, eventually the integration in cloudworks will flip to…
API Authentication error bc of need to reset password
Hello, The IT team of a client has built a integration with the data base to Anaplan using the API. They have a problem of Authentication when Anaplan ask to reset the password, giving a 401 unauthorized, so they have to go to the Anaplan page and reset the password and make the changes on the integration. Is there any…
Is it possible to have an anaplan export automated having 2 dimensions in columns?
I am trying to create an automated export of a view that has time, as well as line items in columns. I have tried this via Cloudworks and Informatica but it is not working. When I am manually running an export in anaplan its working fine but not via integration.
Level 1 Exam - Model Building Activity 4 importing data into SYS08 Employee Details Module
Hi Team, I need your help on this data importing. I have downloaded the Employe Details by Role.txt file but, I see the data is not being mapped correctly into the SYS08 Employee details module. Downloaded CSV format : I have tried by converting CSV to txt format. Still the data is not being mapped properly while…
How I Built It: Data Hub basics
Author: Josh Baker, Certified Master Anaplanner and Senior Vice President at PJT Partners. Hi Anaplan Community! I’m excited to share my new ‘How I Built It’ video on Data Hub basics, including setup, automation, and model to model data/attribute loads. For some background: The demo utilizes comma separated files…
Navigating data integration challenges in Anaplan: strategies and solutions
Author: Shivankur Sharma is a Certified Master Anaplanner and assistant manager in the consulting industry. In today's data-driven business landscape, organizations rely on robust tools and platforms to streamline their financial planning and analysis (FP&A) processes. Anaplan, with its versatile capabilities, has emerged…
Anaplan Data - Real Time Access
Hi All, We are trying to access Anaplan Module level data using Python. I just wanted to access Anaplan data (Module Level Data) in real time by using Python or Java without getting data from Anaplan with flat file. Also wanted to establish Connectivity between python & Anaplan in the real time. So we can get updated data…
Experiencing Occasional 'Basic Authentication Failed' errors under SSO
We recently switched majority of our workspaces over from Basic Authentication to SSO for security. To populate our models with data that is rapidly changing we push data through our internal data store through an ETL (Workiva formerly known as OneCloud) hourly sometimes more often than that. There is a dedicated service…
Better solution for a nested IF... but I can't think of one
I am working through many many modules and removing 'bad' data or process and have come across a nested If formula, and cannot think of a better way to replace it. Have a module with 2 sources MATERIAL and LABEL TYPE. Within the material list we have several labels (FRONT, REAR, DECAL + 6 others) In the module i need to…
Anaplan API 2.0 Python Library - [Updated March 2022]
* Getting Started * Gathering the Necessary Information * Authentication * Getting Anaplan Resource Information * Uploads * Executing Actions * Downloading a File * Get Available Workspaces and Models * Example Code After a significant amount of refactoring, I'm very pleased to announce the latest release of my Python…

Data Integration

Discussion List