Data Integration

Import error formula
Hi Members, I am adding formulas to the properties, I am thrown this error. The actual output (mentioned as output in pic) is shown. Please assist me with the correction, that needs to be done. Regards, Sravan.
Import in a numbered list
I am facing this error while importing the values in the numbered list. Can someone please highlight what this error means.
Import Action Error
Hi Anaplanners, Need help with the following error: Can you please let me know how to resolve this..? (See the pictures) Thanks in advance, Ankur Sonthalia.
Anaplan Connect Batch File - Windows Task Scheduler
Hi team, I have Anaplan Connect batch file which runs an Export process that runs perfectly when executed manually (double clicking on the Batch file) but when I run the Batch file through Windows Task Scheduler I receive the below error Any ideas? Thanks
Data Integration From Sharepoint
Hi, We have a scenario where we want to load data files into Anaplan Model. Needs some suggestions. Option 1. - Input data files are available on sharepoint. Do we have a way of data integration from Sharepoint to Anaplan? Option 2. - Place the file on P:/Drive (Network Drive) and run a batch job via schedule to pick the…
Date formatted columns taking more inputs correctly
Issue: When you copy+paste a table into excel, excel's default behavior for "Date" formatted or similarly formatted information changes the data slightly to a "MMM-YY" format from a "MMM YY" format and you are unable to paste back into the model/load as a basic default using upload. Current Solution: 1) Manually re-enter…
Anaplan Excel Add-In ( Reset Format)
Anaplan Excel Add-In 3.3 (Read/Write Query) Ability to reset any formatting as currently any changes made to Excel, Anaplan tries to over lay the difference than try to wipe out changes and replace with default view. Currently, we have the reset option in Dashboard, need the same in Excel.
Numbered list import error
Hello Friends, I was trying to import values into numbered list, I was thrown with this error. Please let me know, where I was wrong. Regards, Sravan.
Need assistance in Formula
Dear Friends, I have some products and each territory allocation. I want my final module to look like M-1 I have attached .csv file (P1) for reference Regards, S K
Anaplan Connect 1.4.3 Export Process Error
Hello, I would like to seek some feedback on this issue that I'm having with Anaplan Connect 1.4.3 Export Process. My hunch is that, maybe it's related to Java -- I have this Java version on my Control Panel: =============================================== Currently, I have the below basic export script: @echo off set…
Fixed Export Destination
Hi Team, Is there a way that I can set a fixed Directory destination for an Export Action? I want to always extract to the same directory so the data can be referenced by an Excel Macro Thanks Mark
Specify a destination for Export
All exports are to the users download directory, is it possible to be able to select a location before downloading. We use some csv downloads as a source of data for an Excel process, and the main spreadsheet looks for a source, if we have it for several users, and the source is in different C:\users\.....download folders,…
Anaplan 4.3 - Export process
Hi Guys, I am using Anaplan 4.3 and I am planning to do an export process I was able to run the import process successfully but I cannot seem to run the export process successfully. I tried to copy the contents on the Anaplan Connect Document but it is different from the sample script in 4.3 folder. Anaplan Document from…
Unable to locate Account Flat List (.csv file) in LEVEL 2 MODEL BUILDING: SPRINT 1 Data Hub Model
While creating DAT03 Historic Volumes module for Sprint 1 - User Story 3, Level 2 Model Building Course, in the Dimensions: Account Flat list is included, but I'm unable to find the Accounts (.csv) file in the training module. Please Help.
Option for Reversing Journal Entry
Hi All, I'm a new member.. I just wanna know about options in reversing journal entry in Anaplan , there are 3 options : 1. Single-sided 2. Reverse next Month 3. Reverse next fiscal year could someone help me to describe the purpose of each options above Thank You and regards
Anaplan Connect - Multiple line Batch file
Hi team, I have a batch file where I want to split it into multiple rows due to being quite long. I looked online & read that if you use ^ at the end of the row it will continue into the next, this is not currently working & wondering if anyone has any ideas?
Import result shows values are adding up from multiple codes
Hi All, This issue is related from yesterday but with a different approach. We created a Gencon Module (transaction Data of client) and the Inventory Module (data from Gencon without the duplicates). Gencon List has duplicate RU text (Transaction Code) which will be imported to Inventory List eliminating the duplicates and…
More than one Numbered list import
Hi All, Please help to make me understand if I import the one numbered list in other numbered list using "CODE" in this case I can not see the parent of my current numbered list, so what should I do to see the data with parent hierarchy in more than one numbered list items. Regards, Vikas Jain
Anaplan Excel AddIn 3.3
Hi All, We have MS Office 365 ProPlus, version below Excel tends to crash on various machines with the AddIn 3.3 installed. A MS Office quick repair tends to resolve crashes but it is a pain to repair every couple of days. Has anyone had the same experienced and what can be done to resolve this? Thanks, Alvin
Is a source model mapping update needed after model name change?
Hey Everyone, I tested this, but want to be 100% sure before making the update. Can someone confirm that the Source Model mapping does not need to be updated if a model name is edited. I see that the existing Source Model's name does not change, but the imports appear to still be running correctly even though the name is…
Numbered List Import in Other Numbered List
**** All, Please guide me to upload numbered list as a list in other numbered list. I am trying to import using code like as given below but unable to import and getting error. Regards, Vikas Jain
Anaplan Connect - Export Process Script
Hi team, I have a Anaplan Connect script to export a process of 1 action (just for test purposes) but I cannot get it to work. Currently receiving the attached error. My script is below Thanks @echo off set AnaplanUser="email:PW" set WorkspaceId="8a81b09e6181d3600161b51408040171" set…
Import from a Staging Module to a numbered list
I am struggling with the following: I have a staging module, dimensioned by Users, where individual users can input some data (CostCode, Currency, Cost Type, Forecast Reference), and once completed, I want to run a process to create a new item in a numbered list (that holds the full set of approved transactions) and then…
How to create two or more import actions into the same module
Lets say i have a source file need to be imported into module. Few of the line items need to be cleared before import for all rows and few others need not. How can we create two import actions by keeping the same target module and same source file. One work around is splitting the module, but am i missing some other way?…
Data break down based on hierarchy
Hi, I'm wondering if there's a way of breaking data down from a top-level? The data file that I get is an import that comes in at level 2 in my hierarchy. I need to then take this data and show it applying some rules in a module uses my lowest level of data (l4). Thank You Hina 🙂
Module to Module Import
Hi , I have a module ,by versions ,Dimension is a number list . Line items - 1. line item 1> Data Type > List 2. line item 2 > Datatype > subset of list 3. line item 3 > Data Type > Subset of list 4. Other number formatted line item I want to import Budget data into forecast . Action is successful but "line item 2 and line…
Source and target line items have different formats and lists when trying to use lookup.
Hi, I am in need of some ideas, on how to solve a problem I am facing. I have these 3 modules (picture below). The module OC Expected Renewals contains numbers. OC Expected Renewals already pulls in data from from the module 4f ACV Calculation, but, now I also need it to pull in target values from 5f Official Customer ACV…
Anaplan Integration with Amazon S3 using Informatica Cloud
Hello Team, We are currently trying to Integrate Anaplan with S3, Here Anaplan is the Source and we need to place files into the S3 Bucket. The metadata tables have been created in the relevant S3 bucket. The requirement is to have the CSV files containing the data from Anaplan and a Manifest file to be placed into the S3…
Model to Model data import from Module and ALM
Hi Experts Building a functionality to deploy to production which requires an automated Model - to - Model module data import through custom scheduling. We use ALM. Both modules, i.e, the source module in one model and the destination module in the other model are being built in DEV. Upon deployment to production, what…
Data Import into a Module using a numbered list
Hi, I would like to understand how an import action works for a mapping on a numbered list. I have an import action set up between 2 modules in 2 different models. Both the modules use the same numbered list. Since the mapping for the numbered list is on name or code the system ends up mapping on the name(Unique number Id)…

Data Integration

Discussion List