-
error parsing key for this row no values" error while importing a list from saved view. In what way
-
Help with level 1 model builder 7.2.3 Activity: Import Data into Employee Details Module
I have blank I don't know how to map them manually as I don't know who is number 2 ? Thank you :)
-
Cloudworks API: Change Schedule
I'm working on a script that would update integration schedule. In future my target is to have a script that would move all my integrations + integration flows +/- 1 hour on DST changes. For updating integration shedule I have sent PUT request to endpoint…
-
Excel add-in save & refresh: possible to fill line item data with formula's in excel?
Hi, Using the Excel add-in, I am curious whether it is possible to auto-populate line item data using formula's in Excel. Can anyone tell me if it is possible to set this up and if so how? As an example: consider a module linked in Excel where cell A7 contains a line item with B7 a number that is editable. Is it possible…
-
Anaplan Excel add-in 4.3 Cloning
I am trying to copy an excel sheet with an existing Anaplan connection into another workbook. However, once the copy is done, the Anaplan connection seems to be broken and cannot be refreshed. I understand that the cloning function currently works within a workbook only, does anyone have any workarounds with respect to…
-
Different numbers being imported
I have 2 modules, both with exactly the same structure (2 dimensions, multiple versions, no time scale, and with only one line item). I created a simple import from one module to the other, however, once the import has run successfully with no errors, I'm getting different numbers landing in the corresponding cells in the…
-
Anaplan Connect: Difficulties setting up export from Anaplan to SQL Server
Hi, We're trying to set up a connection to export data from Anaplan to Microsoft SQL Server. We already have a working connection to import data into Anaplan, but we can't manage to set this up the other way around (export). We set up the export connection using the Anaplan Connect guide and our working import actions. We…
-
Export failed for non Admin users
Hi all, I am currently facing an Export issue: non-Admin users do not get the file xlsx exported, while i can, being Admin user. I have checked all possible reasons: I have checked that export action is assigned to the roles I have set in export definition the default export file for "Everyone" I have saved the view to…
-
Can the current AND previous Start Date and Time (UTC) values be saved?
For daily (or any automated) processes, it would be convenient to see 'version -1' start times. We have dozens of processes that run daily, and this would assist in determining if/what is running as designed when an issue arises. It's cumbersome to examine the History logs.
-
Data from Anaplan to snowflake
Hi all what's the best solution for moving data from anaplan to snowflake? Thank you.
-
Adding new level to existing hierarchy
Hi Everyone, The model has 7 levels of hierarchy for three years now. Would it be advisable to add another level between l6 and l7, taking into account the consequences?
-
"dumps.json file not available" when trying to download error logs from CloudWorks
I am getting the error "dumps.json file not available" when trying to download an error log from a past integration run. At first I thought this was because the logs I was downloading were from a few weeks ago, but now I am getting this error for a run that happened yesterday (I was able to successfully download the .csv…
-
How to set up integration from MS SQL Server table to Anaplan model via Talend
Hi, We are trying to load contents from a table in MS SQL Server table to Anaplan model (processes, actions, etc.) using Talend. So far we are able to make connection to Anaplan model and do the authentication successfully. We are able to view all import ids of the model / process ids / action id. I am following this user…
-
Get authentication token details
Hello I'm currently trying to execute the instructions of the Authentication Service API document: I'm stuck at the step "Get auth token details". I use the software Postman to test the request. I tried the type of authorization "Bearer Token" and fill the field "Token" with the token value that i got with the request HTTP…
-
How can I connect Anaplan to Talend using Anaplan Jar Modules
How can I test if this jar library module is running fine. Anaplan Home Along with this jar file, I also have keystore(jks), pem files too.
-
Integrating to Anaplan with Talend
Hi all, Has anyone successfully integrated a Database result to Anaplan using Talend Studio? I've looked all over and cannot find successful examples of querying a db, using that dataset and pushing it to Anaplan without saving it to a file first. My issue is I cannot get the db result into a format that feeds correctly…
-
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…
-
Anyone who can help me configure the SAP HANA JDBC driver?
I have a SAP HANA JDBC driver (ngdbc.jar") in my ANAPLAN CONNECT lib but am not able to configure it. I have attached a screenshot of the SAP HANA JDBC driver window. https://developers.sap.com/tutorials/hana-clients-jdbc/jcr:content.github-proxy.1698070514.file/JDBC-Driver-Trace-Config.png
-
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…
-
Anaplan cloudworks integration with Dynamic 365
Can Anaplan be directly integrated with Dynamic 365 using Anaplan cloudworks? Or do we need to integrate Dynamic 365 with a cloud data source first?
-
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…