Data Integration

Long Term Planning with 2 Models
Hi everyone, We have our large production model, with 100s of modules that are currently feeding our P&L. This houses all of our actual, forecast, and budget data. The rest of the year we will be budgeting in this model for 2023 and 2024, but we want a "Long Term Model" (LTM) where we plan for 2025-2028. Ideally the LTM…
need help for practice
Hi All I want to populate "text line item" which shows string between 1st and 2nd commas of the items in the module. How can i do it. which function should i use here Thank you & regards Yash
Creating ISBUDGETVERSION() similar to ISACTUALVERSION()
Please consider adding ISBUDGETVERSION() function, similar to ISACTUALVERSION(). This would eliminate having to setup another module with only Versions as the list and creating a boolean flag. All followed by IF VersionsControl.Budget THEN .... ELSE...
Adding items to the master list
hi! I want to know how to add a master list item from the UI screen. Please help me.
API Actions (Imports, Process...) Metadata
Hello, In the api 2.0 it is possible to extract metadata from anaplan. This is available for the lists and modules but I could not find an equivalent for the actions. The alternative would be setting an export action, as I want to automatise the extract for several model, the alternative does not fit.
11.3.4 Actual and Forecast Values are the same
Hi there, My actual and forecast values are showing the same output. My forecast values should be different as seen in the example, but I can't figure out how to show the different output for the forecast values.
2.3.9.1 Import data into DAT03 Historic Volumes Module
Hello, I have been having difficulty completing the 2.3.9.1 activity. I utilized this forum to address my previous issues but I am still having trouble. The Historic Volumes aren't being populated. 9.2 and 9.3 seem to have populated appropriately. Please see the screenshots attached.
Lvl2 1.7.3.1
I am not able to import P3 SKU from the data hub saved view
Sales Planning Model: A2 List
Hi, I'm having trouble when trying to import into the Sales Planning Model: A2 List in the Sales Planning Model. I created the necessary System Module in the Data Hub in order to use to populate the A2 List. I also filtered the module so only the valid Account>Product combos show and saved as a view. I then imported this…
8.5.3 Activity: Import Data into Volume Inputs Module
Hi everyone, I'm getting this error message and I don't know what I'm doing wrong.
Failing to import Data In Region Flat -- Model Building activity Level 2 Sprint 1
Region Flat List in Tree View: Region Flat List in Grid View I'm getting this error while importing the data:
2.3.9.1 Import data into DAT03 "Expected week number in date/period"
Hi Anaplan fam! Since I have read almost every post about importing into DAT03 and checked the instructions many times, it seems I have exhausted all possible options. The only way I can import from Datahub is by using Match names in the Time tab. When I add line item "Offset Volumes for 1st Forecast Year", the value is…
Custom scripting line item calculations
I would love a way to be able to use my custom python scripts and the vast amount of Python libraries on line items in a module, rather than use the Anaplan formulas out of the box. It would save time on export/import data to the Anaplan model. I'm assuming the formulas that are used now are some form of Java or C++? Maybe…
Level 2 - Sprint: Activity import Data into DAT03 Historic Volumes Module
Hi guys, I've been trying to inport the 'Historic volume.csv' to the DAT03 Historic Volume Module for the past 2 hours. I already watched all the videos about importing data to module, etc. But I keep receiving this error, "invalid line item identifier", and I don't know what else I can try. Could someone give me a hint?…
Anaplan Connect 3.0 Training Refresh
The Anaplan Connect training was recently revised to include updates and best practices. Anaplan Connect is a simple connection tool for integrating data to and from Anaplan. This training provides an overview of Anaplan Connect 3.0, this includes: * 3.0 Overview * Setup requirements * Anaplan Connect Guide * Downloading,…
Get metadata for import action returns the target line items instead of File headers
Hello everyone, We were looking to query the mappings of a file that was being uploaded in the model through the endpoint of get metadata for import action. the link Anaplan Integration API V2 Guide and Reference · Apiary suggests the below statement: " You can use the API to obtain metadata for an import definition for…
Cloudworks integration - import action with input parameter
Hi All, I have an import action which required a target period as an input parameter to execute it. Then, a Cloudworks integration has been setup to execute this action. However, there is no way for me to input or setup the input parameter. The cloudworks integration failed with the missing input parameter. Any idea to get…
Recent Data Export Format Change
Hello, The data exported to excel from a module has recently had formatting changes. As of today, when I export a module from a dashboard it appears to no longer have formating. I think this could possibly be related to the maintenance performed over the weekend (05/14/22). Has anyone else noticed this? Will the formatting…
Get Import ID from Anaplan
Does anyone have a guide or can provide assistance on how to get the API ID from Anaplan from a model?
Deploy mode
Hi All, I have deployed a model from development to Production and try to run a script for batch run from other source in production environment, the script was run successfully but data is showing blank? And when i tried to upload the same file manually in production, i am getting error as "Deployed ode is enable for this…
Not getting Task Id while running API call(Export Action)
Hi all, I am using python for integration. After authentication part, I got Export Id through API call. Now using that Export Id for getting Task Id with API Post Method : headers = {'Authorization': 'AnaplanAuthToken %s' % token, 'Content-Type': 'application/json'} data = json.dumps({'localName': "en_US"}) response =…
Clear Large Amount of Data
Good Afternoon, I hope someone can help, so far it has taken me over 2 hours to clear out a large amount of data in a module (more than 500000 cells). Is there any quick way of doing it? I still got 7 more to clear data from. For some reason when importing data in Anaplan, it did not clear out all data before the import,…
SYS06 Sprint 1 L2 Mapping Problem
Please help , I am not getting the desired result.
Review SYS05 Region Details Module
I am not able to connect SYS05 , SYS06 , SYS07. Please guide Please resolve
【Action】Successful message
Hi, I tried to run Action in APP page. But I couldn't check the successful message. I want to check the number of import data. (I can check failure log.) Is Anaplan maintenance team doing any maintenance?
Execute Snap Logic jobs from Anaplan
Hi, We are using Snap Logic as our integration tool from GCP to Anaplan. Want to check if there a way to execute a Snap Logic job from Anaplan? Also, if your integration tool in not Snap Logic, Did you invoke or trigger a job in the integration platform from Anaplan? -- Selva.
Importing into list from subsidiary view
Hello, I am trying to import data into list by creating an saved view in a module. That module has a line item of subsidiary view. That line item is not getting mapped to list subset. Explanation: I have 3 lists L1, L2, L3 (all are hierarchy lists) One list created for requirement to use it as dependent drop down - LD I…
Enhance Excel Add-in - Refresh Options
When a user makes changes via the Excel Add-in and Submits them via the "Send and Refresh" button, it would be helpful to have a dropdown option similar to the "Refresh" button where you can choose to Send and Refresh Current (single active page) or Send and Refresh Multiple (all connected pages). The way it currently…
Level 2 - 1.7.3.2 Import into SYS08 SKU Details module - Help please
Hi I need some help here please: I think I've imported data in the Supply Chain Model P3 SKU correctly, however when I update the model SYS08 it is blank. I attach screen shots of my : P3 SKU SYS08 Blue Print Help much appreciated. Thanks, Chris.

Data Integration

Discussion List