Importing and Exporting Data

Anaplan SSL wrong version number issue in Import action
Hello Team, I have Pyhton code that connects to Anaplan using API 2.0 and import data.I am using proxy server to connect. This was working fine until yesterday we found below error from my application. Error occurred:- Exception method name:- auth_request exception details:- HTTPSConnectionPool(host='auth.anaplan.com',…
Level1 7.2.3 Activity mport Data into Employee Details Module
I'm processing Level1 training and I can't understand how to deal with "7.2.3 Activity mport Data into Employee Details Module" . Could you tell me how to set the Mapping tab (Source) also #E2 Employees Tab ?
Formula to get a Line Item formatted as a List based on a Trimmed data field
I am importing data with a field that has the names trimmed from a list. What formula can I use so that that rediscovered name corresponds to the name of the list in Anaplan?. Let me try to show this example: Data TXT File: Crititcal Line Abrev Field:AllocCrediDirecFixed Anaplan List: Critical Line List:AllocationsCredit…
Microsoft Excel Add-in 4.2 Issue on Data in Excel
Hello, I hope you're doing well... I just have a quick question on Anaplan MS Excel Add-in 4.2. Situation: 1. In Anaplan, I set up a workflow such that, when the data is submitted, the data will turn from blue to black, which means cannot be edited anymore. 2. When I set up a connection in Excel Add-in, those cells that…
Anaplan connect Model to Model import
Hello All, I am looking at the Anaplan Connect documentation and I see the section Model-to-Model import which mentions the option to import from list and module. How about importing from SAVED VIEW. In cases where we want to import only certain items via view, how would we use Anaplan Connect to import. Also, the document…
Creating a new model - issue
I got stuck at one point in building a new module and I thought maybe someone could give me some advice. 1. I built an INPUT MODULE that has a lot of line items (about 30) - some of them are filled uploaded file and some are calculated based on other line items. For this INPUT MODULE data is loaded for two version…
Anaplan API: Basic Authentication failed for Linux
Dear Expert, Good day! Would like to seek your insights with regards to Process script issue using Linux interface as below. Thank you in advance. Check list done as below but still the same error “Anaplan API: Basic Authentication failed” * Anaplan access checked (able to access the workspace and model) and password…
Import from Excel using Cloudworks
Hi, Is it possible to import data from an excel sheet placed in my desktop to Anaplan using cloudworks? Thanks
Level 2 - Sprint 1 - Data hub - 1.3.10.4 Check Your Work - not getting data as expected
What is expected: 1.3.10.4 Check Your Work After completing the import processes, the G3 Location list in your Data Hub model should look like this example: but what i get is: 😞 Below are from other lists: G1 Region: G2 Country: i feel i missed something in the G2 Country, but please check the above screen shots and advice…
Sprint 1 user story 4. I am stuk at 1.7.3.2 Import into SYS08 SKU Details module
I am stuck at 17.3.2 Import into SY08 SKU details. I am importing SKU details saved view from Data Hub model. However I am not able to do the target mapping. I have attached the screen shots. COuld not move further due to this. It would be great if someone point out where I am going wrong.
Can I export a saved view?
Can I export a saved view or will it export everything?
Import Issues
Hello all, I am having some issues in importing the data for Level 1 Lesson 10.2.2. I have made the module correctly but when it comes time to import the data I keep getting the following error messages. Is my matching correct or have I made a mistake somewhere? I have attached screenshots below. Any assistance is greatly…
Importing data with two dimensions?
I'm playing around with Anaplan to learn better how it works. I want to import population data (see below). The data in the csv has country on the rows, years along the columns and the respective population it the cells. In Anaplan, I have created a list for the countries (with the codes) and I created another list for the…
Extract User details from Model - Automation
Hi Anaplanners, We got a requirement where client wants to automate a daily report extract from the Anaplan to the source system for the details of Users and the Role in anaplan model. Assuming no ETL is been setup, what could be the best possible way of implementing this. Is any batch script or Postman helpful in…
New Source Files should be accessible by all Admins as default
When we are creating new data feeds to Anaplan via API, it will set the new file on private as default, which you can't change afterwards anymore. In our case the file would be created by our 'AnaplanCoE' user we are using for the API. It would be great if you can change the file that it will be the default for everyone or…
Dynamic User List
Hey, I am creating a dynamic user list, wherein I need users with a specific designation (A). Now i created a module, applied a filter and filtered all users with designation A which is populated into my list 'Users with A' however when a user who is updated into the list ('Users with A') but later is changed from…
Issue with swapped data in 12.4.4 Activity: Create Saved View for Profit & Loss Report
Hi there - I've got a question for activity 12.4.4 It appears that my data is swapped in the actual and budget columns. Being new to Anaplan, does anyone know how to untangle this? How can I correct the data? Any step by step instructions would be appreciated. Thank you!
Integration of Data from Anaplan to Power BI.
Hello All , My source is Anaplan data , i extract the data in CSV and do run a R-script for unpivoting the columns and then connect the updated CSV file to Power BI. Now , i have requirement to connect the data directly from Anaplan to Power BI. Any Suggestions ? Thanks for the help in Advance. 😄
Anaplan Connect 2.0 - Approaches to Anaplan integration using On-Prem integration platforms
This article is the last one on our series about Anaplan Connect 2.0. To refresh your memory on Part 1 & 2, go here and there. There are several On-Prem integration platforms that are popular amongst Anaplan customers. These include Informatica Power Center, IBM InfoSphere DataStage, and Talend Studio. However, none of…
Anaplan Connect 2.0 - Advanced Scripts
This article is the 2nd part of our 3-blogs series on Anaplan Connect 2.0. If you missed part 1, go here. Disclaimer:The scripts and examples in this article have been fully tested by our team, but they are not supported by Anaplan; if you have any issue, please use the comments below. Target Audience: Integration…
11.3.2 Mapping Issue
Hi - I am stuck on 11.3.2. It appears there is a mapping issue with location (see screenshot). When I try to manually map the locations to the regions, it will only allow me to select one city. That's problematic because there are multiple cities that belong to a region. Can anyone offer me advice? Everything else is…
Search Option
Hello Modeler's I would like suggest one enhancement or feature, this is the thing I feel like anaplan should have search option. As we know most of us not like to scroll a lot for what we need. I found this while doing import action from anaplan with connect to anaplan models.There will be a lot of saved views we have and…
Level 1: 8.5.3 Activity- Unable to import data in Volumes module
Hi Guys, I am unable to load data in Volumes. The issue is that file is loading sum of all the columns into single month. e.g. in Jan'19, data for Jan'19 from file should load, but it is first summing up data from Jan'19 till Dec'21 and then adding that number in Jan'19. Same process repeats for all months. Can you please…
Phone Cost for Sales Department
I have been trying to figure out how to solve this issue that keeps popping up when I enter this formula: IF Employed? THEN 'EMP03 Employee Drivers By Role'.Phone Allowance[LOOKUP: 'SYS08 Employee Details'.Department, LOOKUP: 'SYS08 Employee Details'.Role] ELSE 0 I know it is something with the Roles list and the…
Level 2 Conclusion: INV05 Import to OTH01
Hello, I am trying to import the INV05 file to the OTH01 module, but I am getting an error message in regards to the fact that the INV05 export file has half-year time periods (ex: FY20H1). I've tried to use the Show function to hide them and the Months Only? filter as a way around it, but no luck.
Auth for Rest API issues
Hello, I have recently started to recieve the error "The underlying connection was closed: An unexpected error occurred on a send." when trying to authenticate with the REST Api. This code worked fine last week and now it's failing. I am using RestSharp/C#, can anyone see what my issue is? I don't believe that I have…
Level 1 Training: Unable to load data in Employees module
Hi Guys, I am following level 1 training, but at the step 7.2.3 Activity: Import Data into Employee Details Module, I am unable to load data as it is shown in the snapshots. The issue is E2 Employees# list is a numbered list, so getting confused on its mapping with the target module. Second thing is the source file has…
Customized exports from UX Page
Hello, I was wondering if it is possible to customize the export of UX Page in PDF format for the end user. What do I mean by customize? Now we have created a UX Page, from which data export in PDF format is generated (it contains tables, charts that are on this page) - the data for the corresponding page selector is…
More than one value for non-numeric cell - Boolean
Hello, I have a input module published to a dashboard that allows planners to enter new headcount for their departments (Planner Dashboard TBH Input - DB View). I import this data into another module that doesn't have the department dimension (To-Be-Hired - Input). The purpose of the dashboard module is to prevent planners…
Level 2 conclusion INV01 export view
I have created an export view from my INV01 module. I've been able to deselect the hierarchy for the products but when I try to deselect levels for time the option is greyed out. I've tried pivoting the view and that still doesn't work. The export looks like the example except for the monthly summary. Can someone help me…

Importing and Exporting Data

Discussion List