Importing and Exporting Data

Level 2 DAT01 Inventory
I have imported data into DAT01 but the inventory amounts are not correct. I have attached my mappings but my issue is with the Distribution Centers. They aren't matching and when I check my data against the import, the values don't match correctly. I also added a filter to not show inventory that is 0. Thank you for your…
Question on how to map miss-matching dates
Hi, I would like to know how to match my flat file's when my dates on my flat file and Anaplan do not match. Usually I end up having to manually match them. Please advise. snap shot attached below. Thank you
[Start Here] Power BI - This is how we use it. Part 1: The basics.
Welcome to the best practices series about the Anaplan Connector for Microsoft Power BI. This is the first of a three-part series designed to help you understand why and how to use the Power BI connector by covering the basics, the set-up, and a real use case. Let’s begin with Part 1: The Basics. What is the connector for…
Level 2 Sprint 1 SYS07 mapping
Hi, I'm trying to import data into SYS07 module. I'm not sure why the region and countries are not being mapped. As fas as I think it is due to the region being names(America, Europe) and not being codes (EMEA, APAC etc). Same with the countries as well. Is that correct? If yes, then how do I resolve it? Thanks.
History update lag
When tracking the bulk data imports in my model, I'm noticing there is a lag of what is presented in the history export. In other words, if an import happens at 4pm and I check the last 24 hours history at 4.10pm, I will not see the changes yet. If I check some time later (around 1 hour later), the updates appear with the…
Retrieve Anaplan Field from API? Cannot export in platform.
Is there a way to retrieve the following field via API or Transactional API? I noticed that there is no way to Export it via the Anaplan interface but am hoping there is a pathway to retreive it through Python or some other API tool.
Maximum Number of Chunks to upload huge file using API
Hi, I have a 5GB file to upload in Anaplan using API. The API is working well for smaller files with 500MB data and 25 chunks. But when it comes to the huge file, it gives the below error. Import connector: Error obtaining input stream (caused by: File not found) Is there any limitation on maximum number of chunks to…
8.3.2 REV02 Upload Issue
Hello! The imported data for REV02 repeats each month, I checked all the common issues/how to fix it and I am still stuck. * Header Row: 2 & First Data Row: 3 * Time: YYYYMM * G3 and P2 hierarchy is correct + matches with the import data * model calendar is set for 2020 with a year prior and future. First time posting in…
Power BI - This is how we use it. Part 3: Use Case - Leveraging Power BI Service.
Now that you know the basics of the Power BI connector and how to set it up, let us move to a real use case; Why using Power BI Service could help you to get the most of the Power BI connector? The blocking nature of exports When a user performs an export, the model is blocked from usage (entering or manipulating data).…
Power BI - This is how we use it. Part 2: Setup [Updated March 2022]
[Update: March 2022 - Limit increased to 5GB] In Part 2 of our Power BI - This is How We Use It series, we're diving into how to setup the Power BI connector. Need a refresher on the basics of Power BI? See Part 1. Ready? Let's start. Anaplan export setup Anaplan connector for Power BI supports Export actions to extract…
Move a model from one workspace to other while maintaining full history
Is this possible? If so then how?
Export the Drill Down grid
It would be a great help for the user, if he is able to export/or copy the grid from the drill down, for example if we drill down on the cell in new UX we get all the values that contributes to the calculation, and if the count of the drill down goes over 100 values it gets difficult to analyze the data, neither we can…
Import Shipping Expenses into OTH01 Module error
Hello! I face the problem while importing described below in picture My saved view and the import selections are below Could you please help me to understand what I am doing wrongly? Thank you, Anton
Level 2 - 2.3.91
Good Morning. Please could you give me some pointers? I'm not sure what this error means?
Multiple Imports in same process Using Anaplan Connect
Hi All, I have 50 files in similar format but for different entities and different file names. Now, i only need one process to import these and the same is set up using "entity 1" and works perfect when using dashboard action. Now I created a Anaplan connect import script with 50 different file names & File path's and…
Exam 1 Import
Hello I am having an issue importing
8.5.3
Hello I am running into an error while importing
10.2.4
I am having trouble importing please help
7.2.3
I am having trouble importing data. It keeps giving me this error but I know I have the mapping correct
8.5.2
I am having trouble importing data into REV01. I follow the learning page and map it correctly but some reason it says that my G3 list has no items but I know it does.
4.8.2
4.8.2 is giving me an error saying invalid parent. I mapped it none to E2 department column 3 dept code to parent column 2 code to code column 9 active to e2 employee active column 1 employees to display name please help
visualization problem when exporting as PDF
Hello, I have a page in the new UX, with several dashboard. I want to export the all page in PDF. But some figures don't appear correctly in the PDF file while they appear correctly in Anaplan. I don't know why, it happens here only for the negative figures. Is there a way to avoid this problem ?
4.6.7
I keep getting an error I am not sure what I am doing wrong please help
4.6.4
I am very messed up on my Anaplan Module. When I import the data I follow the example exactly but then I get an error saying Invalid name
11.3.2
I am running into some weird errors while importing
8.5.3
I had a few problems with this one. First I am not sure what to put for the time, then once I imported I got many errors.
4.6.5
It gives an error message when importing saying another row has already been imported with this key and Invalid name
Synchronize filters across tables in Excel add-in
Add ability to synchronize filters across tables in Excel add-in. Working with the Excel add-in and extracting data from different modules, some of the filters across the different extracts overlap. A good example hereof is forecast cycle or specific versions. Currently, we have to change the forecast cycle in each sheet…
Show/hide data labels for end users on a chart card
It could be great if end users can have the choice to show/hide data labels on a chart cards, or as an option for export. we think it's more ergonomic to hide them on a board and display the tooltips. However, this poses a problem when a user wants to export the chart card because he does not have this option.
Excel Add In 3.2 Last Refresh cell
In Excel Addin 3.2, the 'Last Refresh' cell has been moved, adding a new row before the data compared to 3.0. There should be an option to keep the old format. This will allow users to upgrade from 3.0 to 3.2 where they have many formulas referencing data in a row which would be moved.

Importing and Exporting Data

Discussion List