Data Integration

Delta load to Anaplan with informatica cloud(hyper connect)
Is there a provision to load only the change or new data instead of importing the full file to an Anaplan module in using Anaplan/Informatica Hyperconnect?
Anaplan with google cloud/ Apigee
Hi Anaplanners! I was curious to know if anyone has any exposure on building Anaplan models integrated with Google cloud/Apigee. I was wondering to know if there is any native connector between Anaplan and google cloud /apigee. If there is not any connector, does anyone know what should I do in this case? Thank you!
Fail a process if any subsidiary action contains errors
I would like the option to fail an entire process if one or more actions within that process contains errors. For example, if any errors exist when updating a list, I do not want the next import to run that loads properties of that list into a module.
Level 2 badge
Hi I completed my level 2 on 23/02/2021( attaching the certificate for proof) still I haven't received my badge. When can I expect the badge to get issued? @Misbah
Anaplan Connect Error
Hi All, I have an issue while uploading the file via Anaplan connect. Following is a snippet of the error. > > _2021-02-26 17:35:07 INFO [c.a.client.Service :83 ] 1532 |-- > Initializing Service..._ > _2021-02-26 17:35:07 INFO [a.BasicAuthenticator:26 ] 1532 |-- > Authenticating via Basic..._ > _2021-02-26 17:35:11 INFO…
Level1 Model Building: Import into DAT01 PL Actual and Budget module failed
Hi All, I am facing issue on importing data into P&L Actual and Budget Module For your information, i have mapped time as Period (YYYYMM) Import into DAT01 P&L Actual and Budget module failed: The column headers in the file you are attempting to import do not match the import definition. Have attached mapping and error…
Scheduling refresh in Power BI
I am using Anaplan Connector for Power BI to export data from Anaplan to Power BI, instead of manually refreshing, is there a way to schedule the refresh in Power BI ?
Import failure based on module cell count?
I have just submitted this to Anaplan support, but wanted to run it by the Hive Mind. Any insight into what's going on here would be appreciated. I will update this thread with any answer I receive from Anaplan support! We had a very puzzling issue last week that prevented loading of data. We resolved the issue, but the…
Jumbled Process
Hi All, I have a process named "Import From Data lake SP SG FOM" where lots of actions were placed. For instance, My actions in the following order . Today date.csv and import stock Expiry DC-9205,9209,9207 are to be uploaded files. When I publish the process in the dashboard and click to upload the files, the upload…
Level 1 Model Building: Import data to SYS06 Product Details module
In Module 7 of Level 1 Model building, we are asked to import product data into the Product Details module and map to the source. However, my mapping does not seem to be accurate, and I cannot figure out the issue. I've attached screenshots of what my mapping looks like, as well as what it results in. Any and all help…
level 2 Sprint 2.3.9.1 Import data into DAT03 Historic Volumes module
Hi Community, I am getting an error when i am running process to import historic volumes, beginning inventory and shipping metrics from my data hub model. i think it is due to list used in both modules. In datahub module according to instructions i have used " SKU flat list" and in supply chain module "P3 SKU" list is…
Excel Add-in options
When we produce monthly cost report, we need to keep apart every department because are confidential data (every department can't know the other departments expenses). With the previous tool (BPC) we could exclude empty/zero cells, select the single department and refresh data every month: was not waste of time. Now, if…
How to Edit Status setting in Informatica cloud under Monitor tab
My teammate can see a resume option when she hovers over the status under all jobs in the Informatica cloud. I don't want to restart my job but unfortunately, I cannot see that option.
Anaplan way training not able to access
Hi, I am trying to do Anaplan way course and I am on Lesson 5 . I have completed the lesson and knowledge check some 5 times but still the next lesson is not getting activated. please help. it shows 95 percent complete. only knowledge check left. even i have done the test 10 times. it remain same as 95 percent. what could…
Pull the mapping for Imports and source for each model in a tenant
Currently, the only way to extract the information for Import and source mapping is from individual model through the Anaplan interface. These mappings are very useful to track how the data flows across different models and files. To be able to identify how the data flows using this metadata is going to help eliminate a…
Anaplan Connect - Java Keystore Authentication Failure
Hi Everyone, I am currently trying to get past the authentication stage of Anaplan connect using a batch file with java keystore. However I am unable to get past the authentication stage, below is the screenshot of the error: Was wondering if it was an error on the or my batch file (and not the authentication details) The…
Export data from Power BI to Anaplan using anaplan connector
Is it possible to import data from Power BI to anaplan using the anaplan connector in Power BI or is there some other way?
Does EMAIL ADDRESS Parameter is Mandatory to pass while Generation of CSR via Key store?
Dear Team , We are looking for CA from Authority while working on Script for Anaplan Connect. My Question here is Does we Need to Pass Email Address as as command/Parameter while generation CSR via key store? Or email address is option , even if CSR does not have Email Address details will not be a problem to get…
Error anaplan connect
Hi team, I have problem with anaplan connect 1.4, sometimes i get error 2020-07-13 09:21:25 INFO 88 |-- Initializing Service... 2020-07-13 09:21:25 INFO 88 |-- Authenticating via Basic... 2020-07-13 09:21:47 INFO 88 |-- Retrying API request: Attempt (1) 2020-07-13 09:21:50 INFO 88 |-- Retrying API request: Attempt (2)…
Anaplan connect issue
Hi, I am trying to execute import action using anaplan connect from windows server. When I am executing batch file it throwing error - "workspace not found for workspace Id XXXXX. Same batch file running fine on my local machine. Please suggest. Regards, Amit
Regarding Anaplan Connect Whitelisting - API/Autho Services.
Dear Team , I am working with Anaplan Connect to Import/Export files from server. Due to Security policy my client is not willing to Whitelist below both services. api.anaplan.com & auth.anaplan.com . where as they are suggesting to use proxy and port in my Script . Could you please help and suggest me on this since i am…
Implementation Process for Digi Cert received Certificate.
Dear Expert , I would be highly thankful to you if you could help me with the installation process of CA based Authentication in Anaplan Connect. For your information , I have received 3 different files from Vendor . 2 as .CRT and 1 as .CER format file which is named as below. 1. SHA256root .cer 2. Intermediate.crt 3…
Only allow import before certain date
Hi, Can I create logic that only allows end users to perform an Import Action if the today's date has not passed the deadline? Best regards, Johan
Anaplan Connect Import, ERROR: Cannot determine Java version.
Hi! This is my first time using Anaplan connect. I am running a basic authentication to execute an import list action on Windows. Below is my script: @echo off rem This example loads a source text file and runs an Anaplan import into a module. rem For details of how to configure this script see doc\Anaplan Connect User…
Regarding Anaplan Connect Import Scripting
Dear Team , I am using Anaplan Connect on Windows server where i need to write Script for Import/export files from Windows server to Anaplan Application . My Question he as below : Let say I have 1 folder in Windows server named Import Files where ETL jobs keep the file to load into Anaplan System . So once that file is…
Solved! How to Get and Automate the System Date into Anaplan Using Python
Anaplan Community!! Hey, I just published a KT article in the Retail Anaplan Group that shows step by step how to get and automate the import of the system date into Anaplan using Python. Hope you like it! Cheers!
Import to List from Module
Hello Community! Hope you are all doing great. I am trying to import from a Module to a List, but it is not working for me. My LIST is called "Machines by Mill", and the headers in there are the name, the PARENT, the CODE and WORKCENTER: I created a module with those names within LINE ITEMS, and as input, the item that I…
Sample batch file for process in Anaplan Connect
Hi Community, Has anyone got any sample batch files to hand for a process that includes a number of imports? Many thanks, Callum
Updating data trough Excel Add in
Hi all, i have an urgent question: i'm actually trying to import a monthly cost report trough excel add in, the goal is to have a report which I can refresh every month. The problem is that I would like to exclude all the empty cells of the module/view, so during the import trough add in I can see only the full cells. Is…
Ability to avoid refreshing deleted rows/columns in Excel
Description of the enhancement required: option to not refresh the full view in Excel add-in An example of the enhancement: If you delete a column or row, don’t re-add that row/column when refreshing A story for why you want the enhancement (How would it help your business process?): custom view’s can be created in Excel…

Data Integration

Discussion List