Data Integration

Transactional API for Direct Module Data Access
Hi All, Has anybody built a solution using the Transactional APIs to Retrieve cell data for a view yet. There is reference of Denodo Virtualization tool on forums but it does not work for modules above 1,000,000 cells since there is restriction on the API endpoint.
Anaplan Google Sheets Plug-in
Anyone knows why Google Sheets Add-on would really slow down and then not let me sign in on Anaplan on a specific google doc? Could it be because of the size of the google doc? When I try to create connection on a new blank doc - it runs as expected. Thank you
#ERROR! in Anaplan Google Sheet Add on
Hi community, This was meant to be a question, but in the last minute I found out the root of the issue. So I decided to go ahead anyways and post it as a solution, just in case it helps anyone. Using Anaplan add On for Google Sheets, I was getting an #ERROR! value instead of the items of the dimensions of my modules, in…
Anaplan API V2 Line Item Extraction Missing All Fields
I am currently working to extract line item detail via the API V2. Is it possible to have all fields available via the API show even if they are blank? When pulling detail from multiple models the JSON extract will have a different number of headers/columns as I show in this example. To remain consistent is it possible to…
Excel Add-in (Submit data from multi spreadsheets to Anaplan)
Hello, We are using Anaplan Excel Add-in to upload data. We create a write connection with a one module which have Country dimension. Each Country is presented in separate sheet, can we upload data to Anaplan from all these sheets by clicking only one button - Submit? Thank you in advance for help. Best regards, Dominika
certAuthGenerator batch file
Hello All I am trying to run the certAuthGenerator.bat file in order to generate the JSON and CA cert info in order to add to Postman as I need to do an authentication test. I have followed all the steps in Anaplan's documentation. I basically have the .PEM and .KEY files and I have followed the direction to create the…
Excel Add-In Crashing
Does anyone know what causes the crashes in Excel? When I change the department setting and hit refresh, it closes out of excel entirely each time. any suggestions? thanks in advance.
Import Anaplan Data into Spotfire
Hello, Could someone explain how we can import Anaplan data into Spotfire? Is there a specific connector that I should install? I heard there is a Auth 2 connection, but I have a very basic level in all this. Don't know how to handle this. Something that explains step-by-step how to make it happen would be awesome. Thanks…
We'd like your feedback on the App Hub
Hi all, We are currently looking for Anaplan customers to participate in 60 minute research sessions. Sessions will take place remotely from March 2nd to March 11th. Participants will receive an e-gift card as a thank you for their time, if their company policies allow them to receive these. For this session, we will be…
PowerPoint Add-in 1.6, 1.7 "Ghost Installation"
This item has been identified as an outstanding known issue. Issue When installing a later version of our PowerPoint Add-in, if a machine has both 1.6 and 1.7 installed, you will be left in a state where both programs exist in your list of programs but neither function (missing in the ribbon of PowerPoint) and you will…
User unable to refresh a connection on PPT
This item has been identified as an outstanding known issue. A workaround is provided until the issue is officially fixed. Issue The below error message is displayed when a user attempts to refresh a connection after authenticating using the dropdown for login as shown in the image below: Workaround This issue can be…
How does Authentication with CA Certs work?
Why CA Certs? The purpose of this blog series is to give a deeper look on the use of Certificate Authority (CA) Certificates, especially on how this method of authentication works and how to use them for your different integrations. A Quick Recap On Anaplan APIs Authentication We recommend our readers to have some basic…
OEG Best Practice: Data integration decision app
We built this app to make getting started on your Anaplan data integration journey simple with a quick questionnaire and helpful information and links. A common question that arises during Anaplan implementations (or even after go-live) is "How can I automate data feeds into and out of Anaplan?" While the ultimate decision…
Do ignored columns (from imported files) take up space from my model?
Hi guys! Do ignored columns (from imported files) take up space from my model? Thank you very much!
How configure the authentication token in the Talend
Hi @,@ Thank you so much for creating this detailed document. , We are following this to create a Anaplan Integration with Talend. But instead of CA Certificates we are trying to do it with the Basic Auth. If possible can you please let me know how to configure the Components in talend for Basic Auth and share if you have…
As a modelbuilder I would like to use FindItem with a property or line item
I have seen that I am not the only one facing the issue that there is property or lineitem which is neither a code or name of list but it is needed for identification, like a WHERE statement in SQL. Might it be possible to extend the FINDITEM function by an optional parameter to reference a property or lineitem which has…
Model Builders & SAs: Help us understand your model optimization processes.
The Anaplan User Research team wants to better understand the model optimization process, including view clean-up. We are looking for model builders and solution architects to walk us through the process of optimizing/cleaning models. During a 60-minute remote research session, participants will be asked to share their…
Can we capture a tenant-based date/time value?
With CloudWorks, we can schedule based on date/time with a selected time zone, but that is not involved in any user-facing functionality. As I am working through the new Workflow training, I realize that the platform is now providing interactions with end-users based on date/time values in a selected time zone. This has me…
Cloudworks Limitations for a global scale deployment
Hi Guys, I am new to Anaplan Integration. We want to create a standardized design for a deployment which has multiple models based on regions. In the Community it is mentioned that we can have only 500 integrations per tenant is there anyway to increase them. And also are there any limitations for cloudworks if we want to…
Restore deleted Cloudworks elements
Similar to how you can restore models 14 days after deletion but would be great to be able to restore deleted Cloudworks elements in a similar way that exists for models. Or at the very minimum short-term to update the notification box to say that once deleted it's deleted!
Power Query - Get Data from Anaplan
I use Power Query within Excel to connect to online sources such as Salesforce. Is it possible to connect Power Query within Excel to Anaplan and how do I do this? I have seen an article about the Power BI connector but I cannot see a link to where I would download it from or whether I can use this with Power Query in…
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…

Data Integration

Discussion List