Importing and Exporting Data

Bulk Copy multi month mapping
Dear all, Would be great to do a bulk copy being able to map multiple months either to the same month or to another month. So if for example I would like to copy data from Jan - Dec 2019 to Jan - Dec 2020 I would have to do this in 12 steps. Other posts have been shared that I also support, but are slightly different:…
Bulk Copy over a selection of two or more dimensions
Dear all, Would be great to bulk copy data on a certain combination of dimensions: For example to copy the data of one Store to a specific other store but just for a selection of months and a specific version. And make it possible to create an action out of it; it would allow end-users to pre-populate a new Product, Store,…
SYS08 Importing data
Hi all. I've been constantly running into issues importing the employee details csv file. I'm going to attach the three things I am seeing on my screen. Was anyone successfully able to import data? Let me know how I can do this.
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…
Automatically export Permissioning
Is there an action for exports? I would like to export permissions (user, role>module, role>versions, etc) in a more automatic way so I can assure a less time consuming and recurrent backup.
Level 1 Model Building: EMP01 Employee Drivers import
I've been working on the Level 1 Model Building course and I'm a bit confused by this import. I'm sure I have followed all the directions exactly from setting up the EMP01 module to downloading the correct csv file for import, but the one thing I can't get right is the time that it's asking me for. It's asking me to…
Incremental data load for current month
Hi, I want to do a data load only for current Month data, I have a data file where I have complete year data but I want to Load data only for current month. We have created a boolean line item which filter my current month records based on current period setting in model. but Just wanted to know, can we setup a process to…
Data import from excel to List
HI all, I am loading data from excel to List and i have blank entries in the excel sheet which has business meaning, hence i am bit struggling to maintain blank entries in the list or how Anaplan recognizes the blank entries from excel records and loads automatically to the list. -Santosh
Importing between Models - Mapping
Hi, I currently have 2 models and I'm trying to pull staff costs from one over to the other. The module I'm trying to import into is dimensioned by employees and years. The module I'm trying to import from is dimensioned by employees, years, and versions. When I connect to the Anaplan model and select the module, the…
Percentage Issues: Level 2-Sprint 2
Hello, I have a problem when importing percentages from a CSV file into the DEM01 Volume Growth. In fact after importing, it looks like all the percentages from the CSV file have been multiplied by 100. Any one has faced this issue ? This is my number format configuration. I tried ti change it but it didn't have any impact…
Import into Parent Level using BreakBack
I would be really good if we can import data into the Parent Level when Breakback is enabled. Currently, it is not possible in the system . Hope to see this functionality soon in Anaplan!! 🙂 🙂
Import Error
Hi All, I am receiving an error 'Illegal Argument' while importing data from the saved view of the module to the same actual module within the same model. Please help me with the possible reasons. Thanks in advance. Sampriti Anand
Level 2 - Sprint 1 User Story 1 Rename the action
When I try to rename the "G1 Region from Level 2 Data Hub [Your Name]/ 'SYS05 Region Details" to "T3.1 Build Region", I can't find the right place to click on the "Rename" button (I also tried right click on Import items but in vain), also tried to click the "Rename the action" hyperlink but there is no demonstration…
"Omit Summary Items" on Exports should be an option for Imports
Currently, there is an option to "Omit Summary Items" when you are exporting data designed to exclude parent hierarchies. However, there is no such option for imports and this requires users to create saved views that manually exclude parent levels and can cause a lot of manual work for model builders. Without removing…
Model change has been rejected to prevent the workspace exceeding its size limit
Hi, I am working on a Sales Forecast Model by using customer and item for a Region. In the Data Hub, number of customers = 13,083 number of items = 24,876 However, I got an error message when I tired to create the forecast model by using customer and item (see attached.) Is there any memory alert in Anaplan or how can I…
Export in Tabular Multiple Column Layout - Overlapping Filters
Hi Team, Reading on Anapedia that when you export using the Tabular Multiple Column option and use the Boolean filter options that if those Boolean filters overlap then both criteria must be met for cells to be exported I created a very simple test where I created 2 Boolean line items for Product Family & have Chocolates…
Import Data Between SSO Enabled Workspace & Non-SSO Workspace
Hi all, I know that we can import the data from different workspace. My question here is "What will happen if SSO setting is different between the those?". i.e. Workspace A→SSO enabled Workspace B→Non-SSO →Can we import the data successfully or it will fail? *Both workspace are in the same tenant. Thanks Mao Ninomiya
Import Fail - Invalid date or Timescale error
Hi Team, I have a line item where the data is Imported from another module in the model I have also created another line item in the same module which is set to No Data that I Import to the line item mentioned above to clear it before running the previously mentioned import action. I have these 2 Actions in a process (1st…
Transformation Data
What is "Transformation Data" in Anaplan ? What is its significance and in what scenarios, it can be applicable ?
import query c sharp dimension in the target module do not match the import definition
What does that mean? Something isn't importing from my sql query.
Non availability of Action buttons in mobile application
Hi, While using the mobile application, I observed that I am not able to see the import and export action buttons in the pages which I created in new UX pages. In one of the projects, since some of these actions are really essential for the process movement of the model as well as the requirement is for user friendliness…
Exporting Revision Tag details in excel
Hi there, Just wondering if there is an option of exporting Revision Tag details in Excel or other formats? I am trying to get all revision tags exported in excel for detailed documentation purposes. Thanks, Vish
Uploading file via REST API/Python
Hi, I am working on an item that uploads .csv file into Anaplan. I'm not sure why the upload doesn't work even if the response of API is successful. I've tried using some codes posted here but seems the upload does not work (download, import seems okay) I'm using basic authentication and 1.3 version of the API. Here is a…
L2 Sprint1 Set up import from Source Model
I was hoping to confirm if I created 3 new lists; G1 Region; G2 Country; G3 Location in the right area. They show up as Subsets.
Uploading user stories from excel
Is there a way to upload several user stories through an excel file instead of entering them individually?
Model import
Does anyone know how to deal with this error?
Exclude Line Item Subset from data export
Hi Team While exporting data from a module, if there is a 'Line Item Subset' in the dimensions, we are unable to exclude it from Export. Can you please make the option available? I have provided some screenshot. Thanks & Regards Kudi
Ability to import from subsidiary view with one dimension or from module without dimensions
Description: Being an Anaplan Builder, I would like to be able to perform imports from subsidiary view with one dimension and from modules without dimensions. Example of Enhancement: Working with different models, it is sometimes required to perform and import from line item without dimensions or with only one, but being…
Not able to load special character
I am not able to upload List with special characters in my Anaplan model correctly. When I am uploading list with special characters, Anaplan is ignoring special characters and considering the other English language character. The line items are formatted as TEXT in list in Anaplan model. Ex: For name "STARK JYVŠSKYLŠ"…
Level2 Sprint 1 - DAT04 Distribution Center Parameters
I am trying to import the Half yearly data into this module. But I am facing difficulty to map the dimension. What format to be used here. The CSV file has data in the below format. H1 FY20H2 FY20H1 FY21H2 FY21

Importing and Exporting Data

Discussion List