Data Integration

File/Data Encryption During Export using Informatica
Need guidance around how to encrypt data for an Anaplan export using IICS (Informatica). As soon as there is an data export and before it hits target (FTP location or Cloud service), data in transit has to be in encrypted status. So I guess, the question is - how do I encrypt the data as soon as export action runs. I was…
Production Adjustments in ICM model - looking for ideas
Context: * We have an ICM (Incentive Compensation Management) model with a DAT03 module that is an upload (from our data hub > SQL query) of all the monthly transactions we need to pay IC on. It includes all the production amounts, sales reps, product type and many other dimensions. * Our module also applies production…
Selective access for lists from dashboards.
I am trying to enable the user to give selective access on a list via dashboard. I published the list to the dashboard and can clearly see the "Read" and "Write" columns on the dashboards, however if I save the dashboard and close and reopen it , the columns of "Read" and "Write" are not visible. Can somebody explain what…
Conditional Boolean to control Integration
I apologise in advance if this idea has already been posted🙂 There should be a possibility to trigger/limit an integration based on a boolean status. As we currently have the function on the UX where we are able to set up a "conditional Boolean" to run a process this functionality would be useful with integrations as well.…
Filters in List Grid View
Same as in modules, there should be an option to add filters in Lists grid view. This will help to filter list data view based on properties or subsets. Currently, we have to export list data in excel to do any data analysis based on properties and subsets.
Repeated 'Illegal Argument' ERROR when pushing data through to a DataHub
I've been having an issue pushing large quantities of transactional data from an externally uploaded .csv file into a data module within a DataHub model. The .csv file is generated directly from an internal operational data store that queries data by client. I can populate its referential list with no issues which is the…
Drag and Drop functionnality (Line Items - Modules)
Hello It's will be helpful to have the drag and drop functionnality directly on each line item in order to rearrange easily on purpose Regards Patrick
Avoid creating empty export files
I have an export action triggered by Anaplan connect (export of POs) So a file is created and placed in a folder, the ERP system then read from this file and creates POs in the ERP system. This action runnes quite often and often the exported file is empty (only headers) so there is actually nothing to export. I would then…
Data loss issue
I've encountered a strange issue in our model. To give you the context - We run a scheduled process through REST API to copy data from one version to another version. We tried running this using cloudworks, it did not work (I'm assuming because once of the action in the process has filter based on User Write Access). So we…
Drag and Drop Actions (Process - Imports - Exports - Others)
Hello It's will be helpful to have drag and drop functionnality in the Actions page in order to rearrange them inside their respective bloc (Process, Import, Export or Other Actions) so it will be easier to group them if need include actions into a process using the drag an drop dunctionality Regards, Patrick
Question: Examples of Web Apps using OAuth2.0 Authorization Code Grant
Hi API Developers Has anyone implemented Anaplan OAuth using Authentication Code Grant for use cases other than a single user integration flow. For example, a web app that allows users to consume Anaplan data by authenticating the user through OAuth via a browser flow? Or, do you have any plans to create a solution like…
Model Schema Export, My model is rather large
Which is best way to make a soft-copy file of the model schema as generated by Anaplan?
Preview Window before creating Revision Tag (Preview of the result in the target environment)
It would be useful to have a preview window of the results of development done in a model before creating a revision tag (for synchronization). This involves setting up the ALM. This mode exists in the new UX in page builder mode Thank you Patrick
NUX Forms: Exception handling when duplicate code entered
When using forms to add to a list (where the code can be entered), users can accidently re-enter an existing code which triggers a model roll back, as it's considered a duplicate. There's also no notification the model is rolling back so it looks like the app is spinning its wheels. This leads to confusion and potentially…
Powerpoint Text Help
Greetings, Is there a way other than Copy and paste each word (text), to create 10 separate slides of a 10-word sentence on PPT using a command or Plugin? (Task - 700 to an 800-word essay has to be separated into slides. One word per slide.)
1.5.6.2 Import Data into Historic Volumes Module | Invalid line item identifier
Hello All, Can someone help me to point where this is going wrong. I am getting Import complete but with failures : Invalid line item identifier please see the screen shots for details. Thank you
Size limit import data Using Talend ETL & API
Hi all, i need to load a lot of data in transaction level AP & AR. For now, i still don't have any idea how big. just wondering about : 1. is there any size limitation when import data using API? 2. Is there any timeout when import data using API? Thanks a lot
Outlook Email to Create Item in Anaplan
It would be cool if we could take an email and create an item in Anaplan. If we use anaplan for tracking defects/bugs and enhancements but users submit an item via email, having an item created could be a nice feature. I have done this in the past with integrating microsoft forms with Azure DevOps but that took workflow…
Increase number of integrations for Cloudworks
Increase the limit for Cloudworks integrations & integration flows from 500 to 1000.
Be able to have multiple imports of saved view to module
As part of the model cycle have an import which takes from model A and imports to model B but for the first run it's only half the line items and then for the second run it's the whole set. Essentially the second half of metrics are in flux and the end users don't want them updated. What we have to do is go in and adjust…
Automatically generate Keys for Importing fact data into Data Hub module
Importing fact data into "flat modules" in a Data Hub is challenging when your data source is unable to provide a single unique Key to act as a List Item. That work ends up taking place between the extracted data and the import into Anaplan and oftentimes involves concatenating Key columns into a single column, sometimes…
Export User Access with Display Names of Selective Access Lists (if Numbered)
If in the system Selective Access is set to Numbered List, when you export User Access list, all items are shown as #NAME instead of display name. Currently, on quarter basis we are preparing current user access lists to provide to responsible people. An it takes a lot of time to manually replace #NAMES with Display one,…
Anaplan Api call via postman
Hi, I am trying to call Anaplan API via postman. I tried Authenicate with https://auth.anaplan.com/token/authenticate and generated token Then i tried calling imports pasting the token through the url https://api.anaplan.com/1/0/workspaces/[workspace id]/models/[model id]/imports and its retrieving the data. But i am not…
Publish Postman API Collections for various Anaplan API Categories
It would be handy if the various API documentations outlined in is accompanied with its corresponding Postman collection like the one below . Currently I'm unable to find the Postman collections for ALM API and CloudWorks APLI
CloudWorks - Page Readability
Hi everyone, Is it only me or does the CloudWorks Page - Integration & Processes Page in particular - lack in terms of readability in your opinion? What I mean by that is, there are presumably cases where users have lots and lots of Integrations & Processes listed one after another and it's pretty cumbersome to manage them…
Export Model Map to PDF/Excel
Capability to Export Model Map from Contents page to PDF/Excel.
Run Action Concurrency
Hi, I want to check the action concurrency. If several users run the action, Action which first user run will run? The second user's will not run?
Using Python 3 with the Anaplan API
* Getting Started * Authentication * Getting the Information Needed for Each Script * Uploads * Multiple Chunk Uploads * Single Chunk Upload * Imports * Exports * Actions * Processes * Downloading a File * Deleting a File * Standalone Requests Code and Their Required Headers * Get Workspaces List * Get Models List * Get…
Anaplan API | Add list items to a numbered list by combination of properties as a unique identifier
Dears, I am currently writing an API call to add a list item to a numbered list. Here, i would like to use a combination of properties as a unique identifier, not the regular code. Which has to be specified in the request body. Unfortunately, I haven't found any guidance in the documentation on how to do that (). Does…
Saved Export Actions
For saved exports from Anaplan, how does the export remember what to export? I'm used to creating a saved view to represent the export, however, if a saved view is not created and potentially certain list members and/or line items were hidden/visible when the export was created, is that what Anaplan remembers for that…

Data Integration

Discussion List