-
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…
-
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…
-
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…
-
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…
-
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!
-
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…
-
Powerpoint Text Help
Greetings, Is there a way other than Copy and paste each word (text), to create 10 separate slides of a 10-word sentence on PPT using a command or Plugin? (Task - 700 to an 800-word essay has to be separated into slides. One word per slide.)
-
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!
-
1.5.6.2 Import Data into Historic Volumes Module | Invalid line item identifier
Hello All, Can someone help me to point where this is going wrong. I am getting Import complete but with failures : Invalid line item identifier please see the screen shots for details. Thank you
-
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
-
Anaplan Api call via postman
Hi, I am trying to call Anaplan API via postman. I tried Authenicate with https://auth.anaplan.com/token/authenticate and generated token Then i tried calling imports pasting the token through the url https://api.anaplan.com/1/0/workspaces/[workspace id]/models/[model id]/imports and its retrieving the data. But i am not…
-
Import Shipping Expenses into OTH01 Module
Import Shipping Expenses into OTH01 Module In the Financial Planning & Analysis model: Import the data from the Supply Chain model into the OTH01 Non Employee Expenses module, Shipping Cost line item. * For department, import into the Sales department. * Run the import. * Results should have none ignored and 0 errors .…
-
[ANAPLAN CONNECT] Execute multiple operation with only one authentication
Hello, I hope you're all doing fine. I would like to seek help on looking for a best practice that could reduce significantly the running time of my anaplan connect script. I am using Anaplan Connect basic Import authentication. The script I am running the script consists in the execution of set of operation for each…
-
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…
-
Process ID
Hi, We are trying to integrate with Onecloud to have automatic uploads of files. For this I need workspace, model, and process ID. I have found the workspace and model id by just looking at the url. How can I find the Process ID?
-
Running multiple export actions in parallel
I am using the API the execute multiple export actions and download the resulting output. I notice that if I start the first export with the call to /workspaces/{workspaceId}/models/{modelId}/exports/{exportId}/tasks Then the request will return in under a second as the export starts. However, if I call the endpoint again…
-
Run Action Concurrency
Hi, I want to check the action concurrency. If several users run the action, Action which first user run will run? The second user's will not run?
-
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…
-
Anaplan API | Add list items to a numbered list by combination of properties as a unique identifier
Dears, I am currently writing an API call to add a list item to a numbered list. Here, i would like to use a combination of properties as a unique identifier, not the regular code. Which has to be specified in the request body. Unfortunately, I haven't found any guidance in the documentation on how to do that (). Does…
-
Saved Export Actions
For saved exports from Anaplan, how does the export remember what to export? I'm used to creating a saved view to represent the export, however, if a saved view is not created and potentially certain list members and/or line items were hidden/visible when the export was created, is that what Anaplan remembers for that…
-
Delete models using Anaplan Connect/API?
Is it possible to delete models using Anaplan Connect/API? A sample script would be much appreciated.
-
How can we add the multiple cloud works actiones in a procees
I have multiple cloudwork action.now i want to add into one process. is there a way
-
Need Advice on Integrating Anaplan with External Data Sources
Hi everyone, I'm working on Anaplan integration with external data sources and could use some advice. Any tips or tools to recommend? Thanks in adavnce!
-
Delta Load
Is it possible to do a delta load in the Anaplan model? Lets say one flat file is uploaded at 10.00 AM with 5 million records and the same file is uploaded at 11.00 AM with 6 million records. I just want to upload the new 1 million records into my model. How can we achieve that? Thank you in advance!
-
404 Error while exporting files from Anaplan process task
url used: "https://api.anaplan.com/2/0/workspaces/{workspaceID}/models/{modelID}/processes/{processID}/tasks/{taskID}/dumps" response.status_code: 404 Description: When the process is run manually from Anaplan app, it runs successfully and downloads the file. But when the process is run via Rest API and waited for the…
-
How to move or copy an excel spreadsheet without loosing connection
I'd like to merge 2 excel files. Both have anaplan connections. How can I move or copy excel spreadsheets to another file withour loosing my anaplan connection?
-
How to I access a failure dump of an action within a process using the API
I understand I can get an import's failure dump if I run the import, then get the task id, then construct a url: https://api.anaplan.com/2/0/workspaces/{WorkspaceId}/models/{ModelId}/imports/{ImportId}/tasks/{TaskId}/dump . My issue is that i'm running a process, which runs a number of imports. One of which has a failure…
-
Replicate A+ for Anaplan Functionality in New UX
Hello, With the New UX, A+ for Anaplan Chrome extension no longer works. I am wondering if there is any current extension developed that can replicate any of the functionality of the former A+ for Anaplan Model Builder Edition Chrome Extension? Specifically, I am wondering if there is the ability for "Improved Colors" that…