Importing and Exporting Data

4.6.7
I used the mapping column 3 family code to P2 product family column headers to parent column 1 product code to code I get the error another row has already been processed with this key and invalid name 53 failed
Create Shipping Export Module and Create a Saved View
In Level 2 Model Building : Conclusion, there's an 'Activity: Prepare Data Exports' that tell us to Create Shipping Export Module and Create a Saved View. I've made the formula and choose the format and summary method but I'm not sure if it was right. Here is the blueprint of my INV05 And here is the screenshot of the…
What is Managed By functionality?
2.3.8.2 Import into DEM01 Module
Hello, I'm attempting to import Volume Growth Rates.csv. When mapping the time (column headers) on the file, I select Periods, but there is no Y-M or M-Y option. I assume something is messed up that I'm unaware of. Any feedback would be appreciated. Sean O
Use Custom Fixed position pattern for 13 periods of 4 weeks
On loading data into a module, the Time dimension Custom patterns are based around a true calendar month, 1-12. There isn't a custom mapping pattern for periods which where the system time is set to 13 periods of 4 weeks. For instance, using custom YYYY_MM or YYYY?MM for the below data, would allow to load the data…
Stale Module Data in Power BI
I've successfully built out a Power BI semantic model that appears to connect to Anaplan just fine. When I created the model, I logged into the Anaplan Connector using my company SSO. Once the credentials were validated, I selected the Export Action that I had previously created and loaded the data. Initially, all data…
1.7.3.1 Import into P3 SKU list
I am having trouble importing the data from the Build SKU saved view. When selecting my sources for the data, I don't have many options to link the properties to the sources. Is there something I am missing?
While importing into system, how to highlight data already present in the module/list but
While importing into system, how to highlight data already present in the module/list but not present in the file.
Why does ADO Map show undefined under each chart?
Hi All, I am testing ADO functionalities and noticed in my map that it shows undefined for the charts although all my data flow and links are connected and working as expected? Is there anything that needs to be done further to remove this?
Data Hub Imports without manual uploads, how?
In the Data Hub training it says 'DO NOT' use manual uploads to the data hub. Use ETL Tools. We receive data in flat files (csv) for many of our data sources, and have no 'link' to their systems. So how do I utilise my data hub it if am not supposed to manually upload these files?
Data Export Options in Anaplan Data Orchestrator ?
Hi Anaplan Community, I'm new to Anaplan and exploring integration options for moving data between Anaplan and cloud services. I successfully exported model data to Google Cloud BigQuery using the CloudWorks integration. However, I couldn't find an option within Anaplan Data Orchestrator (ADO) to directly link model data…
Error in key for this row; refers to invalid list item
Hi everyone, " Error in key for this row; refers to invalid list item : Headcount " I get the above error when I tried to import data into Numbered List, which is uniquely identified by combination of properties. Actually, the list item which is formatted by some "xyz" list has list item ' Headcount' Even after that, I am…
source to target data is getting loaded partially via IICS
Hello, i'm fairly new to Anaplan but come from BI products world. I have a situation, an Import action is created in Anaplan dev. This action picks up the .csv file from source location (This has been working perfectly fine in our environment for last 4 years) and loads it in to one of the Modules. This process has been…
File format vs Anaplan
Hi, I want to ask for help with why while importing, it keeps on reading my code like this xxxxx+12? Attached photos for reference: File: (.csv format) Anaplan: Thanks,
JSON as Import File Format
With the JSON format being the pervasive format for API data interchange it would be excellent if Data Import actions could use this format of file as a data source.
How to create multiple actions with same source type and source target type?
How to create two actions with same source object type and target object type without creating new saved view and the two actions has a different mapping in line items?
Import Shipping Expenses into OTH01 Module
Import Shipping Expenses into OTH01 Module In the Financial Planning & Analysis model: Import the data from the Supply Chain model into the OTH01 Non Employee Expenses module, Shipping Cost line item. * For department, import into the Sales department. * Run the import. * Results should have none ignored and 0 errors .…
Export data source as a new tab
Unless the model builder names the saved views appropriately, it's often difficult to trace the source object of an export action. It currently indicates only the list name or the module name, but if we can have a tab for 'Exports' similar to 'Imports', to indicate if the source of export action is a module default view or…
Level 3 Sprint 1 Import
Its regarding Level 3: Sprint 1 : User Story says " Import the Financial Forecast data from the Level 1 FP&A model" I have used the "Baseline+Financial+Forecast.csv" file. I am struggling with the import mapping "Time" and "Baseline Financial Forecast" portion. I keep getting failed errors regarding date format…
Parent with the same name with its baby item will also map to baby item when Import
Is anyone facing the problem? It worked all right till last week, but I fund it went wrong yesterday. For example, If Importing from Module A to Module B, and both of them applies to Dimension X, which has hierarchical structure. If Parent NNN has the same name as Son NNN, then It become Twice after import to B.
Can i export a dashboard in pdf from the mobile app?
My client uses Anaplan on mobile devices. Is there a feature to export a dashboard screen in the form of a pdf? I am not referring to Management Reporting slides. I am talking about plain simple dashboards containing grids and charts, designed specifically for the Anaplan mobile app. When you try sharing the page, it goes…
BULK COPY - How to choose the SOURCE member and the TARGET member from a page in the app?
Hello Anaplan Community! Does anyone know how to choose the SOURCE member and the TARGET member from a page in the app? Thanks in advance. #NewFeature #UX #Dashboards #BulkCopy #Data #AnaplanRelease
How to integrate Azure blob and Anaplan For transferring files
Is there way to connect azure blob and Anaplan to upload/import data can it done by rest api call or can i use custom script to call Anaplan connect import hub from azure??
[Start Here] Anaplan Connect 2.0 and JDBC Connectivity
* What is Anaplan Connect? * What is covered in this article? * What is NOT covered in this article? * What pre-requisites do I need? * Deep Dive on Integration * Integrating with SAP HANA Cloud * Integrating with Snowflake * Integrating with Azure SQL Database * Integrating with Google Cloud (GCP) BigQuery * Integrating…
Ability to Add Data Write Action to Existing Process
1. It would be really a game changer if we are able to add Data Write Actions to the existing processes, It would not only scale up the usage of the Data Write Action but also would save a lot of time and effort and would save us from creating multiple saved views and actions. 2. Currently, Data Write actions can only…
Model Concurrency & Sanitization
Hi Friends, Do we follow these in Real Life Scenarios? Model Sanitization Guide Model Concurrency Testing Types Model Concurrency Process
How to import date from one model to another
I'm not sure if there was a new update that changed the process? I cannot import a date from one model to another. I am trying to import the dates from A01 to A06. I think the checkbox on the mapping page is new. I've tried different variations but can't seem to get it to work. Thanks in advance
Log exports in the model history
Description of the enhancement required: Customer wants to capture the export information also to be captured in the history log. Currently, only import information is available. A story for why you want the enhancement: For the customer, apart from imports that are scheduled , if a user clicks on export they want that…
Anaplan Connect - Running the proccess/imports
Hi All, I need your help regarding process or imports in anaplan connect. In the import or process when any of mapping is selected as ' ask everytime while import'. How can we complete that process or import successfully using Anaplan connect
Anaplan Connect cannot connect to database
Hi, We recently set up a new database to export data from Anaplan to Azure. The database is a SQL database on Azure VM. I am trying to set up connection. Export out of Anaplan is always successfull, but keeps failing when connecting to the database. Jdbc connection string: Anaplan connect is also running on a VM.…

Importing and Exporting Data

Discussion List