Data Integration

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…
"Search" box for the list when list is assigned as a line item format
As a model builder, I would prefer to have a "search" box to look for a list name when I assign a list as a line item format. Currently, I can only scroll to look for a list name. "Search" box is more efficient than scrolling when the list is quite extended . What do you think?
Informatica Issue
There's an issue while running a Process in Anaplan from IICS. When a certain process is run from IICS instead of picking the new source file it's picking up the Native file and after 48 hours it throws an error "localMessageText=The uploaded file is no longer available; please upload the file again, occurrences=0,…
Anaplan Connect Script
Hello there, I am trying to run a script of process but I get this type of error,anyone to help me.
Differentiate if you are Importing into a Module or a List on the Actions system view
Create a new naming convention based off of the action being either an import to a Module or a List. EG. The L8 and 9 and 4th row would have List in the action section and the 3rd row would have Module in the name. This would be used to quickly reference things and make it easier to do research.
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…
PlanIQ Error Messages and Warnings
Users may encounter error and warning messages in PlanIQ. The table below includes descriptions of the messages and details what should be done in order to address them, where applicable. Message types: * Errors will fail the relevant PlanIQ step. Users will have to follow the instructions in order to avoid the errors. *…
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…
MAILTO functionality trouble shoot
Hey Team, I am facing this issue on MAILTO. I tried getting it in two ways: - Option 1: - Used MAILTO functionality MAILTO(u, v, w, x, y, z) Result from triggering this option from the backend and frontend (NEW UX) has led to an error where the line breaker (%0A%0A) inserted in the body of the mail does not function.…
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.
Google Sheet Addin: Remove leading spaces from Lists items
Our primary purpose for pulling data from Anaplan into Google Sheets is to use it as a data source. This purpose is made significantly more difficult by the formatting of list items brought in through the add in. Specifically, lists are formatted with leading spaces as you can see by the " Bookings" member in the…
Add Wildcard Functionality to Anaplan Connect Scripts
When working with the latest updates to Anaplan Connect I noticed a few of the scripts that require specific List IDs would be more effective if there was a wildcard option. This would allow users to pull every list from a model and all the related properties.
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…
Actuals load time
Can anyone share how long it would take to load ~20M records of actuals into Anaplan ?
[Start Here] Transactional APIs – Part 1: The Basics
Welcome! We’re so glad you’re here. We’re shining the spotlight on Anaplan's Transactional APIs and we’ve crafted this blog post to cover the basics like what it is, who is it for, and a high level overview of some use cases for them. Let’s get right to it! What are Anaplan Transactional APIs? Data integration is a key…
Dynamic target version for import to module
Hi, I would like to know if somebody is out there to help me with a problem 🙂 Each month we make a Sales proposal in our source module (in the version Plan Proposal). After approval of the proposal, the values of the plan proposal should be copied to a different target module. We need to copy the values starting from the…
Pasting Multi-Line Cells from Anaplan to Excel
I'm experiencing an issue where copying multi-line cells from a default module in Anaplan does not properly paste into Excel. In the attached image, I'm copying three rows from Anaplan to paste into Excel. Instead of pasting 3 rows, the second line within each cell of the "Admin Comment" column is shifted down and to the…
Exporting summary calculations from Anaplan to Tableau
Hi I have an Anaplan model whose data I'd like to see in Tableau. A lot of the line items that I want to see are ratios, and in my Anaplan model they are recalculated at summary levels. e.g. * North: 25% * South: 15% * West: 30% * East: 45% * Total Company: 29% (not 115%!) I've read the documentation here and it advises…
Informatica Import from file via Process
Is it possible to run an Anaplan process from Informatica in one Informatica step with the standard data import process? Or do you have to call each action individually in Informatica and set up the sequential ordering (A then B) in Informatica? Process: Step A = Import into list from file (builds Anaplan code from UID)…

Data Integration

Discussion List