Importing and Exporting Data

Very urgent ---- Formula assistance needed
Module 1: I have a Transaction List and the Employees responsible for the Sales. Module 2: These are 3 types of Cars of different cities Commission percentage. Module 3: Now the challenge is I have to make a new module with Employee and Commission. But the data should be flowing from Module 1 by ‘Connect to Anaplan Model’.…
'Upload File Not Available' Errors / Default File Setting for Deployed Models
We have occasionally experienced failures in import actions (on deployed models) called via Anaplan Connect with the error ‘Upload file no longer available’. Our understanding is the default file should to be specified as ‘admin’ instead of ‘private’. This setting can’t be changed via API call, so we updated the mappings…
rename the filename of a file before export
Hi Community, I have a module in which I created 2 saved views in order to have 2 different export actions (1 for region A and 1 for region B) . I saved the export definition and used Export name: forecast_A for the first export and forecast_B for the second export. In the actions overview, I see those 2 different export…
Filtering Import
This is my Original Module. Now I want to create a New Module which will have only Orange Data. But I can't use Lookup, as I have restrictions of Formula Linking. Only thing I can do is Import. Is there any way to do it? Need your support.
Data Pulling into Target Module
Hi Friends, I can't populate directly from list but need to populate the values from Module 1. I was trying with LookUp but it throwing error mentioning 'List does not have a built-in top level'. Please help. I am learning on my own and none to ask assistance.
Dashboard for beginners
Hi Friends, I want to learn how to create a filter list item in a Dashboard. Such that if that list item is selected, automatically the associated modules displays only that values. Any link will be helpful.
What is a Source Module?
Hi Friends, Please tell me, when do we need to build a Source Module?
Trouble importing System module to Numbered List
Hi, I'm trying to import a system module containing flat list dimensions (store, product) containing line items that combines store and product code into a combined numbered list that up until now only have stores in it. When running the import I get below failure messages although import was completed: * Another row has…
Ability to reorder multiple list items or reorder a list by its code numerically or alphabetically
Some of the master data lists within our model is based on numerical codes. New list items get added to the list at the bottom and we would have to manually reorder it to the top using the 'Move...' functionality. Using this, we are only able to reorder one list item at a time, which can take a significant amount of time…
Calculation
Thanks community friends for your kind help. I am stuck in a step. Need your suggestions. I don't want the percentage to add up but remain the same (ie 5%).
Calculation help
Dear Members, I need only these parent values. Which will be the easiest way to do it?
Deployed Mode - Bulk update of Source model name (M-M Import actions)
Hi Team, Current Scenario: In the Deployed Mode, for the Production Data checked Import Actions (Model to Model), we have to manually update the Source Model name one by one. Suggested Change: Select Multiple rows of Import Actions and update the Source Model name at one go for the selected ones. Thanks Sathya
Excel Add-Ins with password protected spreadsheets
Hi, does anyone know if there are any workarounds when using the Excel Add-In, if you want to password protect your spreadsheet? We have an end user who wants to do this, but is getting error messages when the spreadsheet is password protected (fine when he takes the password protection out). Thanks, Andrew.
Efficient way for handling large parent child hierarchies
Hi, I am looking for an efficient way to handle undetermined parent-child hierarchies coming from an ERP system. This is the challenge: I have about 35 local cost center hierarchies from different ERP systems, all with different number of levels, and extracted with parent-child-IDs. How can I bring this efficiently to…
Data Import
Hey when importing data for SYS08 employ i nfo I am unsure as to by employees are being linked to departments any help?
Level 1 Model Building : Question on DATA01 Module
This question concerns part 11 of the Level 1 Model Building in Activity "Create a profit and loss model". I have a big import problem for the P&L+Actuals+&+Budget.csv because beyond the Actual,UK,Utilities line, nothing goes beyond that in the import (i.e. 2/3 of the data is missing in the import). I checked the validity…
SYS06 Data Import
Hey I am trying to complete level one module data importing for product details and am encountering problems. I think it might be size but I don't know where to match. Can someone help? Here are some screenshots.
Information for Line Item Referenced By Actions
It will be helpful to have information for any line items that are used or mapped in actions either in list or line items mapping tabs. This will prevent deleting them accidentally when performing a model cleanup
Anaplan colnnect: action not found
Hi, We use Anaplan Connect 1.4.2 to automaticly do some imports (SQL/Anaplan) and lauch some actions (imports between two Anaplan modules) every night. We have no problem with SQL/Anaplan imports, but this process doesn't work for actions between 2 modules. This message appears when the system tries to do an action:…
Totals remove.
Hi Friends, Is it possible to remove the totals. I didn't select any top-level. I want to look it as below.
Review Import
Referring to someone else model on how the import was done to confirm the mapping - is it possible when you pick up a random model to review how the import was done?
What is this error? Error during uploading a file
Hi experts, I'm encountering an error while uplaoding a TSV file for import source data. The error window says "invalid END header (Bad central directory offset )" Could someone give solution to this?
Export Action Dialogue NUX
Please can the full export action dialogue be added to the NUX when exporting from worksheets? Currently, users only have the option to edit the export file format (e.g. .xlsx, .csv, .txt). Would be great if users had the full array of options as shown below, without setting up a custom action.
Level 1 Model Building - Importing Data
Hi In going through the import data files (e.g. Products), I came to understand that although the parent-child hierarchy is defined in the Lists, 1) the data for the parent (Product Family - Chocolate, Sours, Taffy, Fudge) still have to be defined in the import file. 2) the mapping for the parent (Product Family) still…
Level 1 Model Building - Importing Data
Hi In going through the import data files (e.g. Products), I came to understand that although the parent-child hierarchy is defined in the Lists, the following still need to be defined: 1) the data for the parent (Product Family - Chocolate, Sours, Taffy, Fudge) in the import file. 2) the mapping for the parent (Product…
Unable to map module /csv
Hello Everyone, I am trying to import a csv file in my module but having troubles with the mapping for one of the columns when I tried to do "Match on names or codes" all the items are ignored and when I tried to map manually it doesnt allows to pick any value from the target items. Please see below screenshots for…
Data Quality/Integrity Checks within Connected Planning Environment
Hi All, In thinking and implemented a Connected Planning environment, where we have specific models for specific areas our finance team that are brought together. We currently have a number shared hierarchies (across cost/profit centre, GL), shared data (TB, Subledger etc) and currently handled via the data hub as the…
Run multiple actions from selection in Actions panel
Would be great if you could run multiple actions from the actions panel based on your selection. For example, if you selected two import actions and hit Run, Anaplan would run those two actions as though they were in a process. This would greatly help model builders test actions where creating a process is not needed. The…
Error in List
This is the original list. This is my new List.
Allow Actions to Write even though there is no write access to the module
Usually Snapshots are created by running a process (Create & Import). For this, we have to provide write access to the module and list. This is dangerous as the user can accidentaly / intentionally can change the snapshot data itself. So we should have ability to write via action and not write directly into the module.…

Importing and Exporting Data

Discussion List