Data Integration

parent-child hierarchy
Hi I am having two lists(A & B) , where list A is parent of list B. In list A there is a list item "Miscellaneous" which code is "MISC" In list B there is a list item "Miscellaneous" where parent is "Miscellaneous" in list A and code is "Miscellaneous" While importing the list items into list B with code, the item…
Warning while loading data into list
Hello, I was trying to load the data into a list from a saved view that has multiple duplicate values. The file has been loaded successfully but with a warning "Another row has already been processed with this key" I want this warning to be removed how can I remove that please help me with this? PFA the screenshot.
List import error : Top level of item
Hi, I want to import List from module. I have this type of List(▲test) , has top level of item. I want to import from this module. But when I tried this, I received error message. This message says that List_All has failed. I tried restrict the level of items and hide top level of item, But I cannot solve it. Do you have…
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…
Allow user to choose time format on exports
When exporting, different scenarios will give you a different format for time. This would be an option within the Export dialog, similar to how you select the date format when importing a file. Specifically, exporting with two dimensions on columns will give you the date format MMM YY. This can cause issues in other…
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
Call Anaplanners France-S2E3-Part 3-Dec 2021
Dans ce call de Dec 2021, les Anaplanners Emmanuel (Newen) et Benjamin (BPCE) témoignent de leur expérience avec la nouvelle fonctionnalité CloudWorks. La vidéo en pièce jointe.
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…
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…
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)…

Data Integration

Discussion List