Data Integration

Adding items to the production list in the deployed model
Hello, I have question regarding adding items to the production list in the deployed model. User has added a two items to the production list in the 'Deployed' model. I can not see these items it in development model. If I synchronize development and deployment models, will the new items added to the list by the user be…
4.6.5 Model incorrect
Hello! My model is incorrect, I assume it's from incorrect Mapping. Should I delete and re-enter the .CSV file? How is this accomplished? Thank you. I have added my screen shot below.
OpenSSL Windows Installation
NOTE - the downloadable files sourced from OpenSSL.org only work with Linux!!! In order to install on Windows 10, you must with compile the binaries yourself OR find a compiled version already on the web. The instructions below will only talk about finding a website with a compiled version of OpenSSL. Copied directly from…
How to update number with rules when importing
Hi everyone, I am trying to update the number during importing. For example, for 2021, I have actual data from Jan to June and forecast data from July to Dec. the target module is on yearly basic, therefore I would need to combine both actual and forecast for 2021. I want to do the import in two separate action: 1. import…
Export Action in New UX
Is it possible to create an Export Action (Grid view export of the current page) that adjusts to the grid in the UX instead of the grid in the model?
[Start Here] Anaplan APIs in a Nutshell
* What is covered in this article? * What is NOT covered in this article? * What pre-requisites do I need? * Introduction * Authentication * Integration API * Bulk API * Transactional API * CloudWorks API * Application Lifecycle Management (ALM) API * Audit API What is covered in this article? High level description of…
Transactional APIs - Part 3: SQL Query Anaplan data using Transactional API via Data Virtualization
Here’s a sample transcript of conversations I routinely have with our customers who are new to Anaplan platform: * Customer: I have a need to query Anaplan ‘table’ and integrate Anaplan data to my database. Is this possible? * Anaplan: Certainly, using Anaplan Transactional APIs, you can query a saved view and output the…
Cloudworks API integartions
Hi Guys Has anyone implemented a new Cloudworks API ? Here is a scenario I have a process that has 2 imports call it Process A 1- imports list items 2- imports monthly data(measures) related to list items when I am setting up my cloud works integration I am not getting an option for selecting a process just imports actions…
Unable to Load Employees File Properly - Added Parent in Column
Hi Team, I'm at Lesson # 4. (4.8.2 Activity: Import Data into E2 Employees# List). I've uploaded the Employee File and added one extra Column for Parent and for the first 56 Employees I've marked the "Sales" as a Parent and for the Rest 56 Employees I've marked "Production" as a Parent in Parent Column. However, when I…
Anaplan Connect: Convert excel file to csv file in script using Linux environment
Dear Expert, Good day! Would like to seek your inputs with regards to converting a excel file to csv file in the script using Linux environment (Version: SLES 11 SP4). Please advise. Attached file is the excel file to retrieve the current date (sourcexlsFile.xlsx) and csv file as the expected result(destinationcsvfile.csv)…
Issue with import action when importing data using saved view
Hi all, @Misbah I am trying to import data from saved view to module and i have applied some filters on that saved view depends on filter the data getting updated and at some point of time the saved view getting empty because we don't have any data as per filters(as per requirement its working as expected) so when we run…
Python API with Anaplan || Import || Parameters
Hi, While running an import or process through python API , is there a way to check if the import or process needs a file and which type of file is required? In other words, I need to check if the import is a model to model or csv/txt import and in case it uses a file what is the type of the file required. Any help would…
!!! Stuck on 1.5.6.1 Create Historic Volumes Module !!!
Can someone please show me the exact mapping that needs to be done for this exercise? I have tried this several different times over the past several days and I am still stuck on this. 😑 Any help would be greatly appreciated.
DAT02 Shipping Metrics Module
How to import data in to module - DAT02 Shipping Metrics Module? Not sure if I missed this on what but during Sprint 3 I realized there is no data in the module. Thanks
Anaplan + Boomi Integration
Hi Team, I have flow which runs using Boomi. In this flow data being pushed from DB to Anaplan (upload). While running this flow, i'm getting below error message. [1001] cannot parse the JSON response. HTTP Response: Unable to complete the HTTP call due to a communication error with the remote server.…
Export with same formatting
Hi, Is it possible to export with the same formatting as the module / dashboard ? e.g. I have zeros showing as blanks or dashes, but when exported, it's coming up as 0 in the excel. Thanks in advance,
Manual import in the PROD model
HI: We have just created a DEV and PROD model setup. During month end, we need to import data into the PROD model, and we have setup actions to do some of these import, which it does work. However, if I decided NOT to use to action to perform the import but use the manual import function instead, this error appears…
Countries with comma as decimal setting - How do you handle this for importing CSV files?
We just encountered a bit of a hiccup with some of our countries saving and loading csv files to our model. It turns out that countries using comma as the decimal have this issue in Microsoft Excel. When they save as a csv, it uses a semicolon as the separator. Even if you change the separator option in Windows/Excel to a…
Data Export to a customized name instead of default module name
When we export data from Anaplan, sometimes we want to keep a customized name instead of the default module name. If we save an action with our preferred name, although the Export Name is changed, when we click "run" actions, it will still be exported by the default module name. To solve this problem, we can create a…
Run-off activities and innovation
Hi! I'm currently working on a KTLO project within Anaplan and we are looking for new ways to drive more impact to our client and innovate in our run-off activities. For example, we have come up with a model size tracking dashboard in order to do quality checks on how data gets uploaded every day. If we detect a huge…
Reject entire import if there's an error
I am building a model where I need to reject entire import whenever there's any error during import process. As of now them action runs and the module/list is getting populated but the cell which had incorrect value(reason for the error) is not, leaving it blank. This case is not ideal for the customer and they want to…
CloudWorks Integration Limits
Hello, I am very new to data integration and trying to start explore this subject thanks to CloudWorks. On the CloudWorks Anapedia page, it is mentioned that it is only possible to have 25 integrations per Tenant. I am not sure what it does actually mean. Does it mean that one tenant can only use 25 import/export "Actions"…
Actions
How to add the Import Volume Growth Rates Action to the Process.
Model-to-model import in Cloudworks - now available!
Putting Anaplan data integration in the hands of the end users - no additional need for extra IT resource? Yes - Cloudworks model-to-model import is now available! Take a look at the information in the link and any questions, please just contact your BP. Don't forget this will require the Integration Admin role to be set…
Level 2 Sprint 1 Activity 1.3.4
Hello guys, I'm having trouble completing activity 1.3.4. I think that I'm supposed to refer to SYS05 for the region code when importing the parent to SYS06. Below is the capture of my mapping. After running the import, the "Region" line item on SYS06 is still empty. Your tips would be much appreciated. Thank you
Finditem Fails to Detect Valid List Member
Hi Anaplan, I've come across something strange and wanted to ask if anyone has any ideas what is going on or if this is a bug. I am creating a List using a Saved View that contains a list of codes (text) to be added to a list. The import action is set to use code only, and the source codes are imported into both Name and…
Force the API cell read to include Row Header Labels.
When using the data read API, any row dimensions do not have headers. This is an option in the Export tab when using the UI. When trying to process the results via code, I have run into issues a few times where this is a problem. Please consider always including the row label headers or at a minimum provide a setting to…
KTLO activities and innovations within Anaplan
Hi! I'm currently working on a KTLO project within Anaplan and we are looking for new ways to enhance the platform performance and drive more impact to our client. For example, we have come up with a model size tracking dashboard in order to do quality checks on how data gets uploaded every day. If we detect a huge…
Running a process results in The uploaded file is no longer available; please upload the file again
Hello, I am trying to run a process by ID after I upload a file via API. I get the error "The uploaded file is no longer available; please upload the file again" The file uploads and there are no issues, I can see the data in the console. When I upload the file via API, I see the file is set to "This file is not shared…
New features for Bundling Actions.
Are there any new features recently released that can be helpful in streamlining various actions into a process other than the usual way a model builder does it?

Data Integration

Discussion List