Importing and Exporting Data

Clear the Target for a Module Import
Hello everyone: Anaplan provides a lot of flexibility in regards to clearing data prior to imports. You can read about all the available options here. In particular, I am referring to: * Clearing the Target for Time * Clearing the Target for Dimensions other than Time I have always used the default settings such as Clear…
CloudWorks Integration with BigQuery: Understanding the Error Message Table
Hi Team, In the official documentation under "Google BigQuery Permissions" I found details about creating an optional error message table with the following structure: integration_id run_id run_date error_code error_message failed_row While the documentation outlines the table structure, it lacks details on how records are…
CloudWorks—This is how we use it, Part 3: The CloudWorks API
In Part 3 of our CloudWorks - This is how we use it series, we will introduce you to the CloudWorks API. This is typically for an audience comfortable with REST APIs concepts and programming. If you need a refresher on What CloudWorks is, see Part 1 or, for how to set it up, see Part 2. CloudWorks API will allow you to…
Make Integration admin role available for visitors & partners
It's currently not possible to assign an integration admin role to visitors and respectively also not to Anaplan Partners. This makes it a challenge when helping customers with Cloudworks or when just setting up a scheduled model-to-model import. It requires always someone at the customer capable to set-up the connections.…
Best Practise of creating List
Which is the best practice for creating List in a Spoke model from Data Hub model ? Is it a List to List import OR Saved View to List import ?
Import 2 number list with identic Parent and Code
Hello, In Model 1: I have 2 Number List: Payer Sold to, with parent Payer Every line in organization, also exist in Sold to list. As example: Name: Parent: Code: Aushan _______ 12 - Payer Aushan Aushan 12 - Sold to Aushan Aushan 15 - Sold to In Model 2: I have 2 Number List, as well: Payer Sold to, with parent Payer I copy…
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…
Help with L1MB lesson 8.5.3 Activity: Import Data into Volume Inputs Module; Import not working?
Hello — I have been trying to import the data file Volume+Inputs into the REV02 Volume Inputs module with no success. Just a couple of disclaimers: I am in grid view when I try to import I have refreshed both the lesson view and the example view I have re-downloaded the file I have updated the grid view for the time being…
Enable API or Save as Action for Exporting Dashboards to PDF
Currently, there is no direct way to export Management Reports, NUX Dashboards, or Classic Dashboards in PDF format via API or through an automated process. This limitation impacts reporting workflows, as users often need to manually export dashboards, which is time-consuming and inefficient. The ideal solution would be to…
Stop a process in CloudWorks
I kindly ask to add a "stop" option in CloudWorks Integrations Menu, because I have a process which is stuck and I need to spent a lot of time to delete and re-create it every time a process doesn't work. Thanks in advance!
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
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…

Importing and Exporting Data

Discussion List