Data Integration

Snapshotting Issue - Formula Summary for Time Periods
Hello! We are doing snapshots for some key metrics, and I'm facing an issue where a few of the source line items are %ages with a Formula summary for Time period. When these are being imported into the snapshot modules, the quarter value is being messed up because that can't have a Formula summary. I figured I could create…
Boomi + Anaplan Integration
Hi, I'm building the integration between the Anaplan and DB using Dell Boomi. Is anyone has any sample flow? how it need to be built? Thanks, BS
Importing data from .csv files
Can you please explain how should I import the .csv File at the mapping stage? How do i know what options to select under the SOURCE dropdown? what logic it uses so that the data can be displayed as desired in the model. I am trying to import the subset file however it is a bit confusing as to what i should select in…
Excel Extract in mail attachment
Hi, I want to attach Saved view as a mail attachment and send it to clients. We dont want to show other module data to them so excel add-in doesn't work. So do we have any solution for that. Regards, Ajinkya S
Excel Add In: remove a connection and multiple connections in one sheet
Idea 1: Currently we have the option to create Read / Read-Write Connection. But when I no longer want an active connection on a sheet, i am not able to remove it. This limits my ability to add a new connection or replace connection on the same sheet. Idea 2: Also, we cannot have more than one connection on a single sheet.…
Excel and Powerpoint add-ins for Office Online
As well as the existing Excel and Powerpoint add-ins for on premise/desktop versions of Office it would be good to have similar integrations available with Office Online which deliver the same functionality.
Excel Add-in: Add Compatibility for Apple Mac computers
Add Compatibility for Apple Mac computers. The Excel add-in for Excel only works on Windows PC's right now. Our parent company only uses Mac computers so they cannot fully utilize my reports that use the Excel add-in.
Can't upload a new import data source for part of actions
When I tried to upload a new import data source file(.cvs file) for a action, I find it is void, no any error message, It looks like everything is working, but when I want to edit the action after upload new source file, still prompt "The uploaded file is no longer available; please upload the file again". And I found it…
Understanding Errors and Rejected Lines When Importing Data Via APIs
The objective of this article is to provide a quick explanation on the responses that APIs can provide when an import is submitted, in particular regarding the dump logs generated. This content is suitable for Model Builders comfortable with APIs. * When Does an Import Create a Dump File? * Import in a Module * ‘Failed’…
Level 2 sprint 3 activity 3.3.4 TRA01
I have been trying to figure out the formulas in this activity, I know that YEARVALUE function would be used with LOOKUP function. I am not able to figure out so as to what the mapping dimensions should be for LOOKUP as P3 SKU and G3 Locations are not lists. These are only dimensions I can think of as of now. Please guide…
API scripting manners
Hi, I got this question from our partner consultant. Any advice would be appreciated. Thanks! Anaplan Connect is provided as a Java JAR, but I think it is actually provided as a sample that executes Java from a shell script or bat file. The customer already has an infrastructure that can run Java directly as an…
Data01 P&L Actual and Budget
I had a question about importing data into the Data01 P&L Actual and Budget module. Whenever I imported data into this module, for some reason, only half the data gets imported. I never see the budget section under this module after importing data, only actual and forecast. Can someone please tell me how to import the data…
Data not showing on Field
Hi All, I developed dynamic budget comparison report. Based on the selected Version, and Versions Settings module my budget comparison module is populated. Since line items in the report are generic like PY Budget, Budget+1, Budget +2, on additional insights panel I want to display for example FY23, FY24 etc.…
How to use batch file process ~ statistic forecast
In statistic model, there are some instructions and power point file. -Daily Batch Process for Demand Forecasting In this document, I can see there are some Batch Process or import actions. But there is no Actions in the Statistic forecast model. How can I run the Batch Process?
Anaplan Connect import error 12476
Hi, I am currently having issues with my script using Anaplan connect and I hope someone could help me with this. The error I receive is: “ERROR 12476 |-- Imports not found: Imports not found for Model-ID=8954E749858F4CEEB35EBD5BFB54595B (Feign: status 401 reading AnaplanAPI#getImports(String,String,int);…
Sprint 1 : Import flat list for country
Hello, The csv file contains country name, code and parent, but needs to be imported as a flat list. A) There is no way we can leave the fields blank while importing as it is throwing errors B) Can i make changes in the source file itself to just get the countries? We do not want the parental hierarchy c) I have just…
Referencing models in another workspace in real time
Can a calculation referencing a line item from a model in a different workspace be accomplished in real-time? Or will it require other forms of interfacing?
Use CloudWorks to solve CurrentDate/CurrentTimestamp in Anaplan WITHOUT using third-party tools
As Solution Architect / Model builder, I would like to be able to create a "connection" in CloudWorks Anaplan using a webservice managed by Anaplan which automatically updates in the backend a file that contains the periodically updated CurrentTimestamp in UTC (something like "2021-02-01T14:10:45"). I will know this will…
refactor the action info tab/API to allow for flows monitoring
For large usage of Anaplan (multiple data hubs and models), it is important to monitor the flows between models. Anaplan is the ideal tool for that but currently many of the necessary info is not readily available. The first and foremost thing to do is to set the API so that the imports endpoind of a model actually gives…
Cloudworks set-up page slow?
I played today the first time with Cloudworks and had to experience a pretty bad performance of the set-up page (incl. 504 errors). It told me for example that it "successfully created the integration", but then took almost 5 minutes until it was visible. Going back to home and back into Clouworks just freezed the page for…
Allow importing items with the same name into different levels of a hierarchy
When importing items into a child list. If there is an item in that hierarchy which already has that name it will be ignored in the import. However if you create the list items manually, you can give items the same name at different levels of the hierarchy. It would be helpful to be able to flag certain items in list…
api v2 - POSTMAN examples
I am sorry for not posting these POSTMAN examples sooner. You can download the attached file and import them into your Postman. There are over 30 examples of different ways to hit the API. and this is for those users who are not using cURL. These range from Exports, Imports, uploading data, and reviewing dump files. I hope…
7.2.1 Lesson
I am seeing this error message and can't find the source of the issue. Any help would be appreciated. Thank you.
importing duplicate detail-data into Module.....
I want to import duplicate detail-data into Module..... When I imported, same departmentcode data which is second same data was rejected..... dimension（departmentcode） is Fixed and unchangeable, How can I do this?
Import values is not showing
The Data should like Pic-1 but after import I am getting as Pic-2. Though I followed all imports correctly, still data didn't show up. I have shows Imports for reference. Thanks Friends.
The Level of Statistical Product Forecast
I'm Trying a statistic forecast. And there is below statement in this site (https://community.anaplan.com/t5/Best-Practices/Statistical-Forecasting/ta-p/40359). * Multi-Level Forecast: Ability to forecast at different levels of the product hierarchy (i.e. Top Item | Customers, Item and Brand level can all have stat…
INV01 SPRINT 3 ISSUE
HI Team, I have few issues with the formula, its right or wrong? i have noticed 3 issues in my model 1. For Beginning inventory my formula is IF NOT 'SYS01 Time Settings By Week'.'1st Forecast Year?' THEN PREVIOUS(Ending Inventory) ELSE 'DAT01 Beginning Inventory'.Beginning Inventory here in week 2 of beginning inventory,…
Reducing Saves in Data Hubs
Data Hubs typically include large lists or numerous lists; both contribute to longer save durations. Model saves block other model actions, so we want to reduce the frequency of saves as much as possible. Reduce the Frequency of Saves First, put the data hub model into Deployed Mode. Learn more here: Enabling and Disabling…
INVO1 SHIPPING METHOD FORMULA
HI I got stuck in the shipping methods where am trying to using all sort of formula but shipping methods showing different error my formula: 'SYS07 Distribution Center Details'.Default Shipping[LOOKUP: 'SYS08 SKU Details'.Code, lookup: 'SYS08 SKU Details'.Supplied By] error : Data type mismatch: format other than LIST or…
Importing HR Data issue via Script using Process in Anaplan.
Dear Expert , I have to import Hr Data via Anaplan connect Script by using the Process which has been created in Anaplan with Import actions. But while importing its getting failed error as shown below . when i check Process and tried to Execute directly via process i could able to see we need to pass the Period while…

Upcoming Events

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