Importing and Exporting Data

data import
how to import data from one module to another module when dimensions are not match.
Process not running correctly
Hi, currently have a process that is supposed to take data from one module and put it into another. But currently the process is not working. Screen shots of error are below. Thank you
Populating Numbered List from a Module with 4 or more dimensions:
Use Case: I am trying to create a Numbered List from a module with 4 dimensions typically SKU, Tier, Product and Level & few Line items. For modules dimensioned by 3 lists it is straightforward to create a View as the source of the Import with the 3 lists as Column items and the Line Items as Row items. Unfortunately this…
L2 conclusion INV05 export - import is wrong
Hello. Please help me for settings of exports. I've changed many variants, but it still wrong. The pivot Filter - Months Only Summarize - none I try to export grid or table, but it gives mistake for import. Please, help me for solve.
2.3.9.1 Import data into DAT03 Historic Volumes module
Hi, If I run the process "Import Data from Hub" in the Supply Chain Model , I get the notification below. Anyone who can help to solve this error?
Selective slide exporting from Management Reports
It would be great to be able to select specific slides to export when export management reports to PDF. Currently the system automatically exports all slides and you can't deselect any if you don't want to include them in the report pack.
Model Builder 3 Training 5.5.1 Data Hub Model
Hi All! I am working on Model Builder 3 and am on step 5.5.1 which says: "In the Data Hub model, create an Employee Details system module. Then, download the Employee Details data file and import into the Data Hub module". In my starter model, there is already a SYS09 Employee Details module with all of the information…
Changing source file name
Hello Community! I´ve been working with Anaplan for several years now and whenever I´ve needed to change the import file for an import action I´ve just created the action again using the new file. This usually isn´t a problem so I haven´t given it a second thought but what if you had 15 actions that are included in several…
Moscow TimeZone for Cloudworks
As an Integration Admin, I need to schedule an action in Cloudworks for Moscow TimeZone (UTC +03:00) to run actions in the proper time.
Filtering by Users when Imporing
Hi, I want build a system several End Users can make the master data at the same time. The point is EndUsers do it at the same time. So I made a module which has Users as Applies To. And EndUsers have to import this module to List. But I could not filter by Users. So data which another User made was imported at the same…
Exporting Worksheet as PDF
I am trying to export a PDF from a worksheet that contains images linked to Box. The images are visible as long as I am logged into Box but the exported PDF doesn't contain those images and gives a message "We can't find that image". This is something unexpected as it was working previously for the same image and now…
Level 1 , Activity 5
I have mapped everything right in level 1 activity 5 , but the medical cost for December 2020 is showing 36,800 and that is not the right answer.Can anyone please help me with , where I am making the mistake .I have attached my mapping here.
Building a Chat Bot - Part 2: using Slack App and Ngrok
In our part 1 (for AWS or for GCP), we set up the foundations to build our grand project: having a chatbot interacting with Anaplan. By getting a new token at will, we will then be able to authenticate to Anaplan as many times as we need. We are still far from our main goal though. So, let’s continue! In today’s series, we…
Import Data into DAT02 Shipping Metrics Module
Hello, Please need your help as not understanding how to import as 1.6.2.1 need help please
Bulk Copy Action - Details
Anaplan has released two major updates to its platform during 6th Nov 2021 release updates. 1. New Action for Bulk Copy 2. Optimizer Updates Here are some of the details around Bulk Copy that I observed. * This Action/Process will work only on Non Production Lists/Structural Lists * This Action/Process can only be run by…
Process of Processes
Hi team, I would like the ability to run a "process of processes". Currently I have to maintain multiple processes that often have overlapping steps and it makes maintenance tedious and ripe for human error. Example: Process 1 - Refresh Cost Center Hierarchy Process 2 - Refresh GL Account Hierarchy Process 3 - Refresh…
Contracts missing after importing data
Hi all, hope you can help me. During my last data import to Anaplan, 2 contracts were not imported in. However during the import there's no error annoncement or log saying that these Anaplan has failed to import these 2 contracts. Only when users found out that their contracts are not visible on dashboard that I learnt…
How to Interact With Anaplan Application Lifecycle Management (ALM) APIs?
* What is covered in this article? * What is NOT covered in this article? * What pre-requisites do I need? * Introduction * Anaplan Setup * Postman Setup * ALM Process * Step 0: Create Revision * Step 1: Take Target Model Offline * Step 2: Retrieve last revision from Target Model * Step 3: Retrieve syncable revision tag…
Can't get my export right
Hi community members, I have created a saved view in which I enable a filter to filter out any rows which have a CIP value (kLOC) = 0. The filter uses a boolean line item in the module itself, which defines if the value is different than 0. When I look at my saved view, it looks good. However, when I export the view, the…
2.3.9.1 Import data into DAT03 Historic Volumes module
Hi, while running this import -Run Process 9 Import Data from the Hub, i am getting the following error. can anyone please let me know where i am going wrong?
load all data from Prod Env to Cert Env
Hello, The users have completed a forecast cycle in the production application. We have developed a new dashboard in the Dev application and moved it to the UAT application for user validation. To validate the dashboard, users want ALL data(actual,user-entered forecast, and data loaded from 3 other sources) to be Synced…
Increase limit of row field when pivoting
It would be really helpful for myself and colleagues if more than just three items could be dragged into the row field whilst pivoting a module. This would also be really helpful for zero suppression on Anaplan exports as well as saving the need to manipulate Anaplan exports in Power Query (or similar data transformation…
Level 1 lesson 4
Can someone tell me what the correct mapping is for this? Level 1 Model 4 Import data into P2 products list
How to upload a file using Anaplan APIs? [Anaplan]
0I wish to upload a file using Anaplan APIs but as mentioned in the API docs here is that Note: To upload a file using the API that file must exist in Anaplan. If the file has not been previously uploaded, you must upload it initially using the Anaplan user interface. You can then carry out subsequent uploads of that file…
Sync Multiple Production Models at Once Using ALM API
With the release of the new ALM APIs recently, I thought it would be useful to see a real-life use-case of how they can be leveraged. Oftentimes customers will have a single development model tied to multiple production models and when changes need to be pushed, the model builder must go into each production model to do…
How can I change the hierarchy of list parent in module
Hi, I'm figuring if it is possible to change the hierarchy of list parent in module line item For example, I have the following list 'Test 2' with child 'A' with parent '1' and child 'B' & 'C' with parent '2', where the high level of list 'Test 2' is list 'Test 1' with two list item '1' & '2' I have put the following list…
Create an action using command line/shell script Instead of creating an action in anaplan.
The below feature is not yet to be included in the Anaplan Connect: Create an action using command line/shell script Instead of creating an action in anaplan.
Working with Processes and Actions
Hi Team, Placing these here as a bulk request: 1. Would like edit/view contents of Action when I find it in a Process. Today I have to abandon the process then go find it from the Actions list. 2. Search Actions when building a process: When building a Process we have to scroll up and down the list of Action (which may not…
Action Logs Not Capturing List Formatted Line Item Copy Across Changes
Hi Community, My query is more from a workflow management perspective. I will try to explain my case below : 1) I created 2 test modules both with same structure of dimension and list formatted line items. 2) The idea is that one module will act as a clearance module, i.e., will clear the line item values in the Target…
File format notification for uploads in new ux
We need to able to see the exact format(txt,csv) below the upload a file when we do file upload in new UX. Currently what ever the format of the file the action is created, it shows csv only. This creates the confusion for the user on which format the file as to be uploaded.

Importing and Exporting Data

Discussion List