Importing and Exporting Data

2.4.4.2
I do not understand where I have gone wrong... But my module DEM03 Demand Forecast seems not have pulled the data even though I have given the formula in the Growth rate line item... Could anyone please help me with this? My module doesn't match with the 'Check your work' screenshot which is attached...
Importing fata
I'm unable to upload data for utilities and total line item plz help.
Impact of Exports
Hi, Hypothetically, if I have an export running for 2 hours, what all does that export block in the model? I reckon users can still navigate around in the model/app but they won’t be able to run any action or make any manual changes (user inputs). Is my understanding correct and are there other things the user can’t do?
Can't map account to existing model
Hi, I'm trying to map an Account to another Account in a different workspace but I can't seem to be able to map these as the Account field is greyed out. Does anyone have a suggestion on what to do here? Thanks, Tom
LV.1 Exam Question 4
I've been stuck on this exam for too long trying to figure out where I went wrong. I thought I had the correct formulas but it is not producing the correct values to this question. For the medical cost of the Finance team, I used 'EMP03 Employee Drivers By Role'.Medical Benefit[LOOKUP: 'SYS08 Employee Details'.Department,…
Manage the saved view - Display by all modules
Hi all! It would be great if you could refine the "Manage Saved Views" feature and add the ability to view saved views of all modules at once, with the fields: Saved view, module, use in action, note. Saved viewModuleUse in actionNoteName of the saved viewThe module in which the view was createdProcesses in which the View…
2.3.9.1 Import data into DAT03 Historic Volumes module
Hello Everybody, I get this error when i lunch the process, can you help me please ? Best Regards,
Error In Mapping Data
I'm trying to complete model building activity in Sprint 1 Level 2 and facing an error while importing data from the file. Do let me know what mistake I'm making.
Use multiple characters together as the delimiter when importing
Currently if more than 1 character is used as a delimiter in an import Anaplan treats it as an OR, and looks for either individual character and not both characters together. For instance if you want the delimiter to be "|~" then Anaplan will look for just "|" or "~" rather than them both together. It would be good for…
New Lists Changing Previously Created Lists: Potential Parent Hierarchy Issue
Hi All, We are encountering issues where lists which were previously created have been changed when a new list is created. The "New List" is has the "Previously created" lists as its parent hierarchy. For example List Named "Department D2" is correct. A subsequent list called "Department D3" is created which has Department…
Reduced number of items to map to
Hi, I am trying to map 30+ columns, similar to how one of my models is set up but in the new model I can only map 3 columns. The source data is the same for both. Does anyone know how to increase this? Thanks, Tom
7.2.1 Activity: Help needed
Hello, Having trouble with Activity 7.2.1, I keep getting this failure and I'm not understanding what's wrong. Please help, thank you. Below are screenshots of the failure and my mapping.
Action with multiple source models
Hi community, I have a page with 2 source models: Model A and Model B. I want to add an action card which runs a process from Model A. When I add the process to the action card, it automatically adds a process from Model B to the card. And the 2 processes don't have the same name. So, if the user selects Model B and runs…
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
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?…
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…
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?
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

Importing and Exporting Data

Discussion List