-
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…
-
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…
-
Time change in integration
Hi, After daylight saving time, we have to change our integration timings as well by 1 hour, or it will automatically change the time. Thanks, Vicky
-
Best Practice for Initiating Many Actions via Python Script
I have managed to piece together a script to initiate one of several scripts. Now that I can start one, I would like to ask what is the best practice for starting several? Should the script pause until each action is complete before starting the next one? If so, what would a simple wait and check to see if task is complete…
-
How to integrate from Anaplan to ETRM through API.
Can you please help me on how to integrate data from Anaplan to ETRM, with API's, or if I can get API's script by which I can change workspace and model id and use that script.
-
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…
-
Anaplan Connect - ERROR: Cannot locate anaplan-connect-@rel@.jar
Hello Anaplan Team, Any one the solution for this error in Anaplan connect while running ".bat scripts".I have attached the the error("ERROR: Cannot locate anaplan-connect-@rel@.jar"). I have looked in the User Guide & online but cannot find a solution, appreciate any help Thanks!
-
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…
-
HI All
I want to add one more member in my number list using Action button. My number list is a serial number list which does not contain code but parent is 'Total' for all the members. How to add #11 after #10 in that list using an Action button for end user. The list contains a top level item 'Total'.
-
Anaplan Excel Add-in Series 4 crashes my excel
Hi community, Not sure if anyone encounter such issue, but recently, I have downloaded the latest Anaplan excel add-in and tried to open my excel file. However, before the file fully loaded, it just crashes. However, if I were to open my normal excel file without Anaplan add-in, it opens properly. Any advice on how to…
-
Anaplan API to run a Python Script to Import File and Run a Process
Hoping someone can provide me an example of the Rest API code/syntax (for a Python script) needed to run a process which utilizes a file import to execute several action steps. Have accomplished in Anaplan Connect via the below: set Operation=-debug -service %ServiceUrl% -auth %AuthUrl% -workspace %WorkspaceId% -model…
-
Excel Add-In: Flattened Data with Rows Labeles
Hello! I'm using the excel add-in and, unlike when I export from the model, I am unable to flatten my data and retain all the row labels (A below). Instead they get grouped like they do in the module display (B below is what the add-in is giving me). Is there any way to use the add-in and have it pull the data into excel…
-
Response from adding item to a list. Success but not added or ignored
I'm calling the API to insert an item into the list. { "items": [ { "code": "test", "properties": { "Display Name": "test", "Time/Date Stamp": "2023-10-27 13:19:19", "Amount": "Data Unavailable" } } ]} I'm getting a response back that show it has not been added or ignored. { "added": 0, "ignored": 0, "total": 1, "meta": {…
-
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
-
Excel Addin Issues
Hi, Has anyone recently updated to the latest MS Excel 365 version (2310) and have issues with using the Anaplan Excel addin? For some reason I can no longer open any Excel file that has an Anaplan data table. I also cannot even create one from scratch before Excel force closes itself. Thanks!
-
Anaplan Power BI connector - can't refresh data as a non WSA
Dears, I am using the Anaplan PowerBI connector for the first time. For our use case, we want users to connect to Anaplan from PowerBI and refresh data that will be used for analysis. Some of these users won't have WSA. When I tested this case, I couldn't refresh the data. Instead, I received the error message "the key…
-
Changing source model for select actions in bulk
There are currently two options for changing the source model of an action. The first being in the Import Data Sources section in 'Actions' where users can change the data sources for actions one by one. The second is by going to 'Source models' and editing mapping for a source model. This changes the source model for ALL…
-
Data Integration Challenge: Seeking Guidance on Anaplan Platform
Hello, I am currently working on a project that involves integrating external data sources into the Anaplan platform. recently I completed splunk certification and I am facing challenges with efficiently importing and synchronizing large datasets. Here are a few key points to consider: Data Volume: The datasets I'm dealing…
-
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…