Importing and Exporting Data

PowerQuery Get Data Connection to Anaplan
Could we please have the ability to Get Data from Anaplan in Excel Power Query (not Power BI which already exists).
On-demand event based triggers
Is there a recommended way to utilize "callbacks" or "webhooks" with Anaplan? I have a use case where Anaplan needs to update Salesforce in real-time via an event based trigger. Use case summary: End-user inputs data into a dashboard, then clicks a process button to "submit" the data to an export ready saved view. The…
Informatica to run process
Hi all, I want to run an Anaplan process from Informatica. How can I do it? I do not know what to put as source in the mapping and then the fields mapping as I just want to trigger the process, there's nothing like a source or target here. Thanks
Set the delimiter for CSV Exports
The European format for CSV file is a semi colon delimiter and a comma decimal point. The current behaviour is some European users seem to get an export in this format even though it is not supported in anaplan. The windows/browser formatting seems to take over while other users get the more usual comma delimited file.…
Referencing line item of module into list
Hello Friends, I use the import from module functionality to update the list from a module line item. However since its a manual process and the list wont get updated for any changes in the line item of module unless i again start the import process, is there any way wherein i can reference the line item of module in the…
Anaplan-Excel Power Query Connector
Currently, Anaplan supports connecting to Power BI via the Microsoft Power Query function * https://help.anaplan.com/e1cdf0b7-631f-4cd6-b4df-a5e0927e1ef8-Anaplan-Connector-Power-BI-Desktop * https://learn.microsoft.com/en-us/power-query/connectors/anaplan It would be extremely useful if Anaplan supported connecting to the…
Level 1 lesson 8.5.3 Volume Input modules
I am unable to recognize what's wrong is going on, have change the pivot also, but then also error is there. Can anyone help me finding out what am i doing wrong in this?
Check Import Source - CSV File
User Suggested Feature Check import source of a csv file, to check who uploaded the file. Currently the option to check is through model history but if there was a way to check import source originally (user) would be useful feature.
Reset a line item
Hello all, I do not find the corresponding course, but during training for MB certification, it was said that the best practice to reset values of a line item (numeric or boolean for example) was to create a line item with no data as format, and to import this line item into the first one. I would like to reset a user…
Run Process 9 Import Data from the Hub ---
Hi Everyone , While running the process 9 import data from the hub , Am getting error , Snip attached
Process or Action runtime column within Anaplan
Team, It would be nice to have Process/Action "end time" captured within the Anaplan system. Currently, determining "run-time" is a manual process unless we use integration such as Anaplan connect or other APIs. There are several benefits of having this in the system, the one I would find most useful here is while setting…
OEG Best Practice: Import action management best practices
An import action section can quickly become disorganized, making ongoing management challenging. Learn why this happens and explore steps to take to prevent this from occurring. Import action section: why does it become disorganized? Anaplan saves every import action that you perform, no matter what. For a new build, the…
Data integration - Members are not added into numbered list during import with Cloudworks
Hi all, I need to import data from view and I have to import all records from differents views so I am using numbered list for the import. The process is working well when I launched the process with my user, all members are correctly added but not with Cloudworks 🤔 As you can guess, I want to schedule the update and I…
Connect Anaplan from Databricks
Hi Team, I need to copy my Delta Tables from Databricks to Anaplan. Can someone provide details/script on how can I achieve this task as there are not much open source details available to achieve this.
import file error
Hi Anaplan Community, Below is a screenshot of the error I receive every time when I try to run a process with and excel file upload. what is more concerning is, if the same file has been uploaded by different user then system works fine? Please let me know how to tackle this issue.
Display an action's Start Date and Time (UTC) on a page for the end user to view
Are there plans to allow the Start Date and Time (UTC) of an action to be forward facing to end users? This could potentially be shown as a tooltip where actions are published on to the page.
Anaplan SCIM APIs in Postman
WHAT IS SCIM? System for Cross-domain Identity Management, is a REST and JSON-based protocol open standard created in 2011 that allows companies to securely automate the exchange of user identity data between an identity provider, such as OKTA or Azure Active Directory, and an enterprise SaaS application, such as Anaplan…
Incorrect chunk counts using API
We are getting incorrect chunk counts using API https://api.anaplan.com/2/0/workspaces/{workspaceID}/models/{modelID}/files We are trying to export ~1GB file from Anaplan production model, which is ~100 chunks. But from last week, we are getting random chunk counts for all export processes across all models (incomplete…
Perform Data insertion in Anaplan Module and List through API
I have working on a integartion where i need to push data from a Asp.Net webform to Anaplan Model and List. To perform such action i am using Anaplan API's from the Anaplan suggested method of import: https://community.anaplan.com/t5/How-To/RESTful-API-How-To/ta-p/33579 While running api i am unable to update data , every…
Module 1; unable to import csv files missing csv file.
Hi, I'm not able to import the csv file into workspace ( example Products.csv). Error message displayed: he uploaded file is no longer available; please upload the file again. Can you please let me know where I should find the files? Thank you, Ana Maria
8.6.4 Activity: Add Formulas to Margin Calculation Module
Need Help.. stuck here.. can't go beyond this as the initials shown is 0 even after rechecking several times. All import also seems right. Find the screenshot attached for your reference.
8.5.2 Activity: stuck at G3 location and P2 Products mapping
Hi, I can not get the G3 location and P2 Products to map correctly. Could you please help?
Level 1 activity 7.2.3 importing and mapping data
Hi, Anyone to help please, I have spent the last 4 days trying to complete this activity. I have followed all the steps but I keep getting errors. I think that there might be some steps missing in the tutorials. Please help me.
Community perspective: Data Hub organization
This article is intended to help assist and standardize Data Hub organization across the Anaplan platform. This methodology is intended to help the technical teams, not end users, navigate and create your Data Hub model and troubleshoot problems with individual data sources efficiently. Functional areas To begin, setup…
3 Improvements for Comments in the New UX
Hi, I'm missing 3 basic capabilities on the current comments' fucntionality to be able to use it for my clients: 1- Comments are not flagged to end user 2- Not recorded in full context (in all dimensions I'm looking at) 3-No option to publish or export from Anaplan This custom fucntionality I built allows me to overcome…
Anaplan Optimizer Demand
Why is Plant Demand not considered an Assumption in the Anaplan Optimizer? "Assumptions are line items with numeric format. They can be calculated or input. If they are calculated, you cannot use a variable as part of the formula." Since Demand would be numeric value, why would it not be an Assumption? You need to be able…
cloudworks process runs but no data transfers
I am using Cloudworks for the first time purely for scheduling transfer of data. I have a process that simply imports data from a module to a list within the same Model. I set the Cloudworks process up and it successfully runs (green tick) However it does not actually import any data. If I run the process (action) directly…
How to execute data load process in parallel from one hub to different spoke models
How to execute data load process in parallel from one hub to different spoke models
Updating Salesforce with Anaplan data in real-time
Has anyone seen an environment where Anaplan updates Salesforce in near real-time? If you have, what tool(s) are you using to run the inter-system integrations? What is the export frequency set at between the systems? We have a use case where an end-user inputs data into Anaplan, then clicks a process button to "submit"…
Help! I'm looking into a performance problem!
At present, there are two workspaces, workA and workB. A process needs to be added to the Action of the first workA to import the data of moduleB in workB into the List of workA. When the amount of data is large, Whether the workB moduleB cannot be opened and edited when the action is executed.

Importing and Exporting Data

Discussion List