Data Integration

7.2.3 Help
How do I get the codes to not show up in this exercise? I know that from the example, commission % should be the last row.
Transactional API tutor
The purpose of this Transactional API tutor script based on Python is to facilitate the learning process of Transactional API Calls using the Anaplan platform. This version contemplates the most common Transactional API calls until November 09, 2020. Download the Python Script file using the file attachment located to the…
Import complete but with failures
I am trying to import the countries list (CSV file) into the G2 Country List. When I ran the import this is the result I receive. Anyone who can guide me?
2.3.9 Level 2 - Sprint 2 Import into DAT03 Historic Volumes using actions
For 2.3.9.1 nothing is populating whenever I run Process 9 Import Data from the Hub. I didn't even get an error as most did, it's just zeros. My data hub numbers are there but nothing happens.
8.5.3 Activity: Import Data into Volume Inputs Module
Hello everyone, I am getting an error when trying to import data into the volume modules. I'm pretty sure I'm doing something wrong with the time source--->target column. (see screenshots attached) Thanks in advance!
Anaplan Addin for Microsoft Word
Users generally need to add commentary around the data retrieved from Anaplan modules. Anaplan Word Addin can fill this gap by providing the capability to extract information from Anaplan. Furthermore, it'll be really useful to extract just one data intersection using some formula like CHOOSE or GETVAL, given the user can…
Anaplan excel add-in 3.4
Hi, My name is Laura and the company I am with started to use Anaplan models recently. I have been using Anaplan excel add-in to pull data for a few weeks and the experience has been great. Starting from yesterday, I was not able to log into that excel add in and got a message: "Top help protect your security, your web…
Import write access to List
Hi, I want to import write access to Lists. I have this type of table. UsersCustomeraxxx1,xxx2bxxx2,xxx3 But the List item is shown by #1,#2 in User setting. How can I import to List? And I want to set the write access to combination List. Now if I set this write access. UsersCustomerProductaxxx1,xxx2yyy1bxxx2yyy2,yyy3 I…
L1MB- 7.2.1 Help Please
I'm very close to the desired result but I cannot figure out what I am doing wrong. This is what I got after mapping:
Workflows
Dear Community, I am using Talent Builder Workspace, where I have access to create My Pages. I am trying to sync up workflow module to actual workflow status defined in lists in My pages, But I am not seeing a provision of imports in the new UX. Any thoughts, how can I resolve it? Thanks
Level 3 sprint 1 - 4.6.4 activity
Hi I have imported the data for 4.6.4 activity however it is showing as numbers instead of product and I have also chosen the display name as display under general list property. Initially display name was there but now after chosing P2 product list as display name , it has gone blank where I am going wrong?
Create/modify existing API Endpoint to lookup model objects by name, code or id.
The current method to find the system id of a model object (list, module, line item, etc) is to pull the entire list down with a get call and then loop through that response checking each member for the name/code/id that you are looking for. I would like to see a new endpoint in which we can pass a name or code and get the…
Set Period as Column in a Module
Hi! I have to create 2 reports, one with year only as column and another one with quarterly as column. I do have the data module with month as column, but that's not the result that I want. Previously I just show the data module and hide every months then show Q/Y only but I don't think that's a good practice, since if…
Ability to include a Line Item in a Line Item Subset via an import process
Currently, the only way to include a Line Item in a Line Item Subset is to manually go into the Line Item Subset and check the Boolean to add it. What I'm proposing is the ability to import into a Line Item Subset's "include Booleans" so that one can include/exclude Line Items from a Line Item Subset based on a Boolean…
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…
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…
Excel Add-In not working with latest version of Excel
Our users are unable to use the Excel Add-In with the latest version of Excel. After logging in, all options are grayed out. Is anyone else experiencing this issue? This is also using the latest version of the add-in:
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…
Deprecation of Excel Add-in Series 3
Hi, Is there a deprecation date for Series 3 of Excel Add-in? Thanks, Alvin
[Start Here] SCIM - The Basics
Are you using Central Identity Management (CIM) and want to connect Anaplan directly to your Identity Management System (IDMS)? Are you facing challenges with a Security audit? Would you like to add Anaplan to your corporate User Provisioning process? If any of the above questions describe even a part of your Anaplan…
Data Integration
Suppose any clients wants our view to automate integration .Which platform is good to start like mulesoft,dell bhoomi ,informatica or any ETL tools or REST API. Please suggest some pre-requisites or some basic question/information which we can ask to the clients.
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)…
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.…
Excel Add-in v4.x
Hi, Prior to v4, the was an update.exe file that automatically asks whether you want to upgrade to a new version. Can I confirm that this is no longer in v4 series as the upgrade is via the Anaplan ribbon? Thanks, Alvin
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?

Upcoming Events

Save the Date: Anaplan Workflow - Next Steps in 2026
We’re continuing the conversation! Following the success of our first Anaplan Workflow event, we’re bringing you a deeper look at what’s next. Join us in March as we expand on the insights shared in the previous session and explore how Workflow continues to evolve to support planning collaboration and process efficiency.…
Community Challenge Recap: Annual rollover best practices
In this ACE Spotlight event, we will cover the most effective techniques for making your annual rollovers seamless and repeatable, based on the solutions from our latest Community Q&A Challenge.

Data Integration

Discussion List