Data Integration

Anaplan Partners for FP&A
Hey there, Has anyone implemented Financial Planning & Analysis in Anaplan for an organization without an Anaplan partner or a light one? If so, how was your experience? Thanks! Andrew
Clear the Target for a Module Import
Hello everyone: Anaplan provides a lot of flexibility in regards to clearing data prior to imports. You can read about all the available options here. In particular, I am referring to: * Clearing the Target for Time * Clearing the Target for Dimensions other than Time I have always used the default settings such as Clear…
Excel Add-in: Clone Workbook button
Currently on the Excel Add-in I am able to clone worksheets. I would like to have the ability to clone an entire workbook or multiple copies of a single sheet rather than doing this 1 sheet at a time. Why? * Currently the Excel Add-in does not allow for copied workbooks to be opened simultaneously * This will facilitate…
CloudWorks—This is how we use it, Part 3: The CloudWorks API
In Part 3 of our CloudWorks - This is how we use it series, we will introduce you to the CloudWorks API. This is typically for an audience comfortable with REST APIs concepts and programming. If you need a refresher on What CloudWorks is, see Part 1 or, for how to set it up, see Part 2. CloudWorks API will allow you to…
Error in Uploading Screenshot for Anaplan ADO Maps.
Hi All, Facing an issue while uploading the screenshot as it is showing "error while uploading the file". Is it only for me or is anyone else facing the same. Can anyone help in resolving this at earliest? Attaching the screenshot of the error below. Thanks,
Issue: Informatica Cloud Connection to Anaplan Success but 0 rows processed.
Hi Anaplanners, I am trying to use IICS to establish a connection between my oracle db to Anaplan module. But everytime I test my IICS process, it's giving me a success status but showing 0 rows processed, and when I check the module, nothing was imported in. I also tested my action manually and it worked fine. I also…
Error : Evaluating the forecast in Hold Periods ～ Statistic forecast
I'm trying to evaluate the statistical forecast by using Apply Hold Periods. But when I set them, the almost of product's best-fit forecast is set to New Item Forecast. How can I correctly evaluate the forecast?
Import 2 number list with identic Parent and Code
Hello, In Model 1: I have 2 Number List: Payer Sold to, with parent Payer Every line in organization, also exist in Sold to list. As example: Name: Parent: Code: Aushan _______ 12 - Payer Aushan Aushan 12 - Sold to Aushan Aushan 15 - Sold to In Model 2: I have 2 Number List, as well: Payer Sold to, with parent Payer I copy…
Can a parent numbered list and child numbered list have the same code?
Hi All, I have a parent hierarchy in numbered list.Both are uniquely identified by code. Parent List : Program Child List : Project So When I am importing into child list(Project), it is ignoring some of the records. After the analysis, I found that the records that are being ignored have their codes already present in…
Stop a process in CloudWorks
I kindly ask to add a "stop" option in CloudWorks Integrations Menu, because I have a process which is stuck and I need to spent a lot of time to delete and re-create it every time a process doesn't work. Thanks in advance!
BULK COPY - How to choose the SOURCE member and the TARGET member from a page in the app?
Hello Anaplan Community! Does anyone know how to choose the SOURCE member and the TARGET member from a page in the app? Thanks in advance. #NewFeature #UX #Dashboards #BulkCopy #Data #AnaplanRelease
Create Shipping Export Module and Create a Saved View
In Level 2 Model Building : Conclusion, there's an 'Activity: Prepare Data Exports' that tell us to Create Shipping Export Module and Create a Saved View. I've made the formula and choose the format and summary method but I'm not sure if it was right. Here is the blueprint of my INV05 And here is the screenshot of the…
What is Managed By functionality?
Stale Module Data in Power BI
I've successfully built out a Power BI semantic model that appears to connect to Anaplan just fine. When I created the model, I logged into the Anaplan Connector using my company SSO. Once the credentials were validated, I selected the Export Action that I had previously created and loaded the data. Initially, all data…
1.7.3.1 Import into P3 SKU list
I am having trouble importing the data from the Build SKU saved view. When selecting my sources for the data, I don't have many options to link the properties to the sources. Is there something I am missing?
Why does ADO Map show undefined under each chart?
Hi All, I am testing ADO functionalities and noticed in my map that it shows undefined for the charts although all my data flow and links are connected and working as expected? Is there anything that needs to be done further to remove this?
Integration via Amazon S3
Hi, I created a connection via Amazon S3 without any problem, the status is "Connected", but I don't manage to select a file when I try to create the integration : Thank you in advance for your help. Best Regards Alex
Error in key for this row; refers to invalid list item
Hi everyone, " Error in key for this row; refers to invalid list item : Headcount " I get the above error when I tried to import data into Numbered List, which is uniquely identified by combination of properties. Actually, the list item which is formatted by some "xyz" list has list item ' Headcount' Even after that, I am…
JSON as Import File Format
With the JSON format being the pervasive format for API data interchange it would be excellent if Data Import actions could use this format of file as a data source.
Does having multiple models in a single workspace (standard or hypermodel) affects performance?
Hi All, I have a query where currently we have 3 models in 3 different workspaces(standard). In all the 3 models we have intergrations running at different times(5-6 times a day for each model) to update Actuals/Forecast from other sources. We are looking into getting a hypermodel workspace for future enhancements &…
Enhancement to existing Bulk API for Import Metadata
There is an existing bulk API endpoint that allows workspace admins to retrieve the full list of Import actions from a given model. This endpoint is in the format: https://api.anaplan.com/2/0/models/{{mdlID}}/imports/ where {{mdlID}} is the model GUID. This returns a JSON response, which contains an object called "imports"…
Import Shipping Expenses into OTH01 Module
Import Shipping Expenses into OTH01 Module In the Financial Planning & Analysis model: Import the data from the Supply Chain model into the OTH01 Non Employee Expenses module, Shipping Cost line item. * For department, import into the Sales department. * Run the import. * Results should have none ignored and 0 errors .…
Level 3 Sprint 1 Import
Its regarding Level 3: Sprint 1 : User Story says " Import the Financial Forecast data from the Level 1 FP&A model" I have used the "Baseline+Financial+Forecast.csv" file. I am struggling with the import mapping "Time" and "Baseline Financial Forecast" portion. I keep getting failed errors regarding date format…
ADO Access
Hi Everyone, Can anyone will help me how can i get the access for Anaplan Data Orchestrator(ADO). Regards Rakesh ****
Ability to mask or sanitize all of the Production Data within a model
I would like to be able to easily mask all Production Data within a model. Currently, this involves a lot of manual effort. For example, replacing all names with fake names, and all numbers with fake numbers. Being able to do this is useful for a couple of different purposes: * If I need to have Anaplan Support take a copy…
Use Microsoft EntraID for Azure Blobs
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: Use Microsoft EntraID to connect to Anaplan and use this EntraID to connect to an Azure Blob, instead of using a SAS token. Our…
How to integrate Azure blob and Anaplan For transferring files
Is there way to connect azure blob and Anaplan to upload/import data can it done by rest api call or can i use custom script to call Anaplan connect import hub from azure??
Anaplan to SAP journal posting
Hi All, I am working on automating journals from Anaplan into SAP via SAP BTP/API. The API is linking to saved exports with a saved view. Journal data updates on a monthly basis but the changes in data don't get picked up by the API and instead old data gets posted into SAP. Has anyone encountered this before? Is there…
August 2021 Release and Sneak Peek at September
August 2021 Release and Sneak Peek at September Bulk Open from Table of Contents: From the Table of Contents section of New Modelling Experience (NMX) you can quickly open the objects of a particular functional area for faster access to the information that you may need. It leads to increase in productivity. Tab…
How to Automate and Retrieve Authorization Code in Anaplan OAuth API Automation using Python
Hi, I'm facing an issue with the Anaplan API integration. Currently, the authorization code retrieved manually, but we are looking for a way to automate this process as part of our integration workflow. Thanks

Upcoming Events

Anaplan Academy Open Office Hours [APAC]
Join us for Anaplan Academy Open Office Hours—an open, interactive space designed to support your learning journey. Whether you’re just getting started with Anaplan training, working through course content, or preparing for certification exams, this session is your chance to get direct answers to your questions. Our…
Anaplan Academy Open Office Hours [AMER]
Join us for Anaplan Academy Open Office Hours, an open, interactive space designed to support your learning journey. Whether you’re just getting started with Anaplan training, working through course content, or preparing for certification exams, this session is your chance to get direct answers to your questions. Our…
Anaplan Academy Open Office Hours
Join us for Anaplan Academy Open Office Hours, an open, interactive space designed to support your learning journey. Whether you’re just getting started with Anaplan training, working through course content, or preparing for certification exams, this session is your chance to get direct answers to your questions. Our…
Save the Date: Anaplan Workflow - Next Steps in 2026
We’re continuing the conversation! Following the success of our first Anaplan Workflow event, we’re bringing you a deeper look at what’s next. Join us in February as we expand on the insights shared in the previous session and explore how Workflow continues to evolve to support planning collaboration and process…

Data Integration

Discussion List