-
Anaplan's APIs
Hello, I'm starting to dig deeper into Anaplan APIs and i would like to do a best practice script that exports everything there is in Anaplan (lists, modules, actions) to then parse the data and figure out if there is anything that could be optimized. Is there by any chance someone that has already come up with a similar…
-
Error on Excel Add-In
Hi All, do you know why I receive this error when connecting a view through Excel Add-in? Thank you, Joana
-
Unable to import data from Azure blob via Anaplan Cloudworks
Hi, I'm unable to import data into my list/module from Azure Blob via Anaplan Cloudworks. The connection is correctly created. I can successfully export data from cloudworks to azure and i don't know why i'm encountering issues when importing data. I've tried to import manually the data and actions are correct (import work…
-
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…
-
Does anyone has sample Anaplan Batch Script for importing timestamp value in anaplan?
-
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…
-
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.
-
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?
-
Managing Hierarchy with members moving between levels
What are the ways of Hierarchy Managemnet when, list member are moving between levels? For e.g. the file we recieve from Third Party system, is used to create the hierarchy. This Data Module contains line items referring to various Levels L1, L2….. First Iteration of Data Import gives us say an L7 item with its respective…
-
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…
-
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…
-
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…
-
Data from Anaplan to snowflake
Hi all what's the best solution for moving data from anaplan to snowflake? Thank you.
-
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
-
"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…
-
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…
-
File ID + Module ID via Web Browser
Previously you used to be able to do something like the following in a web browser to get IDs: E.g. https://api.anaplan.com/2/0/workspaces/WORKSPACE%20ID/models/MODEL%20ID/files Now when you try this you get a 401: Not authenticated error. Is this intended behaviour going forward? Can certainly set things up in postman but…
-
Cloud Export Failed - Bigquery Integration
Hello guys, I got a problem when i try to integrate Anaplan to Bigquery through Anaplan Cloudworks. I make the integration successfully, but when I run the integration it shows me an error. You can see the error below. The table in bigquery is also filled, but only 50 rows. I make sure the connection is built successfully.…
-
create a filtered, saved view that displays data for only months in the Forecast period.
Hello Everyone In the Level 1 exercise 12.4.1 Create saved filtered views , I couldnt find how to add filter only for the forecast period Hint: The SYS00 Time Settings module has a line item for only the Forecast period. I couldnt undersatnd this hint and how to apply this filter condition to show only the forecasted year…