Importing and Exporting Data

Cloudworks export date format timestamp
I would like to have the possibility to define the date format for exports to cloud storages. When you currently export files through Cloudworks you have the choice to tick/untick the overwrite file option. If overwrite is unticked Anaplan adds a timestamp in a worse machine reading format (e.g. <action…
how to split a line item in one module into multiple line items in another module
hi Need a help. I am very new (few months) to Anaplan. I got a simple requirement, have to create a new Export module(REP01) from OUT01 module ND Each row in OUT01 will form two rows in REP01. How could I achieve this. Please help. Thanks Module: OUT01 Module: REP01 Regards Balu
level 1 exam activity 4
@Misbah Hi, Can you help me on this? I have imported data correctly and formulas also not giving error but I cannot see data in EMP02 module under bonus, car cost, medical costs and phone costs. Hoping to get response at earliest.
Level 1 - 7.2.3 - Issue in mapping a numbered list
Hi, I am trying to map the E2 Employees# using source of code as it is a numbered list. However, still it is not displaying the employee names.
Import List from List
In all the model building exercises, we are importing list items from module, rather than importing list items directly from the hierarchy lists. Any particular reason for that ?
Snowflake Connect Null Pointer Error
Hi, I have setup JDBC properties file, and a batch file to run Anaplan connect. However i get Null Pointer errors, which are quite useless as they do not tell you where the issue is. Please can anyone point me the right way? My jdbc snowflake properties file is as follows jdbc❄️//…
2.3.9.1 Import data into DAT03 Historic Volumes module - 9.3 Import Shipping Metrics
I am having issues with 9.3 Import Shipping Metrics. I'm not seeing why I keep getting this error. Please see attached.
Cloudworks configure job to run as another account <Service account>
It would be nice to configure Cloudworks integration to run as "user/account" <Service account> instead of using the current account when you create/configure an integration.
Level 3 Distribution Center Parameters
Here is my DATA HUB modelDistribution center parameters: Here is my target in the supply chain model Here is my import window mapping: My time mapping seems to be correct: Looks like no issue with p3 SKU, and here is my line items: But my import still fails: I tried doing the manual mapping, that seems not helpful too. I…
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…

Importing and Exporting Data

Discussion List