Data Integration

Can't add new CloudWorks Connection
I'm working with a new client, and I can see CloudWorks, but whenever I click the drop-down menu to connect to a service, it appears empty. I assumed it wasn't a permissions thing because I can access the UI. Anyone seen this before/
Import Final Demand Forecast into DAT02 Module
Good Morning, While doing this activity in the Conclusion course, I got stuck Indeed, they are asking us to Import the Demand data into the DATA02 SKU Volumes module. But in the Level 1 model, there is not a module called data2. So do we have to create this module? If yes which line item, what to put as page selector, rows…
OEG Best Practice: Governance for the Office add-Ins
General information * We have listed below some of the best practices we recommend for the Anaplan product. These are based on our experience and are subject to change as we deliver new functionalities and learn more about how our customers use the product. * If you would like to contribute or comment, please contribute to…
Level 2 - Conclusion: Export data from INV01
I am currently working on the Conclusion for Level 2. When preparing the export saved view for INV01 Beginning Inventory, I noticed I have significantly different numbers in my module as compared to the example .csv and the screenshot from the course. I am wondering if there is something obvious I am missing, or if I need…
Invalid Parent when Importing into List
Hi! I have this list called Strategic Customer. I have a module based off this list called Strategic Customer Details. the parent hierarchy of this list is Strategic Account Owners. In the module, I have a line item to choose a different Strategic Account Owner for a Strategic Customer. The choose new SAM line item is…
CloudWorks Enhancements
In as much detail as possible, describe the problem or experience related to your idea. Please provide the context of what you were trying to do and include specific examples or workarounds: Can we add few more functionalities to CloudWorks like ability to Rearrange the columns, ability to reorder Integrations…
Random number generator
Is there a way to generate random numbers from a defined range of numbers so that the numbers being changed regularly in a module every time we refresh the model or just run an action?
404 error when using API imports endpoint
Hi! When I try to use the imports endpoint I only get a 404 not found error. The api documentation I have been following is I first noticed the issue when running this: https://github.com/qkeddy/anaplan-audit-history so I tried with Postman and I got the same error message. If I run a GET to the specific model or workspace…
Integration - Constraints on Data Volumes/Frequencies
Are there materials regarding constraints around data volumes and load frequencies for the various Anaplan Integration options? Any user feedback or limitations that you have seen? Thank you
4.6.6 Activity: Import Data into P1 Product Family List
What is the source P1 Product family, Parent and Code in 4.6.6 Activity: Import Data into P1 Product Family List and how it is mapped. Please help with the information.
Add API Endpoints for exporting History, Users and Roles from the model
Hello! There are many opportunities in Anaplan API, but still there are possibilities for development. Me and my team think that it would be very convenient to be able to export model history, users page and roles page (accesses to modules, versions, actions, etc.). I know that it is possible to create export actions with…
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…

Data Integration

Discussion List