Data Integration

Mapping the products.csv file in level 1 training
Hi, I created a hierarchy of product family and products. I need help with mapping the products.csv file. Please find the screenshots attached.
Regarding Email Notification via Anaplan Connect Script .
Dear Expert , Hope you are doing great! I am looking for your kind advice on Subjected Matter . I am working for Anaplan Connect Script for Import ., where we need to trigger mail to support team in case of any error while importing to Anaplan model . Could you please help me with the details and sample script to write and…
how can I automate or schedule a process with in Anaplan
Hi, I am looking for a functionality about how can I automate or schedule a process with in Anaplan, which transfers data from one model to another model with out clicking manually each time on that process in dashboard?.. I appreciate your help on it. Thanks! Suman
Got struck in 8.5.3 import volume file
While mapping i am a bit confused how to map time dimension to the source and line item mapping .please help me out on . I am attaching screen shot of what i mapped in the import
Anaplan Cerificate
Hi, I have completed my exam with 90% marks, screen shot attached. But the Level 1 certificate link if not available for printing.
New UX and blocking actions
Hi all, I'm starting to implement the new UX to replace some of our existing dashboards and I would like to know if users working on a page are affected by blocking actions (import/export) as it happens in the model. This is one of our biggest challenge (ie: reduce blocking actions) to increase the anaplan adoption in our…
Excel Add-In
I have an excel sheet with multiple connections to Anaplan that run off saved views with filters on the lists I have a problem that when some sheets are refreshed it won’t allow them to be updated because it claims the "dimensions of the view has changed". It then requires you to update the pivoting, even though no…
Importing List Formatted Line Items into List Formatted Line Items (Numbered List)
Hi, I have been getting import errors when trying to import a line item formatted as a numbered list into a different line item formatted as the same numbered list. We import directly from our source into a list formatted line item and the only workaround I've been able to come up with is to make a new line item, make the…
Update Start Time without ALM and Current Month / Week by Automatic Batch
Today, we need to update Start Time in DEV then do an ALM but it can be complicated if we have developments on going. We would like to be able to do it directly in our PROD Model. We would like also to be able to do it automatically by batch/API, same need to update Current Month / Week and all Times Settings etc.
Model Builder 7.2.1 Import Data into Product Details Module
Hi All I have spent considerable amount of time trying to Solve this.. Can Someone please help.
Anaplan Connect copy model to model
Hi, I'm looking for an Anaplan Connect example to copy from Module to Module and Model to Model. Thank you for your help.
Workday Finance Integration
Dear Community, I am a financial analyst at the School of Medicine of a large university. The school successfully implemented Anaplan two years ago and the university implemented Workday Finance last year. We are now preparing to integrate Workday Finance with Anaplan. In addition to the assistance from the university, we…
Error on AnaplanConnect (Linux)
Hello, I'm working on the Linux script of AnaplanConnect. It looks that my program stops at the last line of AnaplanClient.sh Here is AnaplanClient.sh This is the log when I execute the shell file I guess the below part (line 93) of AnaplanClient.sh is the problem because the "echo" on line 90 worked. Does anyone know what…
Error 1020 acesss denied
hi I am seeing this error for last 4 days wheneven I am trying to access this system. But It looks others are continuing their practice. Please let me know whether I am only facing this issue?
Import Rejection Limitation?
Hi Community! One of my clients asked me a question I wasn't sure about. Thought I'd ask here. Using AnaplanConnect does anyone know of a limitation of how many rows can be rejected before the entire action is rejected? I'm not aware of any limit but wanted to see if I missed something. Adding…
One question regarding level 1 - Activity 7.2.3 : Import Data into Employee Details Module
Hello there, I meet one issue when I import data into employee details module for level 1, activity 7.2.3. The result can be seen from screenshot (refer to Result.PNG). Here we can see that Name, Country, Start Date and Leave date columns were not imported at all. The imported report can be seen from screenshot (Import…
Anaplan Integrations
Hi, Requesting help to understand about Azure and Anaplan Integration. Thanks in advance!
8.5.3 Activity: Import Data into Volume Inputs Module
Hello! I have a question - when i created the modules, i deleted Time from dimensions. How to add it back after the module is created? Now I have this But i need to have this Thank you in advance! Anton
Not Able to log in to my Anaplan Workspace
Hi Team, I am not able to login to my Anaplan Workspace. I have attached the image of the error. Please, guide me who's help I can get and from where. Regards
Automatically remap line items in import actions
As a model builder, i would need that in the following conditions : - an import mapping uses manual mappings for line items - the source line item name(s) are changed in the source module, that the manual mapping would be updated automatically or alternatively that we get a blocking mechanism that alerts us upon trying to…
Duplicate line items while importing
I am trying to Import data from a .csv file into an Anaplan module. The line items in the .csv file and in the module are distinct. The module uses a list subset. These line items are in the first column. When I try to Import there are 2 line items that are repeating when I go into the third tab to map individual line…
Importing CSV with Name & Code on file
For one of our models we have an import routine that brings in the below for a variety of reasons it needs to be in this format. As there is both name / code when we go to import it doesn't actually make it because the of there being the name column and they're being used as time. Beyond deleting the name columns prior to…
Anaplan Powerpoint Add-in
Hi, Is there a reason why all the saved views from a deployed version do not show up to add as a connection in the Anaplan PowerPoint Add-In? I am unable to select a module that I want to export to the PowerPoint.
Importing Multiple Rows based on a Quantity Value based Cell?
Hi Everyone, I was wondering if anyone knows or has experience creating duplicates of an Input Row and all of it's associated components based on a quantity line item? For example, if I wanted to create 5 new employees that will have the same salary and reside in the same state and cost center. Is there any techniques that…
Import and Automate Current Date Import to Anaplan Using Python
Connect or Python Summary As a supply chain Anaplan data integration modeler, you might be asked by your business partner to display actuals for elapsed periods and forecasts for unelapsed periods. If you are not using the current period, which must be manually updated by a workspace administer, and you want to automate…
Ability to integrate with CI tools
While Anaplan is great as a simple development platform, it lacks Continuous Integration-related features as a full-fledged development platform. There are many excellent CI tools in the world, and they are very effective in improving development efficiency and maintaining quality. Reference:…
Backup - Archive PY cells
Rather than functioning towards excel for the previous year / excluded year data to save for future. There must be a process which will archive the data as soon as year got changed in TIME settings (with the warning popup) within given model and ready to refer as and when require. [Benefit]: Get rid of multiple models…
Timeout error while CA Certificate Authentication for file Import.
Dear Expert , I am trying to Import Data into Anaplan via Anaplan Connect Script. I am trying to Import with Certificate based authentication in Script but getting time out error as shown below. Could you please help me with the solution to deal with .Is there any ways to see the error log?? Script : @Echo off rem For…
Module Views Not Appearing in Excel Add ini
I created several modules with specific views to be used in Excel via the Excel Add-in. When I open the Excel Add-in 4.0, I can see modules and views but many are ones that I had either deleted or remained in Anaplan. The ones that I created today are not appearing. I am only setting up "read only" connections to the…
Drop down selection lag
Hi all, We have a list that is ~1500 items long. We've published this as a list formatted line item because users like to have the drop-down selection for various reasons, but we've noticed there is ~2-3 seconds of lag before the list opens. We cannot reduce the selection materially with a dependent list and we'd also…

Data Integration

Discussion List