Importing and Exporting Data

Level 3 Model Building (Importing Module data into List from Data Hub)
Hi, I'm having problems importing data from my Level 3 Model Building Data Hub into the other Level 3 Model's List. I need to Import that from my Module SYS14 Create Account> Product into the List A2 Account>Product. I created the LI's in the Module in the List as Properties, but I'm having trouble pulling in the data from…
Headers in export files
When Exporting files from Anaplan I would like the possibility to remove the list name from the header when adding properties properties in the export file. Today I can only choose Include or exclude Row Label headers. I would like to have the possibility to exclude the name of the list in the header. From above export I…
How to perform activities while starting as a beginner with no application on the system?
Could you please help how do I get to access the application hands on for practice and further to perform activities to answer the exam questions through my system LIVE. I'm a beginner trying to give L1 exam. I have completed entire course theory with certain practical activities yet to be practiced. Any help is highly…
4.8.2
I've been having an issue with locating my error in the model for the Parent Error I keep getting everything is mapped out correctly and I've literally lost 2 days trying to figure this out it's not because of lack of effort. But now I fear I won't have my lessons done in time to stay on pace to finish. I really need some…
Retrieve more than 1000000 cells using anaplan API
Hi Everybody, I am trying to automate some task by retrieving data from Anaplan using the Anaplan API. Seems like the maximum of cells we can retrieve using the API is 1000000 cells. Since I have a lot of models that have more than 1000000 cells, I am wondering if there is a way to get the data by chunk or any other way.…
Level 3 Sprint 1 2.2 importing Baseline Financial Forecast Data
Hi all, I know that there is a ground rule saying that level 3 model building should be and only be done personally, but I thought asking some help on import error could probably slip through this rule. I'm getting some error when importing the CSV file < Baseline Financial Forecast.CSV> provided by the course, error…
Translation of time list for views and exports
Recently I've been working on an implementation of Anaplan to a non-english speaking customer (portuguese in my case). As part of that journey I was very pleased with the fact that in the data imports Anaplan can translate time from different excel languages into the standard time list - in other words months in Excel…
Current Day
Actually we have a module that includes a column with dates, and we want that Anaplan identifies if a date from the column has passed or not yet. For that we have created a line item, and we would like the logic behind the formula to be something like this: IF the date (from the column) is prior to the date (current day)…
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…
L2 Conclusion Import Currency Error
I am trying to import Currency List but somehow it doesn't work.I am stuck at this activity. I am also attaching the screenshots of Error. Don't know whether its a mapping issue or something. Also I tried mapping via Name or Code but still it doesn't work.
Default Export Excel Format
Hi, I am keen to have the default export to excel option changed to the xlsx version rather than the 1997-2003 xls format. While I know you can change this when exporting it would make sense to have the newer version as the default to allow for quicker exporting. Surely 99% of users would prefer it in this format ? I…
Level 2 Conclusion Issue on Importing data DEM04 to DAT02
Hi Anaplan Community, I am facing an importing problem. Although I think I'm doing everything as it should, I get an error message every time. I have attached all the pictures and it can be seen that I must be doing something wrong with time mapping. But I couldn`t make it. I really appriciate your help. Thanks in advance.…
Level 2 Sprint1 1.3.10.3 Import Data into G3 Location List
The expected result is : But the result I got is as below : Can anyone please help me why my result is not as expected exactly? Do I need to delete the rows I have highlighted to get as expected result?
Import and export data treasure hunt
We're restructuring the Import and export data section of Anapedia, and we'd like to find out if our new structure is intuitive. Try our imports and exports treasure hunt and see what you can find! The exercise finishes today, but if you have a spare 5 to 10 minutes, why not have a go?
Level 2: Conclusion Create Inventory Ordering Saved View and Export
For creating the export and saved view for Inventory Ordering, my beginning inventory is different from the data given by Anaplan to check. This is due to the data imported while attempting my Sprint 3 exam to update Submit Purchase Order Request? So shall I delete the data imported to match it to the exported data? Kindly…
Level 2 Activity 2.3.9.1 Import data into DAT03 Historic Volumes module
Hello there, I came across one error when I deal with activity 2.3.9.1 Import data into DAT03 Historic Volumes module at level 2 ( refer to Process failed error.PNG). I have made sure that Actions -> Import Data Sources is correct and updated ( refer to Export.PNG). I have also verified the Source Model ( Source…
Hiding or removing the line item (on the 1st line) of an export from a module
I am performing an export from a module and the user of my export wants to have the extract so that the line item name is not appearing at the top. The line item is sitting on the "pages" dimension on the "pivot" view. In the layout tab, I have it set to: Grid Current Page Omit Summary Items Omit Empty Rows However in the…
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.

Importing and Exporting Data

Discussion List